Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to come up with the count of Id's with a condition. I used set analysis to specify the condition and used {1} to make the expression reflect static count without any effect on the filters but the count still changes when ever there is a change in the filters.
=count(distinct {1< OS_id=p(Si_d)>} OS_id )
Is there a way to make the above expression always reflect static count irrespective of filters selection ?
Try this
=Count(DISTINCT {1<OS_id $::Si_d>} OS_id)
Thanks. It says error in expression. Not sure what's missing
My bad, I forgot the equal sign... try this
=Count(DISTINCT {1<OS_id = $::OS_id>} OS_id)
Sorry This is not what I wanted. I need to display the count of all OS_id that have Si_Id in them without being effected by any filter. Your expression results the count only when I select a specific OS_id.
What exactly do you mean when you say OS_id that have Si_Id in them? Can you share an example?
lets say Si_id have {1,2,3,9} & OS_id have { 1,2,3,4,5,6,7}. The expression should return 3..
May be try this
=Count(DISTINCT {1<OS_id = p({1} Si_d)>} OS_id)
Perfect.This worked.
Thanks a lot. So looks like I need to put {1} to the section which I want to be masked.
So looks like I need to put {1} to the section which I want to be masked.
Masked? I am not sure what that means , but essentially p() function needs to ignore selection as we well, otherwise selection will alter Si_d which will impact your final result