I need to plot some data in differents columns: the first one shows data of a specific date and the second one shows the average historical data (for example the average of some field).
When I plot it in a dashboard, I'll want to filter by date (for example, showing data for August 1st OR 2nd OR... ) on the first column.
Can I do it without changing the data showed in the column with the historical data?
Example: I have a Vertical Bar Chart.
Column A has info of August 1st.
Column B has the average of all historical data.
When I put it on my dashboard, I want the column A to show info about September 5th but keep my historical data on column B.
How can I do it?