Hi Vivek Nayagam,
This doesn't look good. I want it in red frame.
This can't be done with a hierarchy. This must be a parameter. INTERVAL parameter must be interactive.
I would like to see daily, weekly and monthly results in one chart using the parameter.
Date Interval is my calculated field.
What u exactly want to show when u select week level.
what i mean to ask is, do u want to show interval like 11 jun-16 jun or just start of the week.
Hi Sonali Chavan,
I want to show week number (Week 10, Week 11, Week 12...) when i select Weekly Interval,
show hours (8 AM, 9 AM, 10 AM...) when select Hourly Interval,
show days (Jul 1, Jul 2, Jul 3, Jul 4...) when select Daily Interval
show months (Apr 2017, May 2017, Jul 2017...) when select Monthly Interval.
All with one parameter INTERVAL.
Try this, I used order date from super store database. giving what you want.
then DATENAME('month',[Order Date])+"-"+STR( YEAR([Order Date]))
then DATENAME('month',[Order Date])+"-"+ STR(DAY([Order Date]))
ELSEIF [Interval]='Week' then
"week"+"-"+ STR( DATEPART('week',[Order Date]))
This is it! Thank you very much.