Conditional Formatting on Period-over-Period columns (e.g. percentage change)

Feature Suggestions
1

Hello there!
I am currently using the Period over Period comparison in my tables to see the performance of my social media campaigns in terms of CPC and CPL. This feature works okay but, it would be really nice to be able to color code +% in green and -% in red for a better view for the end user on performance.

Thank you!

2

Hello @mariemcht,

Thank you for your helpful input! We are aware this issue is quite annoying when you want to look at the values of the change in a colorful way.

I will be sure to bring this request to the product team for further discussion. I will let you know if this feature is released.

Cheer!

1 Like
3

Hi,

Is there any update on this feature being added? Weā€™ve developed a dashboard and it would be great to add conditional formatting on the PoP comparisons :smile:

4

Hi @Cherice

Thanks for raising this request! We are collecting more inputs to prioritize this improvement in the next few months.

May I confirm if you have the same goal as Mariem above: able to set conditional formatting for the ā€œ% changeā€ column in Table with Period-over-Period comparison?
Also, can you share if you only need Single-color formatting for your use-case, or do you need to demonstrate the ā€œ% changeā€ in a Color scale?

5

Hi @vu.duong , thanks for following up! Yep itā€™s the same as above that weā€™re looking for.
What weā€™d like is just single colour formatting ie red if the % change is negative and green if the % change is positive
Thanks!

1 Like
6

Noted with thanks, Cherice!

And I agree this would help visualizing the comparison much better. Let me get back to you guys once we have a plan for it.

1 Like
7

Following up, I also need this. Is there any update on being able to conditionally format colors based on value? Even a simple ā€˜red if negative, blue if positiveā€™ would be very helpful

8

Hi @gwizard, @Cherice, @mariemcht, and everyone,

Thank you for reaching out! While we currently donā€™t plan to support conditional formatting for Period Comparison directly, I recommend using AQL metrics for this purpose.

With AQL, you can create metrics for period comparisons. These metrics are treated as fields in your visualizations, allowing you to apply Conditional Formatting in data tables or customize colors, data labels, and more in other charts.

aql-relative-period

For more details on using AQL for Period Comparison, check out this documentation: Compare Between Periods | Holistics Docs (4.0)

Hope this helps! :love_you_gesture:

1 Like
9

This topic is similar to this topic in terms of its subject matter.

I would like an option to set up conditional formatting on relative period-over-period (PoP) columns. This is the most important area where I want to use it.

10

Hi @Jan_Lupac

Weā€™re actively working on a new feature called Advanced Period Comparison. In a nutshell, itā€™s the point-and-click solution for the AQL writing route which @Theodore has described in the thread above.

Because the period-over-period columns are basically AQL metrics in the visualization, youā€™ll be able to set up conditional formatting and data alerts for them. This solution will also solve other use cases which the current Period Comparison toggle canā€™t do, such as creating PoP for only specific fields instead of all fields, displaying only % change without showing the previous values, or comparing multiple periods, etc.

Our tentative release timeline is in Q4. Weā€™ll let you know when thereā€™re new updates.

Thank you for your patience! :slight_smile: