Forum Discussion

soldous's avatar
soldous
Icon for Advocate II rankAdvocate II
3 years ago
Solved

Dynamic "Group by" with custom sorting

Hi,   I have a table with activities of users. Each record has user name and date of the activity.   I need to create clusters of activity counts like this:   The grouping needs to be dynam...
Filter
Group By
  • tamerj1's avatar
    tamerj1
    3 years ago

    hI soldous 
    Place [Count of Accounts] measure in the filter pane of the table viual and select "is not blank" then apply the filter

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

hI soldous 
Place [Count of Accounts] measure in the filter pane of the table viual and select "is not blank" then apply the filter

soldous's avatar
soldous
Icon for Advocate II rankAdvocate II
3 years ago

Thank you tamerj1 

After all, this solution was correct. I had to change the inner measure for Count Of Activities also to count users with no activity as 0. 

But I need one more visual to be filtered by the ranges. The visual is for Number of Unique Daily Activities calculate like this:

UniqueUsers/Day = VAR tempTbl = ADDCOLUMNS ( SUMMARIZE ( daily_acitivity, daily_activity[Activity Date], "Users", DISTINCTCOUNT ( daily_activity[Username] ) ), "Days",1 ) RETURN SUMX ( tempTbl, [Users] )

 

By applying the same logic to filter this visualization from the clusters doesn't work. Do you have any idea?