Data to display KPI comes from ‘Analysis’ (existing analysis within Kyubit Business Intelligence application), ‘MDX Query’ or ‘TSQL Query’. Value to be evaluated as relevant for KPI is the last value in the first series of values retrieved from analysis or query. All other values before last values are considered as historic supplement of values and are used to describe trend and last value change (delta).
KPI value is first value in first series of query values, other values are used to draw line chart and penultimate value is used to show ‘last value change’.
Same principles are used if data is retrieved from ‘Analysis’ or ‘MDX query’.