I've created another data source that is just a template or scaffold of all 15 minute intervals and used that as my primary (so I would get ALL the times) and blended to the call data. There are limitations to this approach such as not being able to use measure names from secondary data source (which is really the main data source). But maybe this might buy you something.
TY- CAS-sample JSOBCZAK.twbx 865.2 KB
This is exactly what I needed but I need to be able to populate the 15 minute interval for the whole month of January. It appears that that 15 minute interval times stop on 1/2/2016 at 12:45pm. It then goes:
I exported the "All Times" tab into Excel and clicked on "1/2/2016 at 12:45pm.". I thought if I were to drag it down that it would populate the next date/15 minute interval, but it didn't.
My goal is to be able to create reports using this format for every month. Any ideas?
Ah you're right. That's strange. It stopped the 15 min interval at row 100. I just went in and edited that row and the next row to 1/3/2016 1:00:00 & 1:15:00 and continued the drag and it seemed to go all the way out that time. You will probably need at least 2 cells to click when dragging down to give Excel an interval to continue.
I'm still not able get the time to show in the correct 15 minute interval after row 100. I tried the method you recommended by adding 1/2/2016 1:00:00 PM & 1:15:00 PM but was not successful.
Any other recommendations??