- Put a hidden data to the bar/line chart which contains the dates in unix format, check that format type is set to number and place filtering logic to filter the data where it is greater than or equal to the variable value for the start date and less than or equal to the variable value for the end date.
- Check to see if the X-axis format is set to Date/Time and the input format is recognized correctly, impose a filter where the X-axis is filtered to show data on or after the variable value for the start date and on or before the variable value for the end date.
- Put a hidden data with the following formula BETWEEN( DATE( @B:B,”yyyyMMdd”), $start, $end ) and apply the filter action to select the “True” cases.
- All of the above
Subscribe to our mailing list and get interesting stuff and updates to your email inbox.