Forum Discussion

mamdhooh's avatar
mamdhooh
Frequent Visitor
6 years ago

Slicer Issue

I have aslicer attched to to a date column in a table. The slicer is set to Relative date => is in the last => 1 => days ( not including last date ).   Does this default back to calculation of pag...
Need Help
rainer1's avatar
rainer1
Resolver III
6 years ago

Hi, 

 

this is the normal behaviour of the slicer.

 

When does the relative date calculation takes effect?

the relative date Filter is based on the actual real date not the date in a table. For example if you look today at your report and there is no date from yesterday in the date table it can't be filtered and it will show all dates.

 

Does this default back to calculation of page everytime user opens the report ?

Yes, the report is "sticky" as it saved user might use Bookmarks if they customized filters for their purposes.

 

-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
It was useful? Press Thumbs Up!

 

mamdhooh's avatar
mamdhooh
Frequent Visitor
6 years ago

Hi,

 

Thanks for the response, even if there is data for that day when you select the start date twice it does roll back to all dates. eg todays date 27-Jan- 2020 Relative date of 3 which is 24-Jan-2020

 

If I select 24-Jan-2020 and end date 24-Jan-2020, let it do the calculation and display the graph. Choose  24-Jan-2020 as Start Date second time. This is where it roll back to all dates.

 

Thanks