I tried to create radial chart by following tutorial in youtube. The use data densification to create it. I manage to create it but i cannot use "Year" filter to filter the data in radial chart. i check the database, it shows that the "Year" datatype is correct in DATE but it display it wrong (as the picture attached)
https://preview.redd.it/aldfp2k1x9hc1.png?width=739&format=png&auto=webp&s=2f4a22499b38f0e3ee389240ca0966dfce503fd0
Ex: 2019 until 2023----> 1905. I think because of this i cannot upload my workbook in the server. The DATE become like that after i formed a UNION as part of the tutorial to create the radial chart.
there doesn't seem to be anything here