Knowledge Drop

Do we have a Pareto visualization?


Userlevel 5
Badge
  • Looker Staff
  • 172 replies

Last tested: Oct 14, 2020
 

No, but there exists a Feature Request.

However, we can imitate a Pareto chart by creating a few table calculations.

 

  1. Create a table calculation to compute the relative running total of the original measure. In this example, “orders.count” will be our starting measure.
 

running_total(${orders.count})/sum(${orders.count})

 

  1. Plot the new table calculation as a line.
  2. Plot the original measure as a bar.
  3. Create a table calculation for an 80% benchmark of the original measure.

 

max(${orders.count})*0.8

 

  1. Plot the benchmark as a line and add it to the same axis as the original measure.

The final result will look something like this:

An imitation Pareto chart using table calculations.

 

 

This content is subject to limited support.                

 

 


3 replies

@sam thanks for the answer, it was useful! How do you get to put a reference line for 80% in a table calculation? My line insist in be linked with the original measure.

 

Userlevel 5
Badge

Hey @AnaLimaPS , great question. I may have misspoke, I can’t see a way to get that right now using reference lines :thinking:

 

But what about table calculations? I created a new table calculation as max(${orders.count})*0.8

and then changed it to a line  while adding it to the left axis. The result looks something like this:

 

​​​​​​Adding a black line to represent 80% of the maximum value.

If this looks good to you, I can add it to the main post!

This solution works, you can definitively add it to the main post. Thanks again @sam!

Reply