Forum Discussion

Mis's avatar
Mis
Cloud Apps
11-09-2021
Solved

Year cannot be recognized

Hi! I just started using Sisense and so shame that it's such a basic problem, but I cannot seem to visualize the following columns about the year and number of crimes in Japan.  when I visualize ...
Data Connectors
Elasticube
Windows
  • HamzaJ's avatar
    HamzaJ
    11-09-2021

    Hi Mis ,

    I do not know if it works, however could you try to create a full date instead of only a year. Change your year-field to int and create a new column (type DateTime) with createdate(year,1,1)

    Does it work?

    Hamza

Mis's avatar
Mis
Cloud Apps
11-10-2021

Hey hey! Yeah it solved the issue, thank you so much!