topic Adding a colour gradient to a table/pivot table in App Development

Adding a colour gradient to a table/pivot table

krisk — Fri, 28 Apr 2023 15:42:22 GMT

I am looking to add some conditional formatting style background colours to my tables/pivot tables. It would be nice to be able to have a colour gradient where dark green is the highest value in the column and dark red is the lowest value in the column.

I am aware that you can use expressions to color by expressions but I am unsure about how to write an expression to do this.

Is there another way to achieve this? or will I have to find a way to use expressions?

Also, are there any other ways we can add conditional formatting style backgrounds in our tables, such as sparklines, data bars etc?

Many thanks for reading and any help you can give me.

Re: Adding a colour gradient to a table/pivot table

Chanty4u — Fri, 28 Apr 2023 15:53:50 GMT

May be this

Click on the "Appearance"

Then "Conditional" under the "Background Color" section.

Select expression

=ColorMix1(

FirstSortedValue(FieldName, -FieldName),

FirstSortedValue(FieldName, FieldName),

0.5)

Re: Adding a colour gradient to a table/pivot table

krisk — Fri, 05 May 2023 14:49:55 GMT

Thank you for this.

The column in the pivot table that I was trying to add a colour gradient to is populated with a measure, and it seems like I cannot put a measure into this calculation.

For reference, my measure is called 'Total Orders'.