Can you please help me understand how are KPI's are calculated for a line item.
It is not giving me the first data in the grid, neither the average or the Sum. I wanted to understand how is it calculated.
The KPI card respects the page selectors at the top of the page like the other cards unless you deactivate this before publishing. This means as you change the year as an example the data in the KPI card will also change.
If you have multiple line items in the KPI module I have found using the custom view options and showing only the line item you want to appear on the card is the safest way to ensure the data shown is what you need.
Hope this helps,