Conditional Formatting for Charts in Looker

| Analytics , Looker ,

It is important to draw attention to data points that causes critical changes to your data. This is when the Conditional Formatting feature comes handy. Conditional formatting for charts is very useful to gain insights about the performance of your data. In this blog, we will walk you through the steps for creating a chart with conditional formatting in Looker using “Table Calculations”.

Step 1: Open your Looker dashboard. Click on the “Edit” option in the top right corner of the dashboard as shown below.

conditional-formatting-for-charts-in-looker

 

Step 2: Pick one of the chart’s in the look and then click on the Edit symbol on the right corner of the look as shown below. In this example we have used a chart with “Product category” and “Product Count” data.

looks-in-looker

Step 3:  A window as shown below appears. Click on the calculation option (highlighted) on the top right corner of the data bar as shown below.

add-calculation-looker

Step 4: Click on the calculation field and a window will pop up. Type in the calculation name and formula, then click on “Save Table Calculations”.

add-calculation-looker

Step 5: Once done, it will display values that are >800. For values <800 create another calculation field by clicking on “Add table Calculation” as mentioned above.

add-table-calculation-looker

Step 6: Now, hide the original data from the visualization – click on the gear icon and select “Hide from Visualization” as shown in below.

hide-option-looker

Step 7: The visualization will appear as shown below.

conditional-formatting-in-looker-charts

Step 8: You can change the colors of the data points by clicking on the gear icon in the visualization bar as shown below.

conditional-formatting-in-looker-charts

Step 9: Sort the count as ascending or descending and save the changes of the look by clicking on the Save in the top right corner of the Look (highlighted below).

conditional-formatting-for-charts-in-looker

Step 10: The look will now appear as shown below. Click on “Done Editing” on the top right corner of the dashboard.

conditional-formatting-for-charts-in-looker

Conditional formatting has been applied to the chart. For more information on conditional formatting for Looker, contact us.

Share with:

FacebookTwitterLinkedIn