Forum Discussion

ewoytowitz's avatar
ewoytowitz
Cloud Apps
06-02-2024
Solved

Help with filterFactory.dateRange

I have indicators with a date range filter set up on the Sisense website (see attached image). I am trying to replicate this set up in my UI with the sisense/sdk-data filterFactory.dateRange function...
Developers
React
  • steve's avatar
    steve
    06-03-2024

    Hi ewoytowitz 

    Can you try adding .Days to your dimension to select a specific date level? e.g.

    DM.SeasonCalendar.CalendarDate.Days

    I think then it should work, if you use a date format like yyyy-MM-DD .. for example

     

    filters: [filterFactory.dateRange(Ecom.Commerce.Date.Days, '2013-04-01', '2013-04-28')]
     
    Hope that helps!
    Steve
steve's avatar
steve
Sisense Employee
06-03-2024

Hi ewoytowitz 

Can you try adding .Days to your dimension to select a specific date level? e.g.

DM.SeasonCalendar.CalendarDate.Days

I think then it should work, if you use a date format like yyyy-MM-DD .. for example

 

filters: [filterFactory.dateRange(Ecom.Commerce.Date.Days, '2013-04-01', '2013-04-28')]
 
Hope that helps!
Steve
ewoytowitz's avatar
ewoytowitz
Cloud Apps
06-03-2024

Thank you! That worked