Forum Discussion

Astroraf's avatar
Astroraf
Data Pipeline
09-15-2025
Solved

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​ 

 

 

image.png

dashboards & reporting
  • Astroraf's avatar
    Astroraf
    09-18-2025

    Hi 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.