I am creating a Gauge Chart but I cannot add more than 1 measure. Is there something I am doing wrong?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
I am creating a Gauge Chart but I cannot add more than 1 measure. Is there something I am doing wrong?

And also I want to change the legend range to use the calculated field.

Photo of Sethu

Sethu

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of Susan

Susan

  • 0 Points
Hi Sethu,

You are not doing anything wrong; the native Gauge chart will only let you add one measure. You can have the calculated field used as the measure in the report. You can define the legend ranges in terms of % of the goal. It will let you use dynamic filters on the report as well. 

It may be, however, that you want a different chart type than a gauge if you want to show how two different measures are performing. If you want to show how two different things are comparing vs a goal, you might better use a combo line and bar chart. Or, it could be that your analytics needs are complex enough that you need to develop some custom charts in a platform like High Charts. You can learn more about picking chart types and more about gauge charts in particular here: http://www.quickbase.com/user-assistance/Default.html#chart_view_type.html#gauge 

At CloudBase Services, we frequently help clients determine how to best display data to focus on relevant business results. Please feel free to reach out to us at 510-526-5690 if you want to discuss the right chart type for your needs. 
Photo of Craig

Craig

  • 0 Points