Categoric kpi report fails when the metric is a calculated field
I've tried to create a categorical kpi report with the following columns:
- Department (Keyed on)
- Invoice per person with metric-> calculated field: sum(invoice)/countdistinct(oiduser)
Once the KPI is configured, the results in the Output looks good but, after activating the report, it shows and error like "Error retrieving results".
After so many tests, I've realized the problem was the calculated field. Once I've changed it for regular metric field, it has worked fine.
Is it an issue? If not, how could I create a KPI from a calculated metric?
Many thanks for your help.