Forum Discussion
palkamj
7 years agoFrequent Visitor
Creating a slicer based on row count for a category
Hi, I have data on repair requirement requests for a house repairs company. Each row of the data contains the following information: 1. ID number of the request 2. How long since the request wa...
Anonymous
7 years agoNot applicable
Hi,
Can you check the file at below one drive location.
https://1drv.ms/u/s!AikPceQOhqFEhAGZ4wDtBK38hiYD?e=2VUttJ
Thanks.
palkamj
7 years agoFrequent Visitor
Hi Anonymous ,
I checked out the solution, but it's not exactly what I'm looking for. The solution works if I know beforehand what kind of filtering my client wishes to do on the data. As it is, I can't know that they're exactly interested to see which IDs have had more than 15 requests in less than a month. They might be interested to know which IDs have had more than 24 requests in 2 months, or less than 10 requests in the last 500 hours, or anything really. So the categorical approach taken with the calculated columns is kind of problematic.