Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a scenario where I have already solved one problem, but now I have another:
- From my base_data I have
- lorrys that were announced and arrived
- lorrys that were announced, but did not arrive
- lorrys that arrived unannounced
- I wanted two of those three stacked (the announced_arrivals and the unannounced_arrivals)
and the third (the announced lorrys that did not arrive) as a second column.
=> I created a combochart with two dimensions, one of them being "arrived<->not_arrived". Now I have just what I wanted - so far.
Now, there is something more that I would like in that chart: The delta between the nr._of_announced and the nr_of_arrived - that should pretty much always be between -5% and +5% or so. That should be calculated as follows:
>>> ((total_nr_announced) - (total_nr_arrived)) / (total_nr_announced) <<<
To get the first (the total_nr_announced), I obviously have to sum up (for any one day (the first dimension)) across the second dimension.
Somehow, that won't work - I can use set_analysis to calculate both the announced_arrived and the announced_not_arrived, but when I try to just add the one to the other, it breaks...
Can someone help me there?
Thanks a lot!
Best regards,
DataNibbler
Hi all,
this is solved - in part.
I put this aside for the time being as the figures in the base_data don't seem to match ... I have to see clearly through that first.