Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Date filtering Error

Hi, 

 

I am wanting to use this date filter in my reports: 

 

 

I am also wanting to do a Year over Year comparison with the data after the date is selected:

 

    

 

As you can see, I filtered the October 17, 2016 - October 17, 2017; it's given me just that [ NOT year over year ].

 

 If I filter just October 17, 2017; 2016 column goes away :(

 

 

 

 

Could someone please help in this?

 

Need Help

8 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

    Your question is not clear.  What do you want to show in the Table visual?

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago
      Hi,

      I want to show current and last year's count for the same month and day that's filtered by the date slicer.
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI Anonymous,

     

    >> If I filter just October 17, 2017; 2016 column goes away Smiley Sad

    Current slicer only support show the filtered part. If you removed the 2016 part in your slicer, matrix visual will shows the filtered 2017 part.

    In my opinion, I'd like to suggest you write a measure to get the previous records based on calendar date.

     

    Regards,

    Xiaoxin Sheng