Hello Team, is it possible to add "Last 12 months" option in here?

Hi Manny, Thank you for reaching out. You can filter data by predefined time periods - Minutes, Hours, Days, Weeks, Months, Quarters, Years. You can scroll down to see more options as shown in the image attached below. If you would like to learn more about working with filters, you can refer to the documentation below https://www.gooddata.com/docs/cloud/create-dashboards/filters/attribute-filters-dashboards/ Hope this helps.

Thanks @Yvonne Changamuka, I was referring the date filter on the Metrics date filter. The "Last 12 months" filter doesn't appear in there.

Hey @Yvonne Changamuka our client wants a "rolling 12 months column" in a table with the next column in the table being "this year" - so we can't just filter the entire table by rolling 12 months. Is it possible to make one particular column in a table set to rolling 12 months without needing to make the entire table filtered to rolling 12 months?

Hi @Manny Thanks for giving more context. It should be possible once you click on the filter by date button. After clicking, a drop down list should appear as shown in the image attached below. Hope this helps.

Hi @Yvonne Changamuka. I was asking for "Last 12 months", is it the same with "12 months ago"?

Hi Manny, By using "Last 12 months," you will see all the data from the past 12 months presented with your desired level of granularity. On the other hand, "12 months ago" will only show data from that specific month; for example, it would only show the data for May 2024. If you want to achieve the "Last 12 months" view in the Metric data filter, you can use the Static Period option.

Hi @Mauricio Cabezas, is there any reason why it can't be added into the Metric filter?

Hi Manny, If you prefer that option, please let us know and we will gladly submit a product feedback on your behalf so our product team can consider to implement this into the panel date filters.

Hi @Julius Kos, yes please since you have this option already on the visualisation filter

🎉 New note created.