Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a list of requests and each one includes the user id, I'm trying to create a bar chart to show the number of users that have made 4 or more requests in a given monthYear.
I already have the month year field from Master calendar, but I'm just having trouble getting the sum of counts.
hi
should be something like
sum(aggr(if (count(RequestID)>3,1,0),userId,monthYear))
That doesn't seem to work,
These are the results it gives me.
But the numbers should be like this
Jan-2019 0
Feb-2019 3
Mar-2019 4
Apr-2019 4
May-2019 4
Jun-2019 0
hi
it's hard to know the problem , with out data
can you share sample data?
Not sure if you sorted things out or not, so just in case not, and you cannot post any data, I wanted to drop the following Design Blog link out here for you, there are some additional links at the bottom of the post, just FYI, hopefully this will get you what you need if you are still struggling.
https://community.qlik.com/t5/Qlik-Design-Blog/Pitfalls-of-the-Aggr-function/ba-p/1463275
Regards,
Brett