Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
use Month field as a dim instead of monthYear
then you can use 2 measures to show current and previous year data
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.
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)
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.