Hi @XIN WANG? , Thank you for your question!
One of the possible options to filter rows in a dataset by a specific date would be to use filter rows-->on column values-->is exactly.
By putting the value inside single\double quotes, you'll be able to filter by the desired date:
An alternative way would be to choose the desired date from the data grid itself - and use Trifacta's suggestions:
In this scenario, Trifacta is using the "custom single" option, with the MATCHES() function: (can see this by clicking 'edit' in the suggestion)
A third option would be to use the Histogram. you can choose a bar (or multiple bars) from the Histogram and edit the suggestion to your preference:
See that only the selected bar is highlighted in dark green.
Now I can change the condition to the relevant date:
Finally, if your values are date\time values, you can use Trifacta's suggestion through the Histogram to only keep date\time values that are 'bigger' than your desired day and 'smaller' than tomorrow.
I hope that makes sense; please feel free to ask any additional questions.
Thanks,
Amit.
