Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
PFA.
We have yearly data but on chart(on x axis) we have to show MAR-Yearname (Mar1990,Mar1991) but data should be yearly.
Can you please suggest on this
Thanks
If you have Date Field in your Script, create MonthYear as below
Date(MonthStart(Date),'MMMYYYY') as MonthYear...
Now use below as calculated dimension in your chart
=Aggr(IF(WildMatch(MonthYear,'Mar*'),MonthYear),MonthYear)
You do not have a Year colomn in your script? because that would be the easiest.
I suggest editing your script and add a Year Column.
Hi Manish,
It is not working.
Thanks
Hi Manish,,
After modifying script suggested by you I am able to see data only for march for all years.
When i click on other month it is showing blank.
Thanks
Provide sample application...
Hi,
After modifing script as suggested by Mr. Manish.
Just add MonthYear as your Dimension.
Regards
Hi Deepak,
change expression like below
=
Sum({<MonthYear={'Mar'}>}aggr(Nodistinct sum(Amount),Year))