Line chart does not show correct data from pivot table - RangeSum() and Above()

carotravaglini — Wed, 22 Dec 2021 20:40:09 GMT

Hi,

I have the next pivot table:

where the column number 8 is calculated as column7/column3

This columns (3 and 7) are the sum of the above per year

The function is:

(RangeSum(Above((Count (Legajo) * 9 - Fridays),0,12)))/(RangeSum(Above(((count(distinct(leg_numero)) - count(distinct(if([leg_fecegr.autoCalendar.Date]<[Fecha.autoCalendar.Date],leg_numero))) - count(distinct(if([leg_fecing.autoCalendar.Date]>[Fecha.autoCalendar.Date],leg_numero)))) * (Days_w*9 - Fridays)),0,12)))

This is working well, the problem is when I want to represent the column number 8 as a line chart:

The values that are shown here are not the same that i have in the pivot table and i dont understand why.

Later, i found out that if i group by year and use the months as the line, the values are the expected, but i want to see them as is shown in the picture above.

Here is the line graph group by year and using month as line:

I think it may be because of the rangesum or the above, but im not sure.

Is there any reason why the values are not showing correctly in the first option? Because the funcion is the same!

Thank you!!

Caro

Re: Line chart does not show correct data from pivot table - RangeSum() and Above()

carotravaglini — Thu, 27 May 2021 13:59:53 GMT

I still haven't found the solution.

topic Line chart does not show correct data from pivot table - RangeSum() and Above() in App Development

Line chart does not show correct data from pivot table - RangeSum() and Above()

Re: Line chart does not show correct data from pivot table - RangeSum() and Above()