Count with date and year filter

[Syndicate_Admin]

Good afternoon, I'm trying to perform a distintcount on the idcase column with filter down.

Additionally create a calendar table with the goal of creating filters by month and year. On the wiSolutionDate column were related the corresponding tables. However, when generating the report, the data appears blank to me.

I am very grateful for your help.

[Syndicate_Admin · Accepted solution]

Thanks a lot!!! perfect

[amitchandak]

@Syndicate_Admin , If they active relation, there is no need use userelation

2nd Check wiSolutionDate might have a time stamp. Check by changing data type to datetime and format having time. If so create a date without time and join with that

example

Date = [wiSolutionDate ].date
or
Date = date(year([wiSolutionDate ]),month([wiSolutionDate ]),day([wiSolutionDate ]))