This content has been marked as final. Show 5 replies
I am building a dashboard which requires an object to display value according to fixed constraints, so even if i make selection in the adjacent charts/filter objects it should not change its value on any selection made in the work sheet.
here is what i am using :
=count(distinct (if (Status = 'Active' or Status ='Waiting for Resolution'), [Counter Incident Number])))