I'm having trouble finding documentation on the Explore formula error "085f951c". Error message below:
The set of calculations isn’t valid. The calculated measure "COUNT(reassignedtickets-e0a3c35608-copy)" references "[tickets_id]" which is as an unknown metric. I'm trying to find the reassignment rate for different forms using a calculated metric with the following formula:
COUNT(Reassigned tickets) / COUNT(Tickets)I selected both metrics when creating the formula, so I'm unclear why it's indicating that "[tickets_id] is unknown - but also I'm sure why the error references a metric that isn't in the formula above.
The error you encountered means that you are trying to build a metric with an attribute that does not exist within the dataset. The metric
"COUNT(reassignedtickets-e0a3c35608-copy)"may no longer be available. Also, make sure to select the correct dataset for the recipe Reassignment rate you want to display. See example below: