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.
Which table has the Registration Date information? How does your data model look like?
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.
