Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a chart in which I need to display the selected Group Service API value , I have Tree box as the filter , when there is only 1 value for the Group the Title does not display unless and until a explicitly select a ServiceAPI value , please find the attached file for example record. How do I fix this?
Thanks
I'm still a bit confused... for the example -just as it's downloaded- to show the title of the 2nd level service API it can be:
=if(GetSelectedCount([Group-Function]),SubField(MaxString([Group-Function]), '|', -1) ,
...
For selecting the 1st level API level and that doesn't unselects the 2nd level...well, it would need a bit of work and I prefer not doing it until I'm sure of what you're looking for.
I didn't understand your question. Could you please elaborate a bit.
Hi, not sure if you're looking for a condition like:
GetPossibleCount([Group-Function])=1
...
If there is only one possible value for [Group-Function], no matter if selected or not, it returns true.
My condition is to display the line chart and the title for the selected service API , this works fine when a API is selected from the drop down but does not when there is only 1 service api for a group. I want the chart to display the title with that one value when group has only one value .. (or ) not to show the chart until that single service api value is selected.
I think I am looking something reverse of this , if there is only single value for a group show that value in the charts as title or else do not display the line chart until and unless that single value for that group is selected.
Please let me know if that does not make sense , take a look at the attached app to see a sample record. !
May be this
=GetSelectedCount([Group-Function])
I'm still a bit confused... for the example -just as it's downloaded- to show the title of the 2nd level service API it can be:
=if(GetSelectedCount([Group-Function]),SubField(MaxString([Group-Function]), '|', -1) ,
...
For selecting the 1st level API level and that doesn't unselects the 2nd level...well, it would need a bit of work and I prefer not doing it until I'm sure of what you're looking for.
Thank you ! That's exactly what I am looking for.