Add a Percent of Total Row Totals Option

Fabian Koenig shared this idea 22 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:

/49be1e973d9cff9b39cdeb02833e386c

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:

/a7d98a2364477388b65577ce1ca99995

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

Comments (5)

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

photo
1

Hi Mike,

Has this request progressed at all? I have a client that would like to do this also.

Regards,

Peter

photo
1

Hi Peter,

This is Eric filling in for Mike as he is away this week. I checked on the developer task for updates, and it looks like the priority on this Enhancement request has been raised to High recently. I've added your organization as an affected client to the task, and asked for a status update on your behalf. Will keep you updated here.

Thanks, Eric