I have a requirement where i have to show x axis by Sundays dates .. the counts should be as of Sunday(Only on Sunday) in one chart (Open Defects) and a chart ( Find vs Fix) where i have to aggregate values per week ( sum of counts for days in a week - weekend date sunday on axis)
How do i achieve both conditions with same filter (By Week) .. i have a check box to select By Week(When Yes) .. which should show Weekend dates on Xaxis for both charts when selected else show Dates by day on axis.