Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Good morning every one.
I want to create 3 gauge chart based on type mentioned in the below table
3 expression -Count of each type
count of closed
and count of open
Type | ID | Status |
A | 188497 | Closed |
A | 188423 | Closed |
B | 188422 | Closed |
B | 188420 | Closed |
C | 188415 | Open |
A | 188391 | Open |
Use Pie chart it will give you what you need
Thank you.
Gauge representation is not possible?
On what purpose you are looking for the Gauge chart only. As per your requirement, pie chart would be meaningful for the first condition ( "Count of each type").
Use Expression like this:
=COUNT({<Status={'Closed'}>} Status)/Count(Status)
or for Type
=COUNT({<Type={'A'}>} Status)/Count(A)
Or
=COUNT({<Status={'Closed'}>,Type={'A'} Status)/Count(Status)
But you will end up with 6 gauges:
For each Type status is Open or Close.
Hi,
I hope this would help.
Regards,
Neha
Nice one.
Just change the Gauge Setting - MAX to Count(ID) and the Major Unit to 7.
This will not be dynamic thu if we have more types.
Nice Job Neha