Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 5 different charts with different calculations that when I am just looking at 1 customer the number is correct but when I look at total company it is not correct. I will give 1 chart as 1 example.
In one of the charts I am trying to calculate the seatbelt exceptions.
So in the line chart it is by date for the dimensions and for the expression I first tried this calculation and I was not getting any of the correct calculations for 1 customer on one date or correct calculations for total company.
the calculation should give me (if I could get it correct) on date 6/5/2017 1 customer (customer number 2) 3663 and for total company on that date it should give me 9963.
Try 1:
round(Sum({<FileDate = >}([Total Distance Miles] / Seatbelt)))
This gave me 1 customer = 896 and total company = 22088
Try2:
Next I have tried doing the calculation in the script.
So something like this:
LOAD
if((S10 + HB + SB + HA)=0,0,
round(TDM / SB) as SeatBeltS;
LOAD
Sum ([Total Distance Miles]) as TDM,
Sum (Seatbelt) as SB
Resident Scorecard;
and then I did this for the expression
Sum({<FileDate = >}(SeatBeltS))
This gave me for 1 customer = 3663 (which is correct) but for total company = 58494 (which is wrong)
I do not know what I need to do to get the total company to show the correct number?
I figured out what I need to do. For anyone in the future who might need this answer I had to sum up each by themselves.
round(sum({<FileDate = >}[Total Distance Miles]) / sum({<FileDate = >}Seatbelt))
I figured out what I need to do. For anyone in the future who might need this answer I had to sum up each by themselves.
round(sum({<FileDate = >}[Total Distance Miles]) / sum({<FileDate = >}Seatbelt))