This is probably really easy but I can't work it out.
I have a table with a user id and a log in time.
I want to show the count of users who have logged in x number of times.
So I'd have 1,2,3 etc on the x axis and the count of users on the y axis.
Any help appreciated - thanks.
Solved! Go to Solution.
I recreated your problem, and the pictures below show how to get the visualisation you want.
(used a column chart)
(User ID are numbers in my example 1-7)
Hope this was what you wanted to know.
let me know if you have questions !
Thanks - but this isn't quite what I want. I don't want to see individual user ids. I want to see the count of userids over the count of logintimes.
So. If I have the following:
User - Login Time
1 - 10.00
2 - 11.00
3 - 12.00
4 - 13.00
5 - 14.00
6 - 15.00
1 - 16.00
2 - 17.00
3 - 18.00
1 - 19.00
2 - 20.00
1 - 19.00
The graph would show the count of logins in the x axis (1,2,3,4) and the count of users who have logged in that many times on the y axis (3,1,1,1).
You may follow the steps below.
1) add a calculated table
Table2 = GENERATESERIES ( 1, 4, 1 )
2) add a measure
Measure = COUNTROWS ( FILTER ( SUMMARIZE ( Table1, Table1[User], "Count", COUNTROWS ( Table1 ) ), [Count] = MAX ( Table2[Value] ) ) )
Small question: If the count of logging changes, let's say a user have logged in 20 time, does that mean Generateseries() formula needs to be updated?
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.