Add a Percent of Total Row Totals Option

Fabian Koenig shared this idea 15 months ago
Idea Logged

When building a cross-tab report, if you set a Metric's Aggregation to Average, then the Column totals no longer make sense in terms of using a Percent of Total Advanced Function:

/Tak8lAABAgQIECBAgAABAgQIECBAgACBiMAHns0JkiljFDAAAAAASUVORK5CYII=

As you can see above, neither the Row or Column Totals are correct.

If you use SUM, it correctly calculates the Percent of Total at the column level, but it also SUM's the row values, which provides for undesired values:

/w9X+3qWfl97GAAAAABJRU5ErkJggg==

Instead for the Row Totals column, it'd be nice to have an option for using Percent of Total there

Comments (3)

photo
1

Hi Fabian,

Thank you for your Idea. I've gone ahead and logged this as an enhancement request in our internal tracking system. Any potential updates regarding this will be posted here.

Regards,

Mike

photo
1

Thank you very much, Mike!

Very much looking forward to this feature being considered as a future enhancement to Yellowfin.

I think in order to properly calculate the percentages of total in the TOTAL columns/rows one would have to be able to specify the following in the Advanced Functions options:

  • across which dimension the totals should be computed (i.e. what amounts to 100%). In the example above:
    - whether it is by the years, thus the rows would amount to 100%, showing the proportion each year contributes to the total (100%) across all years within each demographics group and for the overall total
    - OR whether it is by the Camp Demographics, thus the columns would amount to 100%, showing the proportion each demographics group contributes to the total (100%) across all demographics groups within each year and the overall total.


Thank you & Best Regards

Fabian

photo
1

Hi Fabian,

Thank you for your feedback. I've made note of this in the internal task.

I'll keep you posted.

Regards,

Mike