I have table data that I am trying to filter to show only today’s date. It still continues to show all the records. I am pulling from MySQL cloud. The filter I am trying to use is [retrieval_date]=today()-1.
This doesn’t work. I didn’t know if it was because I have the free version right now.
Your expression looks fine. It will return all those records where the date in [retrieval_date] is equal to yesterday.
But where have you put this expression.
We need some more info to help you out:)
Thanks you for the help. I am putting that information in the display setting of the ux in the “show if” formula bar. I am evaluating this product, but if i can’t easily get this data to filter to a specific date, it may not be worth it.
I also can’t seem to get the table view to appear on a desktop when i go full screen. Any tips?
Hi @Onlyworm15 Have you had a look at these.
Onlyworm15:
The filter I am trying to use is [retrieval_date]=today()-1.
Where are you using this expression?
Onlyworm15:
I didn’t know if it was because I have the free version right now.
That’s not the problem.
Onlyworm15:
I am putting that information in the display setting of the ux in the “show if” formula bar.
Yeah, that’s not where it goes. Show if in a view determines whether the view itself is displayed, not which content the view displays.
Onlyworm15:
I also can’t seem to get the table view to appear on a desktop when i go full screen.
That may have to do with your Show if expression. I suggest you remove the Show if expression, as it doesn’t do what to want.
As @Lynn noted, you should look at slices.
Thank you, Lynn. I will review these this morning.