How to display two different Values from two different years within the same month range?
I want to display the Months from Jan to Dec. for two separate values. The image below shows what I am trying to achieve. I want a count for 2025 and I want a count for 2024. I have this my spread sheet but I was currious that if my datatype is a datetime rather then a text, is there a way to achieve this in Sisense DRay Liliia_DevX

Rafael Ferreira
Posted 10 months ago·Last reply 10 months ago
2 comments
Rafael Ferreira
OP10 months ago · EditedHi DRay
I solved this by making the Month column a text field with leading zero for sorting purposes: 01 Jan, 02, Feb, 03 March, 04 April etc. Then I just inputted the two values for 2024 and 2025.