Forum Discussion
Solved
Distinct count with date parameter
Hello everyone! Hope you all are having a nice day. I'm looking for some help with something that is stressing me a lot in the past few days. So, what I'm trying to do is to get the amount of li...
You will need to add another dimension table to deal with the blanks. Here is a sample implementation.
Hello lbendlin
Sorry, I forgot about the table with the registration date. It's this one:
| Name | Registration Date | Category |
| Peter | 23/08/2021 | Diamond |
| Jordan | 07/11/2016 | Gold |
| Alisha | 25/10/2021 | Diamond |
| Mike | 21/06/2013 | Silver |
My data model is this:
An one to many relation with "Reg" crossfiltering the "Table".
You will need to add another dimension table to deal with the blanks. Here is a sample implementation.
Thanks a lot lbendlin !
It really helped me a lot.