topic Re: SUM of AVERAGE(Amount_granted column) grouped by (Approval Date column) in Dashboards & Analytics Discussions

SUM of AVERAGE(Amount_granted column) grouped by (Approval Date column)

Ahmad — Wed, 08 Jan 2025 10:57:27 GMT

How can I create a KPI with a formula that contains the following:

SUM of AVERAGE(Amount_granted column) grouped by (Approval Date column)

i want the right formula that give me Total of average amount_granted group by approval date

Re: SUM of AVERAGE(Amount_granted column) grouped by (Approval Date column)

Shashidhar — Thu, 16 Jan 2025 14:17:26 GMT

Hi,

Please confirm do you have duplicate dates in your Approval Date column? or could you please attach screenshot of the data?

Regards,

Shashidhar.S

Re: SUM of AVERAGE(Amount_granted column) grouped by (Approval Date column)

Ahmad — Sun, 19 Jan 2025 07:25:10 GMT

Unique Approval Date for each row , there is no duplication

Re: SUM of AVERAGE(Amount_granted column) grouped by (Approval Date column)

Shashidhar — Mon, 20 Jan 2025 10:48:55 GMT

Hi Ahmad,

I have tried the same on my dataset. Below are the attached screenshots for reference.
KPI1 & KPI2 both gives same result. But KPI1 is faster than KPI2 actually. If its not giving correct result, let me know.

Regards,

Shashidhar.S