Count (Boolean)
I have segmented the sample and i have 5 distinct segments. We have recoded the segments with a (boolean) Yes or No. So the data is setup as Segment A = Yes/ no. I want to use the 123 indicator to di...
Forum Discussion
Hi BalaR​,
You're on the right track. Similar to your attempts, I would use a formula filter on Segment_A to accomplish this. You'll see these referred to as Measured Values in Sisense documentation. I created a sample file containing 500 participant ids and randomized Yes/No segment values, structured like this:
I was able to build an indicator showing total count (and contribution %) of the records with Segment_A = "Yes" by using the following formula:
(count([Participant Id]), [Segment_A]) / count([Participant Id])
The numerator pulls the total count of participant_id, with a filter on Segment_A = "Yes". You right-click the filter field (Segment_A) and select "Filter" to assign the filter member(s).
The denominator pulls the total count of participant_id, without any additional filters.
Let me know if this solves your issue, or if any clarification is needed (or if I've misunderstood the requirement!).
