Completed

Make a Google sheets Dashboard

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.

Skills: Google Sheets

See more: magento show 1 2 3 4 5 project type fixed hourly, 1 2 3 4 5 6 7 8 9 10 what's the mistake, find the mistake 1 2 3 4 5 answer, 1, 1, 2, 3, 4, 5, 8, 13, 21 - which one doesn't belong to this series?, consider the following time series data. week 1 2 3 4 5 6 value 18 13 16 11 17 14, ungalugu february 14 enna nadagumnu papoma choose the number 1 2 3 4 5 6 7 8 9 10, 1+2+3+4+5 to 100 answer, what should be there in the place of question mark 1 2 3 4 5, sobha silicon oasis phase 1 wing 1 2 3 4 5 & 6, consider the following time series data: month 1 2 3 4 5 6 7 value 24 13 21 14 20 23 15, consider the following time series data: month 1 2 3 4 5 6 7 value 24 15 21 13 19 21 16, 1+2+3+4+5 to 50 answer, consider the following time series data: month 1 2 3 4 5 6 7 value 23 13 20 12 18 21 16, consider the following time series data month 1 2 3 4 5 6 7 value 22 14 20 13 18 22 15, month 1 2 3 4 5 6 7 value 24 15 21 12 19 21 16, consider the following time series data: month 1 2 3 4 5 6 7 value 23 15 20 12 18 22 15, 1,2,3,4,5,6 fnaf scratch, fnaf 1 2 3 4 5 6 7 on scratch, fnaf 1 2 3 4 5 6 7 8 9 10, consider the following time series data month 1 2 3 4 5 6 7 value 24 15 21 12 19 21 16

About the Employer:
( 0 reviews ) Agadir, Morocco

Project ID: #28711150

Awarded to:

Techbhakti

I have created same dashboard many times for a automate go. I can show you my work and can do your also very easily. I have 8+ year experience in Excel, VBA, Google Sheets, Google Form and Google App Script. I can su More

$22 USD in 1 day
(1 Review)
1.0

3 freelancers are bidding on average $26 for this job

BADRI1998

Hello Sir, I am doing Master's in RMIT University in this domain. I have great experience with tableau and Powerbi in the past 1.5 years. I have been doing Intern in this domain and I have portfolio of items made with More

$20 USD in 1 day
(0 Reviews)
0.0
tripathivikas28

6 years exp of IT & Credit Card portfolio Business/Data Analysis. Tool: Advance MS Excel, MySQL,Tableau, Google Data Studio, Google sheet, logo designing, banner, poster designing. I can do the Business and data analys More

$35 USD in 2 days
(0 Reviews)
0.0