Drag the date in row and drag the open close status into column and drag no of records into text.
now we can get open close records in each day.
If not solved then attach workbook.
There is no "open / closed" status to drag, because the status changes depending on which time period you are looking at. I have no workbook yet, as I've not found a way to approach it.
Could you post some sample data in excel so we can have a play around with it?
I usually approach this type of analysis by duplicating the data source and then blending to itself on Start Date = End Date, or in your case we would blend on [Logged On] = [Resolved On].
I put together a sample dashboard using your data in the attached workbook (made in v9). For the sample I made a calculated field in both instances of the data source called [Date], where the formula is calling the respective date field, either [Logged On] or [Resolved On]. I am casting the fields as DATE rather than DATETIME because we are wanting to see the daily open calls and also so that the blending plays nicely
Let me know how the workbook looks and if you've got any questions on the setup.
active calls_for chris.twbx 29.2 KB