Pivot Table

Reply
Highlighted
Yellow Belt

Pivot Table

Is there a way to do conditional formating based on another column directly in pivot table?

 

Example: color in green if value in column A > then in column B

 

Thanks 

Tags (1)

Accepted Solutions
Major Red Belt

Re: Pivot Table

Hey @Lara,

 

It's not currently possible to set color rules of off the two columns you're comparing. The column the conditional formatting is applied to needs to be a static value in the visualisation as well. You could create a column that gives the difference or even just flags the rows where column A > column B and set a rule off of that column.


Thanks,
Jake
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"

All Replies
Major Red Belt

Re: Pivot Table

Hey @Lara,

 

It's not currently possible to set color rules of off the two columns you're comparing. The column the conditional formatting is applied to needs to be a static value in the visualisation as well. You could create a column that gives the difference or even just flags the rows where column A > column B and set a rule off of that column.


Thanks,
Jake
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
Yellow Belt

Re: Pivot Table

Thank you!!

Major Red Belt

Re: Pivot Table

user08705,

 

Than you for reaching out! Applying conditional formatting based on a different column is not currently a feature in Sumo Cards (where pivoting is available). Please search our Ideas exchange here https://dojo.domo.com/t5/Ideas-Exchange/idb-p/Ideas. If your idea exists then vote it up, otherwise submit your idea so others can vote it up.


Darius Rose
**Say “Thanks” by clicking the “heart” in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
Visitor

Re: Pivot Table

Hi ,

 

Can we add beast Mode functionality in SUMO cards?

Please reply if you found any solution for this.Thanks

 

Thanks & Regards,

Rashid

 

 

 

 

White Belt

Re: Pivot Table

I reading this information: https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Building_Each_Chart_Type/Pivot_T...

 

Where is this located when creating a new card, Pivot Table?

Announcements
Looking for the latest Community solutions? Please visit our accepted solutions board here!