Hi DRay Liliia_DevX , I am looking to create a week range for a line/column/bar chart where lets say it is the 30th week of 2024, then the 31st, 2024 and I want the 30th and 31 st week to shows Sep 24 - Sep 31 2024, etc. Is there a way to achieve this within the model or in the back end of a live data model.

Hi :) Please try this approach suggested by OleksiiDemianyk. On the client you need to: Add 6 days to each date returned by Sisense; Change category from the default one to the ${startWeekDate} - ${startWeekDate + 7 days} This can be done on the event beforeviewloaded. Here is the sample where we have week as the only category: const months = { 1: 'Jan', 2: 'Feb', 3: 'Mar', 4: 'Apr', 5: 'May', 6: 'Jun', 7: 'Jul', 8: 'Aug', 9: 'Sep', 10: 'Oct', 11: 'Nov', 12: 'Dec' }; widget.on('beforeviewl...

How to create a week date range with start and end if the week for each week? | Help and How-To

MoreDiscussions

How to create a week date range with start and end if the week for each week? | Help and How-To | Sisense Community