Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a calculated column that categorizes each user into 3 categories based on their app usage time as
1.<10 min
2.10-30 mins and
3.more than 30 mins.
(the expression uses a nested IF to come up with these categories)
I am trying to create a chart that shows number of users by each category.
What is the best way to go about it?
Only dimension readily available is the userID.
Thank you for the assistance in advance.
CALCULATED based on a if condition | |||
userID | avg session time | category | |
1 | 0:05:20 | <10 minutes | |
2 | 0:35:20 | More than 30 | |
3 | 0:12:20 | 10-20 mins | |
4 | 3:05:20 | More than 30 | |
5 | 4:05:20 | More than 30 | |
6 | 5:05:20 | More than 30 | |
Need a graph that calculates userIDs for each of the category in column F | |||
The categories are a result of an expression. Does that mean I need to create a calculated dimension using the same expression?
There are two ways to do this, calculated dimension will take time if your data volume large.
Rather you can manage it in the script like creating Case When scenario of your categories.