How to create a table with a range of dates?
Hi, I have a use case were I have this table I want to plot in a chart in continues dates (i.e. from the minimum date of launch_time to the current date). e.g. 1/1/20 - 1/12/22 and count the n...
Forum Discussion
Hi TomerA
If you're running Sisense on Linux you can try to use the Custom Code feature to generate a calendar.
Please select 'Custom' - > 'Add Custom Code':
then click on 'Create a Calendar':
you can configure your calendar by given 'Start Date' and 'End Date':
After you click 'Done' additional table will be created as your calendar (based on config in the example above, the calendar will be created in the range from 2020-01-01 to the current date). You can use such date dimension table as you like in your EC structure transformation. There are some more fields you can find useful such as [DayOfWeek].
If you are running Sisense on Windows you please follow this article:
https://support.sisense.com/kb/en/article/date-dimension-file
Hi,
Although we are running Sisense on Linux we don't have that option. But the Windows article describe a similar use case and might do the trick.
Thank you so much.
Hi Tomer,
on Linux please ensure in Admin section of Sisense in Features, that Custom Code is enabled :
