SUM of AVERAGE(Amount) grouped by Approval Date

[Ahmad]

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  

[dylanwan]

Your requirement should be addressed by building insights over a result set.

Building a result set is like creating an aggregate table insight, and the data will be available for building the insight.

The result set in your case will have the AVERAGE(Amount_granted) grouped by (Approval Date column).  The insight will sum the value returned from the result set.

It is similar to write a SQL with the FROM clause subquery.

Hope this help.