Deleted Tasks are counted In Created count

Questions & Answers
, ,
#1

I’ve written a measure for the Task Completeness. No of Tickets Resolved / No of Tickets Created is formula used in that.

CASE WHEN [Measures].[Issues created] > 0
THEN
CoalesceEmpty([Measures].[Issues resolved],0)/
[Measures].[Issues created]
END

In that I’ve deleted a sub-task. and all the remaining 10 sub-tasks I’ve closed.
I’m getting the percentage as 91%. while checking the count values individually observed like below

Total No of Tasks created : 11
Total No of Tasks resolved : 10

How we can ignore the deleted sub-task

Any leads will be appreciated

#2

Hi @Tony_Thomas,
​
​Can you please advise if you imported data again into eazyBI after you deleted the sub-task?
​
​Best wishes,
​Elita from support@eazybi.com