DISPLAY DAYS OF THE WEEK

[#1]

I have a  Bar  CHart with Completion Week as Dimension and have following fields available

Completion Date

Completion Day

Completion Week

Count({<[Completion Year] = {'2014'}, [Module Status] = {'Completed'}>} [Module Status])

Now I wanna display the Count for each Week in a Bar Chart, I am getting the right result, but  in the  display I wanna display the week Dasy instead of the Week NO

For example Week 28 I wanna Display (07/01/2014-07/06/2014)

Any Help is appreciated

[MK_QSL · Accepted solution]

You can use....

Below aggregated dimension

WeekStart([Completion Date]) & ' - ' & WeekEnd([Completion Date])

instead of [Completion Week]

[rustyfishbones]

Try adding the following as Your Dimension

=WEEKSTART(Date) & ' - ' & WEEKEND(Date) & ' (' & Week & ')'