Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I am trying to implement a dashboard showing users access statistics.
More specifically, I created a graph
- dimension : months of the year,
- expression: number of users who connected more than 20 times.
I have tried to implement it with this expression:
Count({<UserID={"=Count([Session Start]) >20"} >}DISTINCT UserID)
The issue is that the dimension is applied to the UserID only, not to the session count.
So in reallity my expression calculates the number of sessions irrespective of the months.
If I put a filter on a specific month, then the value shown is correct. Without filter, the values are wrong.
Anyone can help here to get the expression right?
Thanks
Greg
Do you have a Month and Year field in your calendar??
This expression will make the count grouping by the field you choose, I´ve written MonthYear in the example
aggr(Count({<UserID={"=Count([Session Start]) >20"} >}DISTINCT UserID), MonthYear)
Hope this helps
Hi José
I do have a dimension called "YearMonth" in my calendar, and that's the one I use for my graph.
When I try applying your recommandation, the outcome is exactly the same, count of UserID is split based on the dimension (month), but the count for session start for each user is over the whole period in my calendar, not split by month also.
If I select one month only in the graph, then the session count will be restricted to that month only and the result displayed will be correct... but only one month is displayed, not the whole calendar 😞
Any other idea?
Regards
Greg
I think you must to use filters in blank to discard that filters, then, when you select a month, month filter will be discarded so that must show you the result for all your periods
Count({<UserID={"=Count([Session Start]) >20"} >}DISTINCT UserID)Count({<UserID={"=Count([Session Start])>20"},Month=, MonthYear=>} DISTINCT UserID)
regards,
chema