0 Replies Latest reply: Aug 10, 2016 7:02 AM by Supriya R RSS

    Need to show only last 8 Weekstart- Weekend in line graph

    Supriya R

      Hi,

       

      i have a line graph, where i  want to display data in graph for only last 8 weeks.

       

      Here i have Dimension :    Week_Group_Year

       

      date(WeekStart(CanonicalDate), 'MM-DD-YYYY') &' - '& date(WeekEnd(CanonicalDate), 'MM-DD-YYYY')  as Week_Group_Year,  

       

      Expression :

      Count({$<DateType={signed},user_signed={1},

      CanonicalDate = {"<=$(=WeekEnd(today(),-1))"}>}invitation_id)

       

       

      But when i give fixed number in properties of dimension to 8. It shows more than last 8 weeks weekend and Weekstart datas.

       

      How to fix it to show only to last 8 weeks.

       

      i have attached qvf file, please refer it

       

      Please help me.