Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This is giving me fits, I have a Field, Response_Time, that is bucketed into different SLA time brackets (Live, Electronic and Other) from a call center application. I have an IF Expression statement working to select/count the call data according to the dynamic GetFieldSelection(xxxxxx) but can't get the Expression Label to work dynamically for the heading.
=if(GetfieldSelections(Call_Source)='Live','< 1 minute') works But extending it with another If like the Data selects doesn't.
=if(GetFieldSelections(Call_Source)='Live','< 1 minute'), if(GetFieldSelections(Call_Source)='Electronic','< 5 minutes'), if(GetFieldSelections(Call_Source)='Other','< 7 minutes'),
Thanks
David Rowe
Leave off the GetFieldSelections() and just try:
=if(Call_Source='Live','< 1 minute'
, if(Call_Source='Electronic','< 5 minutes'
, if(Call_Source='Other','< 7 minutes'
, '????'
)))
-Rob
Is only one Call_Source always selected?
-Rob
Yes, only one source.
Leave off the GetFieldSelections() and just try:
=if(Call_Source='Live','< 1 minute'
, if(Call_Source='Electronic','< 5 minutes'
, if(Call_Source='Other','< 7 minutes'
, '????'
)))
-Rob
Thanks Rob. Good pointer, made sense as a single source.
DR