How to reference current date in cockpit document

Question

I'm working on creating a cockpit and would like to create a table that only displays data for the last 30 days from my dataset. I know I can write my SQL query to only include those values in the dataset but I need the entire table for another chart in my cockpit and would like to avoid having 2 datasets if possible. Is there simple way to filter data with respect to the current date (like DATE_SUB(NOW(), INTERVAL 30 DAY) in a MySQL query)?

Answer 1

Add another column in the dataset called "IsItToday" with values Yes and No. For example you might have OrderDate in the dataset and if OrderDate is the same as Today() than the IsItToday will be Yes, if they are different then it will be No. Filter the widgets in the cockpit by that column.