Hi, I'm developing a piece for a customer at the moment that shows the number of calls into and dealt with by a solution centre. They don't use a standard date so what I have done is create a xls with date, period and week number to their calender, then joined it to the data based on the date the call was logged.
What they would like to see is a table that shows the number of calls open at the start of the period and the number of calls closed at the end of the period, try as I might I can't work out how to do this, I was thinking it would look like this:
=Count ({<
IncidentStatus={o},
DateLogged={"<Today()"},
Period={"Period-1"}
>}AssystRefNo)
But this doesn't work, any ideas how to calculate start and end of period-can I set the qvw to interpret periods that start september onwards with 13 in a year-and then how can I tell it to find the period before the one we are in? i.e.
