I have data in one sheet that charts pull from on a page. I want to be able to allow a user to sort by year and have the charts reflect the data.
I have found a way to get the year… but can’t figure out how to get the data to change with maybe a choice or drop down menu. Thoughts?
What do you want to use a choices in the drop down? Do you want them to filter by year?
Yes by year.
I have 2 tabs. One that has the input form and charts,
2nd tab is a list of details about the input.
I have 2 sheets.
My app, inputs the number of swipes of a metro card by the reason for the travel.
A total amount of metro expenses is then adjusted to show a percentage and amount per category of travel.
I added a math column to pull the year out of 1 sheet and tried a relation column to the other. But can’t figure out how to have the user select a year (from a a dropdown is fine) and have the charts update to the year selected and have the data for that year appear (which is in the other tab)
Without knowing the specific structure you are having, I’m guessing you can have a choice component pointing to a user-specific column, then use that column’s value to feed a relation to the other sheet, then that relation can be used as the source value for the chart.