Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to create a periode selection that shows year, month, week and then date and days.
Something like the picture below.
mon | tue | wed | thu | fri | sat | sun |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | 6 | 7 |
8 | 9 | 10 | 11 | 12 | 13 | 14 |
15 | 16 | 17 | 18 | 19 | 20 | 21 |
My problem is that I cant figure out how to do that.
And yes I have tried the calendar object, but that one is just ugly. I do not like it, and it does not give me the dayname.
Also I want to create this in a container and I want to use it with both the date and dayofyear.
Any one know how to solve this?
Dan
You can disregard this. I found a way to solve it.
Dan
How did you solve it?
Im looking to do somthing like that, but I would also display a calculated sales number on each date i the calender.
Hi
Actually all I did was that I created a pivot chart with two dimensions and one expression.
The two dimensions I use is week and dayname.
Expression is weekdate. =WeekDate
Week(ActualStartTime) as Week,
Day(ActualStartTime) as WeekDate,
WeekDay(ActualStartTime) as DayName
Then I left click the DayName and drag it to the top of the chart.(Not sure what that is called)
One problem with this method is that if you do not have any sales on a given day, that day will not appear in the chart.
I assume I could correct this by adding an inline fucntion where I just create a set from 1 to 31 and called that weekdate
In your case I guess you would need the expression =sum(sales)
BR
Dan