Hi sir, I am trying to implement one scenario like user selects fy year,quarter and month in the dashboard level required to provide filter level options.based on the user selected fy year,quarter, month sales and previous year same selected date range sales need to show in kpi level. I have 4 years of data.I am struggling to implement. Can you please explain this scenario. Thanks in advance.
Hey Let me understand your scenarios. you want to provide 2 dropdown option ? in first one user can select either (Year or Quarter or Month) then in second drop (all year or all quarter or all month) right?
@@pjanalytics Required to provide 3 filters in dashboard like below, 1. Fy year filter have 2021,2022,2023, 2024 options 2. Quarter have q1,q2,q3,q4 3. Month have from April to March Based on these 3 filters Required to show sales and what ever selected for that previous year example user selected 2022,q1,April then this is current year and 2021,q1,April is previous year
Thank you sir, this video is very useful for me. Please upload more videos like this.
Glad to know.. sure more videos will be upload soon
Hi sir,
I am trying to implement one scenario like user selects fy year,quarter and month in the dashboard level required to provide filter level options.based on the user selected fy year,quarter, month sales and previous year same selected date range sales need to show in kpi level. I have 4 years of data.I am struggling to implement. Can you please explain this scenario. Thanks in advance.
Hey
Let me understand your scenarios. you want to provide 2 dropdown option ? in first one user can select either (Year or Quarter or Month) then in second drop (all year or all quarter or all month) right?
@@pjanalytics
Required to provide 3 filters in dashboard like below,
1. Fy year filter have 2021,2022,2023, 2024 options
2. Quarter have q1,q2,q3,q4
3. Month have from April to March
Based on these 3 filters Required to show sales and what ever selected for that previous year
example user selected 2022,q1,April then this is current year and 2021,q1,April is previous year