Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be something like attached
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
count of Allocated and Blocked should be green while count of available should be red
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 |
If you select Mumbai
Then count of Allocated+Blocked will be green( 6+2)
and availble will be Red
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
it will be 8
May be something like attached