Forum Discussion
Solved
CountRows with UseRelationship is not working
I have a table with Schedule of Tasks. Each task has two dates start and finish. The main goal is to count the number of tasks by date while maintaining relationship with the tasks to keep crossfilt...
I actually found the solution which was pretty silly.
In the query editor the dates columns have to be of type Date and Not date/time
So the solution was as easy as changing the type of both start and finish columns to Date.
I actually found the solution which was pretty silly.
In the query editor the dates columns have to be of type Date and Not date/time
So the solution was as easy as changing the type of both start and finish columns to Date.
It's always the obvious solutions that are the hardest. Good job tho, will def come in handy to know!