Forum Discussion

andrewjmdata's avatar
andrewjmdata
Frequent Visitor
8 years ago
Solved

Date Hierarchy Issue

Hi, I have tried to search for an answer for this issue but can't find anything that works with my older version (2.41).   My objective is to have a filter on my report where the user can drill dow...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hello,

     

    I think you need to use diffrent filters for Year/Month/Date with the proper relationship so i will works on page.

     

    Thanks,

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hello,

 

I think you need to use diffrent filters for Year/Month/Date with the proper relationship so i will works on page.

 

Thanks,

andrewjmdata's avatar
andrewjmdata
Frequent Visitor
8 years ago

That seems to work very nicely. Thank you very much Pankil :smileyhappy:

 

I am afraid I now have a further question:

 

1. When the top level of the hierarchy year, is selected, is there a way to make the month and day go to all. Otherwise user is stuck with same day/month as made in previous selection.

 

Thanks

 

Andrew

  • andrewjmdata's avatar
    andrewjmdata
    Frequent Visitor
    8 years ago

    I may have the answer myself, though it's not very elegant.

     

    Click on the little eraser/rubber icon in top right of filter rests filter to all.

     

    Hope this helps someone.

     

    Andrew

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Yes that means you clean the filter in slicer. not affected on data its just a filter value will be clear.

       

      Thanks

      • andrewjmdata's avatar
        andrewjmdata
        Frequent Visitor
        8 years ago

        Thanks for your help in solving this issue.

        Andrew