Both views are using the same PQL formula which is getting the average value of a data and no filters were applied in the views.
Page 1 / 1
Hi,
normally this means that you use information from a data model table in the table that is on a more granular level than the one your KPI is referencing to.
E.g. if you want the average of some value in your cases table and define the formula AVG(CASES.VAL) it will return the average on cases level when used alone in a KPI. However, if you use the same formula in a table where you also include activity information (e.g. the case_ID), the average is computed on activity level, i.e. the tables are first joined (the value of the cases table is appended to each of its activities).
BR
Stephanie
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.