I have a scenario where I want to toggle between Years for a Report on Sales that presents a summary Total and a Bar Chart Graph.
In Classic Builder I achieved this by having
- Logged on User with a Field “Selected Year”
- A Years Table that shows Summary Figures by Year that will be presented by a Details Element (i.e Year connected to logged on user)
- A Detailed Invoice Table that will be presented as a Bar Chart by Period for the selected Year. (i.e Records in Year connected to logged on user)
The user selects the year from a drop down (Modal Page). This updates the Selected Year in the Logged on User Record and returns the user to the Existing Page for Sales.
For example I swap between 2025 and 2026.
In Classic Builder the page will update Year Details and Detail Invoice Bar Chart by Period.
In Next Gen, when returning to the page, it updates the new Year Details but retains the Bar Chart details from the previous year.
It only updates the Bar Chart with the new selected details if I refresh the Browser Page.
I need to be able to force a refresh of the page or element when returning to the page.’
Any suggestions?