Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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)
)
Thank you! I will give it a try.