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

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

Hi tamerj1 

 

Thank you. Is there any other way? By applying the filter I'm going to lose some needed information. Basically, there are also users without any activity in the table and I need to keep them there.

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

soldous 

You may try

FilterMeasure =
INT ( ISBLANK ( [# of activities] ) || NOT ISBLANK ( [Count of Accounts] ) )

Place it the filter pane of the table visual and select "is" and type "1" then apply the filter