Current vs previous period in table

[arusiva89]

Hi, 

  I am trying to show the current vs previous month record irrespective of the date selection.There is a issue in it ,when I compare the Feb vs Jan ,it is taking only 28 days instead of 31 days.Any idea to get all values in january?

[arulsettu]

Can you share your sample app

[arusiva89]

I don't have the desktop version,I will explain the logic used.I have set the flag in load script (addmonths(dt-1) and used the flag in set expression for previous month like (Sum({<Flag={'x''},Date=>}measure) 

[arulsettu]

Try ignoring the Month field in the expression

Sum({<Flag={'x''},Date=,Month=>}measure) 

[arulsettu]

Sum({<Flag={'x''},Date=,Month=>}measure) 

[arulsettu]

(Sum({<Flag={'x''},Date=,Month=>}measure)

[arusiva89]

It dint work

[arulsettu]

Provide some sample data to replicate the issue