salmonchild
Member
Hello all,
I need some help to see if what I am trying to do is possible and if so how. I am summarising/calculating information from our 'raw' data to be the back end of a dashboard display. All the data for the DB needs to be in the same table to facilitate slicers working across all charts produced- same data source for the pivots.
Is it possible to give the correct average of the days between two date points (both with multiple dates) for each location and grade/job?
I have uploaded an example file HERE that should explain what I mean better. First sheet is the data, second is the summary (which will actually be in another workbook).
Any and all help gratefully received.
Oli
I need some help to see if what I am trying to do is possible and if so how. I am summarising/calculating information from our 'raw' data to be the back end of a dashboard display. All the data for the DB needs to be in the same table to facilitate slicers working across all charts produced- same data source for the pivots.
Is it possible to give the correct average of the days between two date points (both with multiple dates) for each location and grade/job?
I have uploaded an example file HERE that should explain what I mean better. First sheet is the data, second is the summary (which will actually be in another workbook).
Any and all help gratefully received.
Oli