I am trying to create a report showing the % of resolved incidents. I have created the following calculated field:
Resolved (%) = [Measures].[Issues resolved] / [Measures].[Issues created]
This works fine, except if the Issues resolved is empty. then the resolved field is also empty when it should be 0%. I have played around with iif and isempty with no luck so far.
Also I would like to see the trend per week. So the above % of resolved incidents for this week, last week etc. How is this possible taking into consideration all tickets, not just those created in a certain week?