Skip to main content
Question

Hi All,I have a PQL formula that is getting an average value of a data, but it is showing different value in KPI List view and Table View.

  • July 3, 2023
  • 1 reply
  • 12 views
khairus.solih
Level 1
Forum|alt.badge.img

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.

    1 reply

    S
    Level 6

    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

    Community Code of ConductAccessibility statement