I have a chart that shows counts of invoices over 2 dimensions- Quarter, and a calculated dimention called Deal Size. I would like to show the Invoice Count as a percent of total. This would normally be as easy as selecting the "Relative" checkbox on the expressions tab of my chart, but when I use that method it actually shows the percent of the total invoices across all quarters. I would like it to show the percent of invoices for each given quarter, meaning each quarter adds up to 100%.
I was hoping I could solve this with the aggr function, but I would need to aggregate over my calculated dimension which does not seem to work. I'm sure I'm not the first person to want to do this, but I was unable to find an existing thread on this topic.
I've attached an example of my chart, thanks in advance for any help with this!
