Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have to requirement to bring monthstart & Monthend value alone
And my chart is last 6 months of
dimension : MonthName(business_date)
Measure :
Sum({<business_date=(">=$(=monthstart(max(business_date),-5))<=$(=monthend(max(business_date),-5))" >}Amount) for total
Sum({<business_date=("$(=monthstart(max(business_date)))" >}Amount) for Opening //Not working
Sum({<business_date=("$(=monthend(max(business_date)))" >}Amount) for Closing //Not working
So Tried in script
Load
business_date,
Amount,
if(business_date=Monthstart(business_date),Amount,Null) as opening, //Ok
if(business_date=Monthend(business_date),Amount,Null) as ending //incorrect
From Table1;
Help me to get opening and ending alone
Try like:
if(Floor(business_date)=Floor(Monthend(business_date)),Amount,Null) as ending
Try like:
if(Floor(business_date)=Floor(Monthend(business_date)),Amount,Null) as ending
Thanks Tresesco ,Its working
But another issue. My app was based on daily data.
So for April 2020,i have data only till April 02. In that case need to show April 02 Amount value as closing.
Try something like:
Sum({<business_date=('$(=date(max(business_date)))' >}Amount)