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"
"2:68",0.87,1243,1083,1
"2:16",0.79,720,574,1
"2:02",0.75,2532,1924,1
"2:67",0.82,2282,1877,1
"2:51",0.75,2176,1644,1
"2:78",0.75,2897,2198,1
"5:14",0.73,288,211,1
----------------------
,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"
"2:68",0.87,1243,1083,1
"2:67",0.82,2282,1877,1
----------------------
,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
