Hello! I have a table, similar to the mock-up I've pasted below. I need to colour-code the cells in my "click/impression%" ratio column depending on whether their % values are greater or less than the total average % value (so the values lower than 3.2% need to be red, higher values green). The end-user can use multiple filters (eg date range, country, brand etc), so the 3.2% would change depending on their selection. Each time, I'd like the colours to adapt depending on their value versus the overall average %. I've tried various calculated fields to use for colour, but just can't get it to work. Any ideas? TIA
Hi @Tonia Perretta
"Buon Giorno" ! Hope all is well on your side. Here is a
very simple solution to your problem (hope it works 🙂).
I simply modified your color formula by replacing the Table
calculation by a LOD calc. and added the filters to context
(for the LOD calculation).
I have attached the twbx file below. let me know if you have
any questions. Hope this was helpful and correctly answered
your question. Take care, Best wishes & "Ci vediamo a piu tardi"
Sincerely,
Soumitra
