Hi Guys,
I have my data set up like this and this is the way it comes in (The work type is above the the TOTAL, TIME AND NET HOURS) - for some reason its not posting the way it looks in my spreadsheet.
What i want to be able to do is create a dashboard that can summarize by monthly, weekly up to the past 13 weeks (total for each week up to 13 weeks ago), by days ie (if i selected Tuesday, then all Tuesdays scores for past 13 weeks the same as the week)
I guess i can create a slicer but i cant the way my data is set up. How can i get around this and then create a dashboard that allows me to filter by my criteria?
Thank you
WORK1 WORK2
Date TOTAL TIME Net hours TOTAL TIME Net hours
01/01/2014 0 1200 0 1200
02/01/2014 0 1200 0 1200
03/01/2014 0 1200 0 1200
04/01/2014 0 1200 0 1200
05/01/2014 0 1200 0 1200
06/01/2014 0 1200 0 1200
07/01/2014 0 1200 0 1200
08/01/2014 0 1200 0 1200
09/01/2014 0 1200 0 1200
10/01/2014 0 1200 0 1200
11/01/2014 0 1200 1 1200 0.33
12/01/2014 0 1200 0 1200
13/01/2014 0 1200 0 1200
14/01/2014 0 1200 1 1200 0.33
15/01/2014 0 1200 0 1200
I have my data set up like this and this is the way it comes in (The work type is above the the TOTAL, TIME AND NET HOURS) - for some reason its not posting the way it looks in my spreadsheet.
What i want to be able to do is create a dashboard that can summarize by monthly, weekly up to the past 13 weeks (total for each week up to 13 weeks ago), by days ie (if i selected Tuesday, then all Tuesdays scores for past 13 weeks the same as the week)
I guess i can create a slicer but i cant the way my data is set up. How can i get around this and then create a dashboard that allows me to filter by my criteria?
Thank you
WORK1 WORK2
Date TOTAL TIME Net hours TOTAL TIME Net hours
01/01/2014 0 1200 0 1200
02/01/2014 0 1200 0 1200
03/01/2014 0 1200 0 1200
04/01/2014 0 1200 0 1200
05/01/2014 0 1200 0 1200
06/01/2014 0 1200 0 1200
07/01/2014 0 1200 0 1200
08/01/2014 0 1200 0 1200
09/01/2014 0 1200 0 1200
10/01/2014 0 1200 0 1200
11/01/2014 0 1200 1 1200 0.33
12/01/2014 0 1200 0 1200
13/01/2014 0 1200 0 1200
14/01/2014 0 1200 1 1200 0.33
15/01/2014 0 1200 0 1200