Hi everyone,
I would like to hide options from filter "Category" and "Phase". For any text value with "NULL" or actual null value, I don't want them to be displayed in the filter. HOWEVER, I still need the value in the back end. So the counts should always include NULL or text "Null" value but I don't want users to unselect these values. Is there a way to do it?
Some solutions available suggest to create calculated field such as
If phase = 'cancel or phase = 'closed' or phase = 'test' or phase ='review' then phase else 'never display' end
But these solutions will always exclude null value. I only want to hide them.
Please provide any feedback and solutions. Sample is attached. Thank you!
Hi all,
Not sure if this is helpful but I want to include as much detail as possible.
I'm trying to create a table with three dimensions in there:
Number of Records
Pass Count
Pass Percentage = Pass Count/Number of Records
In the sample, I provided two filters: Phase and Category. Each filter has null values in there. Ideally, I would like to HIDE the null value from showing in the filter but ALWAYS INCLUDE them. For instance, if users selected phase as "Closed", in fact it is selecting both null and Closed but I don't want them to know null is selected.
I have tried the suggestions above which excluded the null value from both filter and the number of records count (this should always include the null values). I have also tried fixing LOD function in other Q&A but failed because my real data has more than these two filters. The FIXED function will not change at all but I still want it to change based on the other filters. My real data has a filter called "Account". If I only select account 1, I want to see all number of records associated only to account 1 including all category and phases which means null value included. But if I select closed only in phase, it is in fact closed and null being selected. ...Any suggestions?
Thank you all for the help!!
