Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm wanting to show a value in a chart if it is selected in the filter or if nothing is selected.
I have tired using:
(GetFieldSelections(SevenDayTaskCompletionTimeStatus) ='Complete - No Due Date') or GetSelectedCount(SevenDayTaskCompletionTimeStatus)=0
and
wildmatch(GetFieldSelections(SevenDayTaskCompletionTimeStatus),'Complete - No Due Date'')
or GetSelectedCount(SevenDayTaskCompletionTimeStatus)=0
These work if only one option in the filter is selected, but if I wanted to show both 'Complete' and 'Complete - No Due Date' then it returns an error
:
Advice on how to get it to show if it's selected appreciated!
Try this
If(
GetSelectedCount(SevenDayTaskCompletionTimeStatus) = 0
OR WildMatch(Concat(SevenDayTaskCompletionTimeStatus, '|'), '*Complete*'),
YourMeasure
)
Hi,
@orangebloss, For me this solution worked well, test it in your case.
if(Concat(DISTINCT YourField, ', ') = Concat({< YourField *= {'Value1', 'Value2'}>}DISTINCT YourField, ', '),1,0)
- Regads, Matheus
Try this
If(
GetSelectedCount(SevenDayTaskCompletionTimeStatus) = 0
OR WildMatch(Concat(SevenDayTaskCompletionTimeStatus, '|'), '*Complete*'),
YourMeasure
)
Absolutely perfect! Thanks!