Select custom period of last 12 months | Product Feedback Forum

Wantti · 2023-06-02T10:11:10.453000Z

Hi,I want to show in my dashboard the values of the last 12 months period.As I do not want to select the month every month manually, it should be dynamically taking always the last 12 months.So far I am using the advanced settings in the filter:{"last": {"count": 12,"offset": 0},"custom": true}The issue is, that my available data is not always up to date. Therefore, I want to select the last 12 months counting the offset back 2 months from the selected month in the filter.As far as I understood is that the offset counts back from the current date disregarding the filters settings.I would need something like thi:{"last": {"count": 12,"offset": 2 (counting from date selected in "sale date" filter)},"custom": true}

MoreDiscussions

Select custom period of last 12 months | Product Feedback Forum | Sisense Community