Modifications on chart

[deepakqlikview_123]

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

[MK_QSL]

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)

[#3]

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.

[deepakqlikview_123]

Hi Manish,

It is not working.

Thanks

[deepakqlikview_123]

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

[MK_QSL]

Provide sample application...

[PrashantSangle]

Hi,

After modifing script as suggested by Mr. Manish.

Just add MonthYear as your Dimension.

Regards

[perumal_41]

Hi Deepak,

change expression like below

=

Sum({<MonthYear={'Mar'}>}aggr(Nodistinct sum(Amount),Year))