SUM of AVERAGE(Amount_granted column) grouped by (Approval Date column)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-08-2025 02:57 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-16-2025 05:54 AM - edited ‎01-16-2025 06:17 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-18-2025 11:25 PM
Unique Approval Date for each row , there is no duplication
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-20-2025 02:48 AM
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
