
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Average per month using Avg/Aggr
Hi, having an issue with getting to a monthly spending customer average and wonder if someone can help - sure it's come up before but not been able to find a fix. The below is an example of the calculation I'm trying to get to, with each particular store as the dimension. So from that table I'd want to show Store 1 - 339, Store 2 - 628 and so on
Store 1 | Store 2 | |
Month 1 | 342 | 658 |
Month 2 | 350 | 622 |
Month 3 | 301 | 599 |
Month 4 | 312 | 607 |
Month 5 | 378 | 633 |
Month 6 | 371 | 650 |
Average | 342 | 628 |
Using the Avg & Aggr functions gets me to an average across the whole group of stores but doesnt show with the branch as dimension, expression = avg(aggr( sum(SpendingCustomers), Month) ??
Thanks
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this
Avg(Aggr(Sum(SpendingCustomers), Month, Branch)


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you @Sunny, I want to extract the min and max values on StDev. How could I make this?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Min(Aggr(Sum(SpendingCustomers), Month, Branch)
Max(Aggr(Sum(SpendingCustomers), Month, Branch)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Min or Max on StDev? Can you elaborate with an example?
