Dashboarding- Bar chart with add calculated Dimension?

[#1]

Hello all,

I'm having trouble with the development of a bar chart, that  has as dimension an Interval of time and expression the following: previous year, previous month and actual date.

Can you give me some advices?

Thanks in advance.

Sérgio Duarte

[crusader_ · Accepted solution]

Hi,

Use below expression

=if( InMonth( Date, AddMonths(today(),-1),1) or InMonth( Date, AddMonths(today(),-13),1) or InMonth( Date, today(),-1),

  Date(monthStart(Date),'MM/YYYY'), null()

)

And Suppress Nulls in dimensions.

PFA.

Regards,

Andrei