Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago
Solved

Count with date and year filter

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.

Captura_4.pngCaptura_3.PNGCaptura_2.PNGCaptura_1.PNG

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    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 ]))