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

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