Forum Discussion
Advocate IIIRolling Period Calculation - Last 60 Days from Today's date
From the Last60Days definition, it puts 1 or 0 against each date row in the calendar table.
You are displaying in the table chart the Last60Days. The measure you want to display is the number meetings in the last 60 days. Where do you get this from? is it the count of rows against each name ?
If it is the count of rows against each name, put that as values in the table chart. Then in the Visual Level filters drag the Last60Days column . clikcon the Last60Days field and the show items when the value is , set it to 1 .
This should work.
Try it out and let me know. If it works please accept it as a solution and also give kudos.
Advocate IIIAnonymous and Habib
Although, I have no run into another issue. It's calculating the count of the planned meetings and completed meetings in the last 60 days. However, for the planned meeting it also needs to count the future meetings after today's date.
