Gauge Chart - maximum value : Portal

Start a new topic

Answered

Gauge Chart - maximum value

Hitesh Pau

started a topic 8 months ago

For a Gauge Chart, can the minimun and maximum range be a variable instead of a hard coded number? I am trying to show how many addresses don't have the country value. My minimum can be 0 but the maximum = total number of records in the address table. Is there a way to do that?

Best Answer

Bharat Joshi said 8 months ago

Hi Hitesh,

It is not possible to add variable in the range however you can add target goal to which the chart value is compared

2 Comments

Bharat Joshi

said 8 months ago

Answer

Hi Hitesh,

It is not possible to add variable in the range however you can add target goal to which the chart value is compared

Ambuj Srivastava

said 7 months ago

Hi Hitesh,

The minimum and maximum range expects a numeric value and consider model variable as string. Setting up dynamic range using variables are currently not supported.

If you may try to put below statement:

COUNT(Address) OVER() as "TotalRecords"

in chart query and change chart type from Gauge to Pivot/Bar/Column chart , it will help you to distinguish between the actual number of addresses vs. total number of records present.

Let me know if that helps.