How to filter a field in an insight's narrative and get a count for one value in that field

Question & Answer
,
1

Hi,

Within an insight’s narrative, i’m looking to filter a field and get the count of one of that field’s data values. In other words, I have a field (string) with multiple values, and I ony want to capture the count of one of those values. How do I create that filter within the narrative?

Note: there are several different variables all in the same narrative, so filtering the entire insight visual would not be helpful.

Thank you!

2

I would look to maybe make ifelse calculated fields that only display data that you are looking for.

ifelse({field}='blue',{value},0)

Then run calculations on this field ^ and the other fields you have created.

1 Like