How can I dynamically limit the x-axis display of the data points to the latest 8 quarters?

to make it dynamical, I see two options:

quick: playing around in the layout, so that quarters can be identified as "belongs to the last 8 quarters" or not, and then use this block as a layout filter

longer but usable in all reports: build a custom time entity above "quarter", set the members so that 1 member is always related to the last 8 actual quarters (you need a procedure or manual action to update this), and then use this custom time entity in the screen or chart selection

Thanks for the responses. However, my situation is a bit more complicated. The screen is a dashboard consisting of multiple graphs. There are two time pagers to select the year and month. 3 of the graphs shows the current year and the prior year based on the selection of the year pager. The graph that I want the rolling 8 quarters is the one that is different.

I want the reference time period to be based on the combination of the year and period pager. i.e. by selecting 2018, Mar18, it would show rolling 8 quarters based on that date.

Removing Quarters from the "Options" tab did not affect the display. It would seem that the page governs everything on the screen. This is overridden if explicitly select the current and prior years in the "Select" tab. I would accept displaying 8 quarters based on the current and prior year and not rolling.

Even with the dynamic select via a cube, I think there would still be a requirement to run a procedure every time the pager changes.

Contact BOARD

Discover BOARDVille

Follow us

BOARD is an all-in-one
Corporate Performance Management and Business Intelligence software solution that makes it easy to build any
business analytics and planning applications without coding. BOARD offers all the
functionalities, tools and analytic capabilities needed to quickly create
dashboards, reports and self-service analyses fully integrated with
enterprise planning and simulation processes. BOARD is included in Gartner's
“Business Intelligence & Analytics” Software Vendors and “CPM Suites” Magic Quadrants. Recent comparison reports have rated
BOARD the best product for Overall Customer Satisfaction among a
comprehensive list of BI and CPM software vendors. Compare our customer list and case studies to discover more about the benefits of the best in class decision making platform.