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.