
1. Re: Make a plot showing a "total" and a "sum of a subset of components" (over time) where sum is less than the total i.e., there are "missing data".
swaroop.gantela Jul 9, 2018 7:14 PM (in response to Trevor King)Trevor,
Please see if the workbook attached in the Forum Thread could give ideas.
This approach takes a few steps.
The Total Europe Value per Year is:
{FIXED [Year]: SUM ( IF [Country]="Total Europe" THEN [Oilcons Mt] END ) }
Similarly, the Total of all the Countries (minus the country called "Total Europe" is:
{FIXED [Year]: SUM ( IF [Country]<>"Total Europe" THEN [Oilcons Mt] END ) }
So the missing difference per year is the difference between the above two:
[Total Europe][Country Total]
To add this to the Area Graph, I created an new plot value:
IF NOT(ISNULL(ATTR([Region]))) THEN SUM([Oilcons Mt])
ELSE SUM([Missing Difference])
END
I removed the Region filter that was there on the Area Graph
and aliased the Country of "Total Europe" to "z Missing Countries"
I'm not sure if these manipulations will affect your other graphs.
275153missing.twbx 229.4 KB
