Hello 👋 Another question from Vasco 🙂 I'm playing with cohorts analysis, and I'd like to display it using the table report with custom background colors depending on the distribution of the values, eg. based on the median. Right now I was only able to apply a static mapping for value ranges but not very useful in our case, in fact I want something similar to the heatmap but for the table, is it possible?

Hello Laurent, you can apply conditional formatting to display a different color based on the percentage. For example:

[>=.9][backgroundcolor=990000][white]#,##0%;[>=.8][backgroundcolor=A31919]
[white]#,##0%;[>=.7][backgroundcolor=AD3333] [white]#,##0%;[>=.6]
[backgroundcolor=B84D4D][white]#,##0%;[>=.5][backgroundcolor=C26666]#,##0%;
[>=.4][backgroundcolor=CC8080]#,##0%;[>=.3][backgroundcolor=D69999]#,##0%;
[>=.2][backgroundcolor=E0B2B2]#,##0%;[>=.1][backgroundcolor=EBCCCC]#,##0%;
[backgroundcolor=F5E6E6]#,##0%;--

Not sure if this is what you tried already, I am afraid at this time this is the only option I can offer, but please feel free to specify your use case, I would like to share it with our developers.

Hi Laurent, would you be willing to share why the heatmap does not fulfill your needs?

for example, having green/red cells when above/under the median

🎉 New note created.