Hi. I have attached an image of the data I want to be able to use for the dashboard I want. Data will be continually be adding to this table all the time so I need the dashboard to be able to automatically update on its own. In my dashboard I want to have a drop down menu that allows me to select each year, then another drop down that allows me to select the data from each month and Year to Date. From this data in the dashboard I want to be able to display visually the following:
1. Total sales per month.
2. Quantity of sales per month.
3. Average sale $ amount for that month.
4. Total sales Year to Date.
5. Quantity of Sales Year to Date.
6. Average sale $ amount for that Year to Date period.
7. Average days to redemption.
8. Percentage of 2nd visits.
9. Percentage of 3rd visits.
10. Return on investment for that period (Month or YTD).
I will explain more over a call.