Looker Connect Training

Help Center

Documentation

Community

Cloud Certifications

Question

Progress Bar Setup in Single Value Chart

  • 19 February 2019
  • 3 replies
  • 1283 views
T

The following article (Show Comparison: https://docs.looker.com/exploring-data/visualizing-query-results/single-value-options) shows an example of progress bar in a single value chart using a table calculation. However, there doesn’t appear to be any documentation on how to setup the calculation for the monthly target. In my attempt to add a number via the calculation, Looker places the new calculation in front of the measure (with no ability to move it) which prevents the comparison option from working.


Thanks… Tom

3 replies

izzy
Userlevel 7
Badge +1

What’s your calculation look like? In order to use the comparison option, the table calculation must reference a measure— So something like 1000+50 won’t work, since that’s not referencing a measure and will be pushed over to the left as a dimension. If you just want to hardcode a value, the little workaround is to say (${measurefield}*0)+1050.


Including the measure in the calc, even if you multiply it by 0 to tare it out, will apply it to the explore as a measure and give you the comparison. Give it a shot 🙂

T

Thanks Izzy. Worked like a charm. 🙂

Pierre_Cohen

Hey,

Can’t we choose which fields between the actual number and the target we want to have a color for ?

Thanks !

Reply


Terms of Service