Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have this expression, but i also would like to ignore [Application Name] selection if user makes from its seleciton box.
trid if condition for count but does not seem to be working.
Count({< [Application Name]=, [Application Name] = {"=count(DISTINCT [Authenticated user]) >5"}>}DISTINCT [Authenticated user] ))
Message was edited by: Faisal Mehmood I have attached examplt,,which does not work
Try This.
Count({< [Application Name]=, [Application Name] = {"=count( {<[Application Name]=>} DISTINCT [Authenticated user]) >5"}>}DISTINCT [Authenticated user] ))
-Nilesh
Delete the first modifier : [Application Name]=,
as you dont need this - the last modifier will do the job
You´re setting two conditions to same field.
Which one you want? If only ignore selections
Count(DISTINCT {< [Application Name]=>}[Authenticated user] )
Try this............
=Count(DISTINCT {< [Application Name]=>}[Authenticated user] )
Regards
Kiran Rode
+91 8976977897
Hi Nilesh,
should i remove first [Application Name]=, as shown below.
Count({<[Application Name] = {"=count( {<[Application Name]=>} DISTINCT [Authenticated user]) >5"}>}DISTINCT [Authenticated user] ))
I want Authenticated user > 5 and i have selction filed Authneticated user and i dont want tihs to filter my chart
This will also work. you can remove the first [Application Name]=,
both conditions will Work.
If not then you can se the below expression:
Count({<[Application Name] = {"$(=count( {<[Application Name]=>} DISTINCT [Authenticated user])) >5"}>}DISTINCT[Authenticated user] ))
-Nilesh
try:
if(count(distinct [Authenticated user]) => 5, Count({< [Application Name]=>} [Authenticated user])
Count({<[Application Name] = P({"=count(DISTINCT [Authenticated user]) >5"})>}DISTINCT [Authenticated user] ))