Guge chart help

[Anonymous]

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

[sujeetsingh]

Use Pie chart it will give you what you need

[Anonymous]

Thank you.

Gauge representation is not possible?

[senpradip007]

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").

[robert_mika]

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.

[neha_sri · Accepted solution]

Hi,

I hope this would help.

Regards,

Neha

[robert_mika]

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.

[agni_gold]

Nice Job Neha