Forum Discussion
Group by columns
Nicole You do not have to do any thing in the data model in order to accomplish this task.
Put all the three columns in a Table visual. Now drag the distance column again and drop it on table visual and chage the aggregation of this column to Count and your task is done.
Nicole You do not have to do any thing in the data model in order to accomplish this task.
Put all the three columns in a Table visual. Now drag the distance column again and drop it on table visual and chage the aggregation of this column to Count and your task is done.
as HarrisMalik mentions you will probably be better to calculate in your analysis rather than build into your model.
However you can use the group by button in the query editor:
Click Edit Queries
Select the query you want to aggreagte
Click Group By