Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I have to show bandwidth utilization on sheet for each transponder using chart. There are 57 transponder in data. With field allocated_capacity and utilized_capacity.
I m placing 57 guage chart with hardcoding transponder-id and readings for each transponder. But problem arrives when user narrow down selection and some chart shows bad min value in guage and looks of sheet went offward.
Is there any other way to represent it?
for reference and better understanding
Not sure how many error conditions are possible, but for one, if the user selection is such that NO U_CAPACITY values corresponding to TRANS_ID=29 and PRODUCT_NAME=C-BAND exit (meaning sum({<TRANS_ID={29},PRODUCT_NAME={'C-BAND'}>}) = 0), you may get this error.
The issue is then likely related to the Max value in the Presentation tab. If so, there are several solutions, depending on your need/preference: