Use this script:
LOAD Floor(wk) as wk,
Floor(Flag) as Flag,
(ooxml, embedded labels, table is ALL_D, filters( Replace(1, top, StrCnd(null))))
Then create a bar chart with the following dimensions:
And use sum(Value) as expression.
Click on the + in front of the expression on the Expressions tab, select Background color and enter an expression that sets the background color for Base1 and Base2 to transparent: if(Match(Status, 'Base1','Base2'),red(0),color(FieldIndex('Status',Status)))
Hi Thanks for the response.
I have huge data to be processed behind and I can't include that data as sample.
but I am able to get exact values as chart below, but i am unable to get the previous row value using
Here is the formula
RealTotalSubmit= (Submit-1 + Submit-2 + Submit-3 + Submit-4 + Submit-0)
Base1 =if(Flag=1, RealTotalSubmit)
Base2 =if(Flag=1, RealTotalSubmit)
Base3 =if(Flag=1, RealTotalSubmit)
I tried 'Base1 = Above(Base3)', but not working.
I can get accumulation in bar chart so in just need Base1 to get the previous Remaining value for Base3 or Base2
What are the expressions behind Submit-1, Submit-2, Submit-3 etc? Making an assumption that they are Sum(Measure1), Sum(Measure2), Sum(Measure3) and so on, this is what you can try:
Sum(TOTAL <Week> Measrure1),
Sum(TOTAL <Week> Measrure2),
Sum(TOTAL <Week> Measrure3),
Sum(TOTAL <Week> Measrure4),
Sum(TOTAL <Week> Measrure0))
[Total Submitted] -
Sum(TOTAL <Week> Verified),
Sum(TOTAL <Week> Postponed),
Sum(TOTAL <Week> Closed),
Sum(TOTAL <Week> Rejected))
So the main thing here is the use of TOTAL here. Read about it here: What does the TOTAL qualifier do?