Month as dimension

[Anonymous]

Hello Community

This question might be simple but I need some solution

I appreciate your time

In attached example I need Year and month as x-axis and sum(Val) is expression as Y-axis

Thanks

[sunny_talwar]

May be use

MonthName(Date)

or

MonthName(MakeDate(Year, Month, 1))

as your dimension and

sum(Val)

as Expression

[kolov007 · Accepted solution]

Hello.

You can use:

Year(Date)&'-'&Month(Date) as YearMonth

Field YearMonth you can use in chart. On tab "Sort" in the  chart properties tick near State - Ascending.

[Anonymous]

See if the attached helps

[maxgro]

See attachment

[MarcoWedel]

Hi,

one solution could be also:

hope this helps

regards

Marco

[Anonymous]

Hi Sunny

I appreciate your reply. Still I am getting one dimension only

Thanks

[Anonymous]

Hi Marco  Thanks for your reply, In case of month 6 is not available than I think we need use mod/avg function right?  I appreciate your very helpful answer