Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Line chart to show weekinmonth

I want to show weekinmonth trend line for my data ( I have data from August - December) and I further drill it down to weekinmonth as per below ilustration.      However, for December ...
Need Help
  • az38's avatar
    az38
    6 years ago

    Anonymous 

    it seems i got it. try to create a new field weekinmonth which will look like "Nov-1","Nov-2","Nov-3","Nov-4", "Dec-1","Dec-2", etc..

    now its still aggregated by all model with no regards to month.

    do not hesitate to give a kudo to useful posts and mark solutions as solution

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous 

doesnt matter. try to insert this column into hierarchy

do not hesitate to give a kudo to useful posts and mark solutions as solution

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi az38 , 

 

I tried creating a hierarchy with month as below. But still it shows 5 weeks for December (12). 

 

Any idea how to solve this 

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous 

    it seems i got it. try to create a new field weekinmonth which will look like "Nov-1","Nov-2","Nov-3","Nov-4", "Dec-1","Dec-2", etc..

    now its still aggregated by all model with no regards to month.

    do not hesitate to give a kudo to useful posts and mark solutions as solution