Hi everyone, I hope you can help me with this issue - thanks in advance! 😊 Context: You can see from the attached image below that I have a clustered chart withx-axis: company_namey-axis: USGlegend: period_labelProblem: I need to implement a Last N Fiscal Quarters slicer/filter. Specifically, when a user selects a period and year, the chart should dynamically display the last five sequential periods.For example, if a user selects Q4 2022, the chart should display:Q4 2022, Q3 2022, Q2 2022, Q1 2022, Q4 2021, Q3 2021 (for each company)I've tried several approaches, including a Sequential Quarter Index, but it doesn’t provide an intuitive user experience. If anyone has a better way to allow users to select a specific period in a year while ensuring the correct sequential display, I’d appreciate your insights! USG dim_company dim_time dim_time_quarters fact_financials dim_region

Anonymous Try the attached file (below signature).

Anonymous

Not applicable

1 year ago

Solved

Dynamically Display Prior Quarters Based on a Quarter Slicer (Per Company)

Hi everyone,

I hope you can help me with this issue - thanks in advance! 😊

Context: You can see from the attached image below that I have a clustered chart with

x-axis: company_name
y-axis: USG
legend: period_label

Problem: I need to implement a Last N Fiscal Quarters slicer/filter. Specifically, when a user selects a period and year, the chart should dynamically display the last five sequential periods.

For example, if a user selects Q4 2022, the chart should display:

Q4 2022, Q3 2022, Q2 2022, Q1 2022, Q4 2021, Q3 2021 (for each company)

I've tried several approaches, including a Sequential Quarter Index, but it doesn’t provide an intuitive user experience. If anyone has a better way to allow users to select a specific period in a year while ensuring the correct sequential display, I’d appreciate your insights!