SEQUENCE CHART

[hemanthkumar_sm]

Hi All,

Can you help to build the dynamic chart  as per attachment,

Requirement:

when i am having current month (ex: May-18 is  i should display complete single row (from May-18 to  Jun -16, 24 months data) 

when i am having current month -1 (ex: Apr-18 , I should display 2 rows (from Apr-18 to Jun -16  , 23 months data)

similarly when i am having  current month -2 (ex-Mar-18, i should display 3 rows ( from  Mar-18 to Jun 16 , 22 months data)

same thing will continue for rest of the month.

[Anil_Babu_Samineni]

this can be done using If else condition.

[hemanthkumar_sm]

I Tried and it didn't work for me..

[Anil_Babu_Samineni]

Try this way? Where as MonthNum is in number format not string format for that Month field.

If(MonthNum=Max(TOTAL MonthNum),
Concat({<MonthNum = {">=$(=AddMonths(Max(MonthNum),-24))<=$(=Max(MonthNum))"}>} DISTINCT Date,','),
If(MonthNum=Max(TOTAL MonthNum-1),
Concat({<MonthNum = {">=$(=AddMonths(Max(MonthNum-1),-24))<=$(=Max(MonthNum-1))"}>} DISTINCT Date,',')
))

[hemanthkumar_sm]

Hi Loveisfail,

Still it is not working in my for me :-(.

[Anil_Babu_Samineni]

Can you attach QVW file