Product Feedback Forum
cancel
Showing results for 
Search instead for 
Did you mean: 
Status: New Idea

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
}

1 Comment

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.