Using WeekName() function and noting what dates begin and end each week

[shinnickr]

Hi there,

Sorry for the confusing title....

Right now I am using the WeekName() function to call the week number, and using it in a bar chart.  What I'd like to do is have a pop-up text when someone mouses over a week it notes what days begin and end the week moused over.

For example:

The bar chart shows '2017/01' meaning the first week of 2017.  So, I'd like 'Week is from 1-2-2017 to 1-8-2017' to pop-up as text when someone mouses over the bar.

I'm sure I have to do something with WeekStart() and WeekEnd(), but I can't get the syntax correct.

Any help would be appreciated.  Thank you!

[sergio0592]

Hi,

In a bar chart, put WeekName(Date) as dimension.

As expression, put your expression and as a second expression (wich contains Date Start and End Date):

aggr(WeekStart(Date),Date)&' to '&aggr(WeekEnd(Date),Date)

Unckeck bar and check 'Text as pop-up'

Is it what you expected?