topic Re: Conditional Formatting Totals in Aggregated Table in Dashboards & Analytics Discussions

Conditional Formatting Totals in Aggregated Table

braupe — Tue, 14 Jun 2022 19:20:24 GMT

Is it currently possible to apply conditional formatting to total columns/rows within an Aggregated Table insight? Conditional formatting of individual attributes of rows/columns can be adjusted easily within the pill; however, I cannot identify a way to apply these conditional formats to the total columns/rows.

Thanks.

Re: Conditional Formatting Totals in Aggregated Table

SohaylaI — Wed, 15 Jun 2022 14:22:42 GMT

Dear Braupe, currently this is not an option, it is under consideration but we would like to know more about your use case.

Re: Conditional Formatting Totals in Aggregated Table

JoeM — Wed, 15 Jun 2022 14:28:49 GMT

@braupe - Thanks for sharing! As @SohaylaI mentioned: it's a valuable ask, but not currently on the roadmap. Would you be willing to post this as an idea on the ideas forum?

This will allow others to upvote it and comment on their use cases. This in turn can influence feature development on the roadmap.

Re: Conditional Formatting Totals in Aggregated Table

braupe — Wed, 15 Jun 2022 14:57:01 GMT

Hello @SohaylaI and @JoeM, below is an example of a simple conditional format where we want a positive value to show green (red negative). This works for the individual attribute columns but not the total column.

I will submit as an idea as well.

Re: Conditional Formatting Totals in Aggregated Table

JoeM — Wed, 15 Jun 2022 19:10:36 GMT

Thanks for sharing @braupe! Also thanks for posting the idea!

Re: Conditional Formatting Totals in Aggregated Table

dylanwan — Wed, 15 Jun 2022 19:32:37 GMT

I am not sure if this satisfies your requirement.

Typically, the total or subtotal shows as own rows when they are enabled in an aggregated table. However, by using the level based measure, the total/subtotal values will be repeated as a separate column. It is then possible to apply conditional formatting on these column and the conditional formats appear on their child rows.