Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a requirement where I have to display the bar chart till only the current month. Need help on how to achieve this functionality?.
Details:
I have Data from 2016 till 2020. But I want to restrict my bar chart to display till current month.
Hi,
you should use the set analysis for that.
Below is the example.
Sum({<Date = {"<=$(=Monthend(today()))"}>}Sales)
For more information on Set analysis, find below link.
Regards,
Kaushik Solanki
My preference would be, create Month field with integer and use formula like
Sum({<MonthNum = {"$('<=' & =Max(MonthNum))"}, Year={"$('<=' & =Max(Year))"}>} Sales)
Hi,
you should use the set analysis for that.
Below is the example.
Sum({<Date = {"<=$(=Monthend(today()))"}>}Sales)
For more information on Set analysis, find below link.
Regards,
Kaushik Solanki
Hi @Naushad07 ,
You can restrict it using calculated dimension, edit your dimension like below (keep date format as per yours) :
=if(date(yourDateField,'dd/mm/yyyy')<date(MonthEnd(today()),'dd/mm/yyyy'),yourDateField)
OR use exp like this
=Sum({<yourDateField= {"<=$(=MonthEnd(today()))"}>}yourQuantity)
My current Expression is
Count({<SetAnalysis={'Condition1'}>}Distinct Projects)
I am taking Month in X axis..
I have tried the expression that you have suggested..looks like it doesn't work
It doesnt matter, your X axis could be month, but the Date filter used in set analysis, will filter month by default.
Try the given expression and you will see the difference.
Regards,
Kaushik Solanki