Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have a bar chart where dimensions : (snapshotdate,salesstage) , expression : sum(amount)
image is attached below....
now i want my bar chart to show the next 90 days amount for every snapshotdate....
i am trying to use following logic but not getting proper results....
if(floor(closingdate)>=floor(today()) and num(floor(closingdate))-num(floor(today()))<=90,closingdate)
how to integrate above logic in bar chart expression to get amount....
in load script do this way
load *,
if(closingdaydiff >=0 and closingdaydiff<=90,dual('0-90',1),dual('>90',2) as bucket ;
load closingdate,
today()- num(closingdate) as closingdaydiff,
otherfields from datasource ;
making bucket in script and in expression write
sum(if(bucket = '>90',amount))
Hi mohit,
It is throwing error of datedaydiff field is not found....
thanks ,
sachin
send me your file
HI mohit,
I dint find a option to attach file so i have again posted the question with attached qvd file.
thanks,
Sachin