Filter a table based on variable

[gcislo]

I have a table with a field startTime which shows the date and time of an entry. I also have a user variable filterDate. I want to give the user the option to either show the full table or all the entries on or after that filterDate. I am open to both filter expressions for chart options. Thank you!

[pravinboniface]

I would use a toggle button to let the user switch between 'Full Table' and 'Filtered Table'

You can apply your Date filter (vFilterDate here) to select accordingly.  Since the date is a dimension, uncheck 'Include null values'

// vButton is a variable attached to a button to show full  table or filtered table
=if ( $(vButton)= 'Filtered Table',
   // Filter button selected
	if (TempDate>=$(vFilterDate),date(TempDate),Null()),
    // Full table
    date(TempDate)
    )

[gcislo]

Thank you! I will give it a try.