topic How to gradient Cell background in straight table? in App Development

How to gradient Cell background in straight table?

lwp89 — Wed, 20 Apr 2022 19:14:54 GMT

How to get the gradient shade from green to red on the cell background?

Dimension is Product Name
Measure is the percentage of order completed.
My measure expression is Sum([Completed]) /sum( [Scheduled])

If higher the number the redder it should get. below is the RGB color that I have used in other charts, so I would love a gradient background on that table

RED = RGB( 210,34,45)
GREEN = RGB(35,136,35)

Thank You

Re: How to gradient Cell background in straight table?

justISO — Thu, 21 Apr 2022 06:19:35 GMT

Hi, maybe something like this?:

colormix1(Sum([Completed])/Sum([Scheduled]), RGB(210,34,45), RGB(35,136,35))

Re: How to gradient Cell background in straight table?

vinieme12 — Thu, 21 Apr 2022 11:05:06 GMT

You can also manually calculate the gradient RGB based on the rank

Try below

RGB(

//R
35 +
(
((210-35)/(Count(distinct total Product)-1) ) * (rank(Sum([Completed]) /sum( [Scheduled]))-1)
)
,

//G
136 -
(
((136-34)/(Count(distinct total Product)-1) ) * (rank(Sum([Completed]) /sum( [Scheduled]))-1)
)
,

//B
35 +
(
((45-35)/(Count(distinct total Product)-1) ) * (rank(Sum([Completed]) /sum( [Scheduled]))-1)
)
)