Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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?