1 of 1 people found this helpful
For conditional formatting, you can just drag the measure onto "Colour" on the Marks tab, and make your marks type into "Square"
Alternatively you can use the "Heatmap" option under the "Show me" menu.
For the sparklines (trendlines) you can refer to the following blog for a step by step walk through
Hope this helps
Thank you Jessica. This works great for me, however do you know how to exclude an attribute within a table? It works for my percentages, however I don't want to include the Count of Account IDs for the conditional formatting. Please refer to my original picture.
If you do not want to see a particular attribute then you should exclude it from the rows/columns shelf.
The conditional formatting (colour mark) should be based on your percentages measure, and that is the only thing to affect the overall colouring.
Please attach your workbook (.twbx format) if this is unclear or if I have misunderstood your question
I need it to be in the measured values shelf. However, I just added it to the columns shelf rather than the rows.