So I have one sheet of significant trends, where in you have the view and view_value filter which is used for selecting month from view and view_value defines the based on view selection, so if view is month then view_value gives the 12 months(jan, feb etc) and if view is quarter then view_value = q1,q2,q3 etc and week = 01/01/2024, 01/08/2024 for every 7 days ..etc.
Based on that selection my total complaints sheet (line graph) should reflect for last 12 months if view = month and view_value = jan 2024, then I should have values from jan 2023 to jan 2024 likewise for 5 quarter value and 5 week value.
@Jim Dehner (Tableau Visionary and Ambassador) I have attached the workbook with dummy data, where it has values similar to the screenshots attached, So I have one sheet of significant trends, where in you have the view and view_value filter which is used for selecting month from view and view_value defines the based on view selection, so if view is month then view_value gives the 12 months(jan, feb etc) and if view is quarter then view_value = q1,q2,q3 etc and week = 01/01/2024, 01/08/2024 for every 7 days ..etc.
Based on that selection from (sig trends worksheet) my total complaints sheet (line graph) should reflect for last 12 months if view = month and view_value = jan 2024, then I should have values from jan 2023 to jan 2024 likewise if view = quarter then view_value = q1, the line graph should show complaints for last 5 quarters from the given selection in the view and view_value filter of significant trends page.
Please let me know if you need any other details, thanks again.
