How to Last month values on the Current month Graph

[kaushi2020]

Hello Everyone,

I am using a combo chart where I am showing Count for rolling 12 Months as Bar. 

I wanted to show dots/line in a combo chart where these dots represent values from the previous Year. Is it possible ?  

Dimension - MonthYear

Measure: Sum({<Year, Month,Date={"$(='>=' & Date(MonthStart(addmonths(Max(Date), -12))) & '<' & Date(Max(Date)))"}>}
Count)

[anat]

use Month field as a dim instead of monthYear

then you can use 2 measures to show current and previous year data

[kaushi2020]

thanks for your reply. but reading the data will be difficult as the user will have to assume based on the calendar date. is there any other ways we can plot the points ?

Expectation is to  plot data for the previous MonthYear on the bar as a line. 

[Chanty4u]

Try this

Dimension: MonthYear

Measure for Bar (Rolling 12 Months):

Sum({<Year, Month, Date={"$(='>=' & Date(MonthStart(addmonths(Max(Date), -12))) & '<' & Date(Max(Date)))"}>} Count)

Measure for Dots/Lines (Previous Year):

Sum({<Year={$(=Year(Max(Date))-1)}, Month>}

Count)

[kaushi2020]

thanks for your reply, Expectation should be we should get values of Jan-22 on the Jan-23 Bar chart. 

here when we use the shared expression - it will show the same as Jan-23 instead of Jan-22 for the bar. Please suggest.