Gauge chart with maximum range as the total number of documents

I want to create a Gauge chart, consider I have a field named state and I want to represent the maximum range as total number of records and one value in the field state is closed, Now I want to represent it as the percentage of total records. And also I want to have four color ranges based of percentage 0-25%, 25-50%,50-75%,75-100%.

Note : Field state is string data type

Please let me know if this would be possible.

Thanks,
Aswanth Jabba.

I found a way to do this, I used filter ratio to get the percentage

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.