Conditional counting in kibana


(suresh) #1

Hello

we early use qlikview to do some aggregations like

Count(Distinct IF((Tier = 'Tier 1' AND AGGR(Count({$<Week= week1>}SiteID), ClusterCode, Week) >= 6) OR (Tier = 'Tier 2' AND AGGR(Count({$<Week= week1>}SiteID), ClusterCode, Week) >= 5) )

something like field tier=tier 1 and get the count by clustercode,week and it should be >= 6 then only count

But we want achieve same thing in Kibana, Actually we tried using Timeline but not able to figure it out
Please help us on this

Thanks,


(Lee Drengenberg) #2

I'm not following along with your question very well. Maybe you could post a sample of a simple set of data to illustrate your question?

Is your issue about grouping data by specific weekly buckets? Do you already have a week field in your data? Or is that what you're trying to solve?

I also don't understand the >=6. Is 6 the week number or the count of something?

Regards,
Lee


(suresh) #3

ok, in words get the weekly count whose (Tier value in 'Tier1' and group by clustercode whose count should be >=6)

means(for this week how many clustercode falls in tier1 should be >=6 than only count that as one document) and so on we need to add 3 different conditions with logical OR and get the distinct count.

X-axis=weekly
y-axis=counts based on above condition

Thanks


(system) #4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.