Forum Discussion
jochendecraene
Helper V
5 years agoGrouping and frequency
Hello I have this dataset with unique cliënts that stayed in our shelter. Every night a person stays with us his of her unique number appears in the dataset. Now, I want to know how many times a ...
- 5 years ago
jochendecraene , You have to create a table, you do not need this Switch. Table will have ranges like
0 2 0-2
3 5 <=5
Please find the attached file for the video after signature
Can you share sample data and sample output in a table format? Or a sample pbix after removing sensitive data.
jochendecraene
Helper V
5 years agoThank you for the help.
I'm not allowed to upload a pbix file in my profile, so here's a link to my one drive
The dataset goes over more than 1 year, so I should be able to filter by year
jochendecraene
Helper V
5 years agoThnx!!!
the dynamic segmentation worked. I forgot to summarize my ID's ... so I had nothing to segement 🙄