Created a query on the default Support tickets dataset, with the following standard calculation metric:
COUNT([Ticket solved - Week of year]) - COUNT([Ticket created - Week of year])
Adding the metric to the query returns:
The calculated measure "COUNT(diff3-0a5e3957a5)" references "[timeDimension" which is as an unknown metric. Adjust the calculation and try again. (Error code:2d14fa85)
What is wrong with the calculation and how do I resolve?
For context, I'm looking to get a difference between the number of solved tickets this week and the total number of created tickets this week.
Additional feedback : It would be fantastic if the errors could be copy/pasted (yes I typed that line down).
Please sign in to leave a comment.