Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
Currently I am using Gauge Chart the Digital Numbers style on which I am setting the Dimension:
=BC='BC1' and then using the expression: =(if(BC='BC1',Avg(BC Score)))*100, which gives me the results I want but people do not like the greyed out area on the charts for the bits not on so I need to change it to Text Object.
How can I transfer this to Text Object? How do I force the =BC='BC1' on the Text Object?
"If" is not enough and generally this is not on, but I want this Text Object to look only at BC Score at BC1 level.
I guees i dont get correctly what are you planing to do, but with Set Analaysis on the text object would be enough? Something like this?
Avg({<[BC] = {'BC1'}>} BC Score)
Regards!
I guees i dont get correctly what are you planing to do, but with Set Analaysis on the text object would be enough? Something like this?
Avg({<[BC] = {'BC1'}>} BC Score)
Regards!
Perfect! Thank you very much, exactly what I was looking for.