Calendar Object

[#1]

Hi,

I'm having data for two years. I used calendar Object for Date. My business case is.

if customer selects date in the calendar object. user must the selected date, Previous month same date and previous year same date and month. what to display in line graph or bar graph.

Ex:

if customer selects 1Aug2016 from calendar,

1aug2016    1july2016      1aug2015

  10                     9                        16

Could you help how to achieve this

.

Enclosed same data.

[settu_periasamy]

You can try with dimension less bar chart..

Expression 1: sum(Offerings)

Previous month: Sum ({<Date={'$(=Date(addmonths(Max(Date),-1)))'}>}Offerings)

Previous year: Sum ({<Date={'$(=Date(addmonths(Max(Date),-12)))'}>}Offerings)

[#3]

Hi,

for prior month the above logic is not working. Its showing count as 0.