Select custom period of last 12 months

[Wantti]

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
}

[david-h]

Hi Wantti,

I am not sure you posted in the desired section, as I don't think this a product evolution is really needed. In What you are asking can be achieved in several ways, depending on your implementation.

If you are using elasticubes, then you can just add a calculated rank of month in your data model. Your filter will only select the top X month, that will only depend on your actual data.

With Live connection you will probably want to find an optimal way depending on your database, and how the data are updated in the source database.

Ultimately you can also have a dynamic calculation of the month difference between two dates in your dashboard using a dashboard formula and then filtering on the result of this calculculation. You can also probably do this with an advanced JAQL filter, but probably more complex.

Hope this helps !

Best, David.

[DRay]

Hello @Wantti,

Thank you for your idea. Can you clarify what you are looking for here? Would you like some help writing this code, or are you asking for this to be added into the Sisense UI someplace?

Did the comment from @david-h help you?

Thank you for working with me to flesh out this idea so it can be evaluated and scoped for effort.

Have a great day!