Conditional formatting based on previous month

Hi Elodie,

I’m not sure how exactly you’d like to view your metric, that can be an interesting user experience case.

Here is two options I see, please let me know if it helps.

 Option 1 : Use a table to display both the metric, plus the variation

• Add your metric in a table

• Click on the metric’s options : Add this metric again

• Click on the new metric’s options : Show value as : MoM%

• Apply the needed conditionnal formatting on this Show value as so you can indentify quickly the decreases / increases Month over Month.

• Save the view

Option 2 : In your metric, create a new view to Show value As

If you prefer to remain in your metric, you can create a new view showing the variation:

• Duplicate your current view
• Click on the metric column header’s options : Show Value as : MoM%
• Apply the needed conditionnal formatting on this Show value as so you can indentify quickly the decreases / increases Month over Month.
• Save the view

Please let us know if you were expecting something different?

Best,