Apps with session count

[nihhalmca]

Hi All

Create two KPIs 1. Apps with <10 sessions and 2. Apps with 0 sessions.

KPI: Need to show count of apps which has session count <10 and =0, I tired below expression however did not workout.

Count(distinct {<sessions = {<10}>} Appid) or Count({<Sessions = {"$(<10)"}>} Appid)

Count(distinct {<sessions = {1}>} Appid) 

Thank you.

[Vegar]

How to solve this depends on your data model. Do you aggregate the sessions up to app level in the script? In other words: do you have a field named "sessions" that holds the total value of sessions per app, so it is possible to filter by selection on values like 1, 2, 3,10,17, etc?

If so then you're on the right track, and set analysis is a very good fit for this.

If your session only hold the value 1, and the way you identify the apps is by aggregating on the fly as you select, then set analysis is not as obvious choice, but possible.

You can then try something like this to count the number of Appids for which the total sum of sessions is greater than 10.

Count({<Appid={"=sum(Sessions)>10"}>}Appid)