Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a table with 3 columns:
Date Stock Coverage
01/01/2015 44 10
02/01/2015 0 30
03/01/2015 18 45
04/01/2015 0 12
05/01/2015 23 33
I have to create a bar chart with x-axis having date values.
On y-axis, i need to display the Coverage as follows:
ON x-axis, if stock of previous day is 0 then i have to display the Coverage. Else if stock of previous day has a value > 0 then the Coverage is forced to be displayed as 0.
Example for the bar chart (x-axis displays column date and y-axis displays column Coverage😞
For x-axis date value 05/01/2015, the y-axis value must be 33 as the stock of the previous day 04/01/2015 is 0
For x-axis date value 04/01/2015, the y-axis value must be forced to 0 as the stock of the previous day 03/01/2015 is 18 (i.e. greater than 0)
For x-axis date value 03/01/2015, the y-axis value must be 45 as the stock of the previous day 02/01/2015 is 0
For x-axis date value 02/01/2015, the y-axis value must be forced to 0 as the stock of the previous day 01/01/2015 is 44 (i.e. greater than 0)
For x-axis date value 01/01/2015, the y-axis value must be 10 as there is no previous stock value
On my bar chart properties, I have set the following properties:
Column Date is set as the Dimension
For expression, i set it as :
=
if (
Sum({$<Date={">=$(=max(Date(Date-45)))<=$(=max(Date)))"} >}Aggr(sum({$<Date={">=$(=max(Date(Date-45)))<=$(=max(Date)))"}QTY_STOCK),Date-1)) > 0,
0,
Coverage)
Grateful if you could please help 
Thanks in advance
Accepted Solutions
