Hi.
I need some help here.
I am trying to display sales information grouped by the month based on the year selector which is a dropdown field.
I have setup a dropdown field that pulls the data of the transaction being made. Ive formatted it to show it as year.
For the bar chart, im using the Line/BarChart A plugin.
I have setup my bar chart to do the following.
and this is what it shows at the front.
What i intend to do is that when the year 2022 is selected from the dropdown, it will only display Aug, 22 as that is the only month we had transaction in.
If year 2023 is selected only Feb, 23 and Oct, 23 appears.
Is there a way to achieve this? I’ve spend the entire day figuring it out but failed.
Any help is greatly appreciated.
Thank you so much !
Alvin.