Forum Discussion
Dynamic date table for filtering whole report
Hi,
I have a report with 4 different tables. I want to be able to filter the whole report off of one date slicer because each table has a different date field that I'm using for said chart, card, etc. I couldn't get it to work so I restarted my report with the dynamic date table called "Dates" and a table called "Leads Entered"
Here is example data:
Leads Entered:
Dates:
My goal is to use the Date column in the Dates table to filter the whole report, but I can't get this to work.
This is the relationship that I setup (a many to one)
Then when I go to my report to create the date slicer / card, no data populates:
All of my data in this table is in August of 2019.
Thanks! Not sure what I'm doing wrong. If this doesn't make sense, I'd be more then happy to provide more screenshots / info.
- Anonymous7 years ago
Anonymous - Please make sure that Created Date is Date datatype. Then it should work.
5 Replies
- AnonymousNot applicable
Anonymous -
It does look like it should work. A couple troubleshooting ideas:
1. Does the card work if the slicer is not there?
2. What does the data look like if you add columns from both tables into a table visual?
Hope this helps,
Nathan
- AnonymousNot applicable
HI,
1) Yes the card works if the slicer is not there. It also works if i put the date range to Jan-01-2019:
OR
2) nothing populates:
- AnonymousNot applicable
also this:
Does not work for some reason.
Thank you!