2 Replies Latest reply: Sep 28, 2012 1:51 PM by DJ Gibney RSS

    Aggregating over a calculated dimension

      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!