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

HamzaJ's avatar
HamzaJ
Data Integration
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

  • Liran_Elnekave's avatar
    Liran_Elnekave
    Sisense Employee
    11-10-2021

    Hi Hamzaj, 

    Thank you for sharing this valuable insight.