Self-Service Visualization
  • What is Story?
  • Creating a new Story
    • Accessing the Story Module
    • Create New Story
      • Creating a new Story with an Existing Data Store
        • Creating and Updating Instance
      • Creating a new Story by Uploading a File (CSV/Excel)
      • Creating a new Story based on a Data Sandbox Data Store with Data Preparations
    • Designing a View
    • Saving Multiple Views
  • Design Workspace
    • Dimension Profiling
    • Measure Summary
    • Series Properties
    • Create Calculated Field
      • Creating a Formula
        • Record Level Option
        • Summary Level Option
      • Creating a Range
    • Order by and Limit
    • Adding a Slicer
  • Chart Gallery
    • Mixed chart
    • Area chart
    • Bar chart
    • Bubble chart
    • Column Stack chart
    • Line chart
    • Pie chart
    • Scattered Plot chart
    • TreeMap chart
    • Circumplex chart
    • Pareto chart
    • Semi Gauge
    • KPI Tile
    • KPI Tile: Comparative Tile
    • KPI Tile: Sparkline
    • Map
    • Data Grid
    • Metric Summary
    • Dissolution/Decomposition chart
    • Spider chart
    • Waterfall chart
    • Funnel chart
    • Inverted Funnel chart
    • Heat Map chart
    • Geo chart
  • Storyboard
    • Search
    • Shared Views
    • Live Refresh
    • Export
    • Alert Center
    • Change Theme
    • Data Store Information
    • Options Assigned to a View
      • Analyse
        • Timeline Play
      • Edit
      • Remove
    • Data Interactions/ Data Drills
      • Drill Into
      • Drill Through
  • Applying Filters
    • View Specific Filter
      • Dimension-based View Filter
      • Measure-based View Filter
      • Date-based View Filter
    • Global Filter
      • Exclude from the Global Filter
      • Saving a Global Filter
      • Custom View Filter
      • Like and Not Like Filter Operations
  • Interactions
Powered by GitBook
On this page
  • Between
  • Relative
  1. Applying Filters
  2. View Specific Filter

Date-based View Filter

PreviousMeasure-based View FilterNextGlobal Filter

Last updated 2 years ago

Check out the walk-through on how to filter a View based on Date values.

The users can apply Date based View Filter by selecting the Date Values from the Data Store. The user can provide two kinds of conditions on the Date values:

  1. Between

  2. Relative

Between

  • Click the Filter icon on the Design page.

  • The Filter panel opens, displaying all the available filter values.

  • Select a dimension or measure containing Date values to filter the view.

  • Choose the Between option from the drop-down menu.

  • Provide the From and To dates.

  • Click the Apply icon.

  • The selected view gets filtered as per the applied date filter conditions.

Relative

  • Click the Filter icon on the Design page.

  • The Filter panel opens.

  • Select a Date value as the filter condition.

  • Choose the Relative option from the drop-down.

  • Insert a period by selecting the required values.

    • The user gets the Last and This under the drop-down menu to select the past or present time zone.

    • There are 4 categories of time pointers provided in another drop-down menu, which allow the user to select a value out of Years/ Months/Weeks/Days. E.g., the below-given image displays the Last 5 years as the selected time condition.

  • Click the Apply icon.

  • The selected view gets filtered based on the applied date conditions.

Please Note: The same set of steps can be used to apply the Global filter based on the date values.​

Applying Date-based View Filter