Guagechart help

[suryakant241187]

Hi Team,

I need to create gauge chart with 2 colors Green and red and condition is Allocation type = Allocated and Blocked will be green while Blocked will be red. Also i need calculation in the % format.

i am attaching the sample data.

please help.

Suryakant

[thevingo]

Hi

1. the gauge chart works on numeric values, so what is value/calc in your case.

I think you need to re-consider your use-case

2. Blocked should be Green or Red

[suryakant241187]

count of Allocated and Blocked should be green while count of available should be red

[thevingo]

So if I select Mumbai, gauge should show what value 6 or 2 or 10?

Workstation Number	Allocated	Available	Blocked	(blank)	Grand Total
Chennai	5	2	2		9
Mumbai	6	2	2		10
Pune	5	1	3		9
(blank)
Grand Total	16	5	7		28

[suryakant241187]

If you select Mumbai

Then count of Allocated+Blocked will be green( 6+2)

and availble will be Red

[thevingo]

but gauge can only show 1 value so either 6 or 8 or 2 or.... but not all 3 values

So you can use 3 separate gauges or text-boxes for Alloc, avail & block

Or

Arrange 3 text boxes, to look like a single gauge chart

[suryakant241187]

it will be 8

[thevingo]

Sorry

I can't figure out, maybe someone help!

stalwar1‌

bohravanraj‌

[sunny_talwar · Accepted solution]

May be something like attached