Show a total number of rows with a filter

I’m tryng to show a really simple total value but I can’'t figure out how to show this number as a KPI.

Here is my data, grouped by segment (the raw data have one line per date, but it should not be relevant here) :

"segment","Fit","eligible","selected","count segment"
      ,0.78,  ,     ,7
  • The “Fit” is a calculated field : sum(selected)/sum(eligible)
  • the “count segment” is also calculated and is here to show the total number of rows : distinct_count(segment)

So here the total shows 7 and I have 7 lines it works.

Now I want to filter only segments with a “Fit” above a certain value.
I managed to do that by applying a filter on the visual, and with “Fit” > 0.8 I got :

"segment","Fit","eligible","selected","count segment"
      ,0.84,  ,     ,2

Here my total is “2” and this is the number I’m interested in: I want to show this number in a KPI visual !
But I don’t manage to show it.

  • I tried to apply the filter “Fit greater than 0.8” on the KPI
  • I also tried the calculated field : distinct_countIf(segment, (selected/eligible) > 0.8)

But in both case the total don’t match “2”.
How can I have a total in my KPI reflecting the number of rows after a filter ?

Thanks for you help

Hi! You should be able to apply a filter to the KPI and count those segments. I created a simple example using the raw data you provided. I created a KPI visual with Segment (Count) as my value. I then applied a filter to that KPI where fit > .8. I show 2 in the KPI count which reflects the filter applied. Attached is a screenshot of my solution.

Hope that helps!

Hello Kelli,
Thanks a lot for your help and taking the time to answer, it helped me for my dashboard !

1 Like