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 I was able to figure out. I was leaving out a value "Status" which is the two type of meetings. I had it like this:
This now works and I verified it with the data itself.
Habib Is there an easier way to figure out the rolling period? I wasn't sure how to do it and saw the Today function from Matt Mason's blog.
Thanks everyone for your suggestions!
