Showing data for today() but display sunday's date on axis

[stevejones1]

Hi

Please take a look at the attached application .. i am trying to plot data of sundays on x-axis , the data is stored for each day in the table , but need to show weekly data in chart , is there a way that i could show future weekend date(sunday - 7/9) on x-axis but display max date ( today()) data ?

Thanks!

[vishsaggi · Accepted solution]

May be this ?

Change your dimension to:

=if(weekday(OpenDefects_EventDate)='Sun',Date(OpenDefects_EventDate), Date(WeekEnd(Today())))

Expression to:

= if(weekday(OpenDefects_EventDate) = 'Sun',Sum({<OpenDefects_Segment = P({<Trends_Priority, Trends_L1>} Trends_Segment), OpenDefects_ScrumTeam = P({<Trends_Priority, Trends_L1>} Trends_ScrumTeam)>} Total_SLAviolated_Bugs),

                                                  sum(if(OpenDefects_EventDate = today(), Total_SLAviolated_Bugs)))

[stevejones1]

Thank you!