Leveraging icons in Compare Tables

Yesterday’s blog was focused on using Sliding Windows in Compare Tables to make new calculations. Today we will do an exercise leveraging icons in Compare tables!

So we already know we can easily make calculations with Sliding windows but let’s say you’d like to add a checkbox to flag Opportunities over x amount of dollars. In order to do this, you can simply search for icons and add them within your formula!

1) First step is selecting your Dataset and creating a new lens. For this exercise I’ll leverage my Opportunities Dataset to create a new lens grouped by Account Name, adding Sum of Amount as my measure

New Lens based on Opportunities dataset

2) Next, switch from Chart to Compare table and clone the Amount Column so you have Column A: Sum of amount and Column B: Clone of sum of amount. Once Cloned you will hover over Formula and add the next formula: case when A >= 500000 then "☑" else "𝥺" end

Compare table > add formula: case when A >= 500000 then "☑" else "𝥺" end and hit Apply to see the changes

That’s it! Keep in mind you can replace the formula with other icons you find online =)

Hope this was insightful!