• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Average days between two status points, multiple dates for each point.

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
 
Back
Top