Consider the following screen grab. The output format of the date pickers are set to Unix format. How can you use the filter actions to filter the bar/line chart?

  • 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