Endash
DashboardBlog
Endash
  • 🏡Home
    • Endash guide
  • 🚀Start guide
    • Welcome to Endash
    • Quick Onboarding
  • 📊Dashboard
    • Authentication
      • Sign up
      • Sign in
      • Accept the invitation to a team
    • Dashboard
      • Onboarding your Dashboard
      • Create a blank Public/Private Dashboard
      • Create a Public/Private Dashboard from Template
      • List of your Dashboards
      • Arrange Dashboards order
      • Dashboard permissions and Invite Members to private Dashboard
      • Delete a Dashboard
      • Rename a Dashboard
      • Duplicate a Dashboard
      • Add a description to a Dashboard
      • Refresh a Dashboard
      • Add favorites
      • Export PDF
      • Publish dashboard
      • Dashboard subscription
        • With email
        • With Slack
      • Dashboard comment
    • Widget
      • Add any Widget type with any available Data model
      • Arrange Widgets order
      • Delete a Widget
      • Rename a Widget
      • Duplicate a Widget
      • Refresh a Widget
      • Move or copy a Widget to another Dashboard
      • Alert
    • View details of Widget
      • Arrange Views order
      • Delete / Rename / Duplicate the View of a Widget
      • Create / Delete / Rename / Duplicate a new View of a Widget
      • Add a description to a Widget
      • Check the Views of Widgets on the Dashboard
      • Export to CSV or XLSX
    • Dashboard - Filter
      • Filtering the Dashboard
        • Add the Dashboard filters
        • Edit the Dashboard filters
        • Delete the Dashboard filters
      • Personal Dashboard filters
      • Override Dashboard Filters on child widgets
      • Filter per widgets
    • Widget types
      • Table
        • Table - Drag and Resize columns
        • Table - Hide/Show column
        • Table - Pin column
        • Table - Search
        • Table - Footer formula
        • Table - Filter
        • Table - Sort
        • Table - Grouping
        • Table - Time series
          • Table - Time series - Reference date preset and Compare to the past
          • Table - Time series with Grouping
      • Bar (chart type)
        • Bar chart - Change to other types
        • Bar chart - Filter
        • Bar chart - Sort
        • Bar chart - Time series - Reference date preset and Compare to the past
      • Line (chart type)
        • Line chart - Filter
        • Line chart - Time series - Reference date preset and Compare to the past
      • Pie / Donut (chart type)
        • Pie chart - Filter
        • Pie chart - Sort
      • Board (chart type)
        • Board chart - Filter
        • Board chart - Time series - Reference date preset and Compare to the past
      • Combo chart (chart type)
        • Combo chart - Change to other types
        • Combo chart - Filter
        • Combo chart - Sort
        • Combo chart - Time series - Reference date preset and Compare to the past
      • Pivot Table
        • Flat Pivot
        • Pivot Table - Filter
        • Pivot Table - Sort
      • Gallery
        • Gallery details
        • Gallery - Filter
        • Gallery - Sort
        • Gallery - Grouping
      • Goal (chart type)
        • Goal - Filter
      • AI Text note
      • Header note
    • Footer formula
    • Custom formula column
    • Custom column configuration
    • More customizations of Tables and Charts
    • AI Visualization
      • Just ask what you want
      • Checking your prompt
    • Settings
      • Plan & Billing
  • ⛓️Connect
    • Data Connectors (Trino, Fivetran, Endash provider, and Cigro Connector)
    • Select a data connector to connect
    • Upload CSV file
    • List of your Connections
    • Settings your data connection(s) (Trino, Fivetran, Endash provider, and Cigro Connector)
      • Connect - Status
      • Connect - Schema
      • Connect - Setup
  • 🎇DATA
    • Data Transformation
      • List of your Data Collections
      • List of your Data Connections
      • Add a Collection
      • Rename a Collection
      • Add a description to a Collection
      • Delete a Collection
    • Data Collection details
    • Build a Data model
    • Data model details
      • Rename a Data model
      • Add a description to a Data model
      • Delete your data models
      • Preview - Data model
      • Build - Data model
      • Columns - Data model
      • Related - Data model
      • Details - Data model
      • Duplicate a Data model
    • Build and modify a data model with our AI query
    • Data of Connection details
      • Add a description to a Data of Connection
      • Columns - Data of Connection
      • Preview - Data of Connection
      • Related - Data of Connection
    • Directed Acyclic Graph (DAG)
  • Other guides
    • Endash: Connectors
    • Endash: Export to Google Sheets
    • Endash: Data Templates
  • Need more help?
    • Contact us
Powered by GitBook
On this page
  • Date
  • Select a Date type item
  • Calendar widget - Presets
  • Calendar widget - First day of the week
  • Select any or all Date items
  • Finish your Date filter setup
  • String
  • Select a String type item
  • "Contain and Not contain" options
  • "Is and Is not" options
  • Finish your String filter setup
  • Number
  • Select a Number type item
  • Finish your Number filter setup
  • Boolean
  • Select a Boolean type item
  • Finish your Boolean filter setup
  • Dashboard filter rules
  • Save your changes publicly to the team
  • Associated values

Was this helpful?

  1. Dashboard
  2. Dashboard - Filter
  3. Filtering the Dashboard

Add the Dashboard filters

PreviousFiltering the DashboardNextEdit the Dashboard filters

Last updated 7 months ago

Was this helpful?

Date

Select a Date type item

  • Click on an item of Date type to begin.

  • The filter will auto-set you a filter name. Click on the Filter name field to edit.

Calendar widget - Presets

  • Click the Date box to open the calendar widget for selecting the date.

  • The Presets on the left side will have a range of options for quickly filtering your Dashboard.

The default preset is Recent 7 days.

  • You can custom-select your desired day range by interacting with the calendar widget on the right.

  • Simply pick the start day and end day, month, and year for your Date type filter.

Calendar widget - First day of the week

  • To change the First day of the Week for your Date filter, click on its dropdown box and choose one of the options.

  • The calendar widget will update the First day of the week based on your option.


  • Press the Done button to confirm your Date range selection in the Calendar widget.

  • Press the Reset button to start again your Date range selection in the Calendar widget.

  • Press the Cancel button to close your Date range selection in the Calendar widget.

Select any or all Date items

  • You can choose more than one item of the same type.

  • To quickly select all of the items, click the checkbox next to the Name type.

The date range option in the Calendar widget will affect all of the selected columns of the Data model.

  • To deselect an item:

    1. Click on the X button of that tag in the top field.

    2. Click again on the Date type item.

Finish your Date filter setup

  • Press the Done button to confirm.

  • Press the Reset button to start again.

  • All the data will be filtered and displayed according to that filter.


Select a String type item

  • Click on an item of String type to begin.

  • Click on the String dropdown box to select the String filter options.

The options are:

  • Contain

  • Not contain

  • Is

  • Is not

"Contain and Not contain" options

  • Click on the field to input your desired text to be filtered.

  • With the Contain option: the Widget will only display the data that matches your inputted text.

  • With the Not contain option: the Widget will display the data that does not match your inputted text.

  • Contain is the default option.

"Is and Is not" options

  • After choosing the Is or Is not options, select the dropdown next to the right

  • The Item column contains the value of the column next to the Column name

  • You can input to search for the value that you want.

  • You can manually select the item that you want.

  • You can select all the items when clicking on the top check box.

  • With the Is option: the Widget will only display the data that matches your selected items.

  • With the is not option: the Widget will display the data that does not match your selected items.

Finish your String filter setup

  • You can also change the filter name in the Filter name field.

  • You can multi-select all items or deselect an item normally.

  • Press the Done button to confirm.

  • Press the Reset button to start again.

  • All the data will be filtered and displayed according to that filter.

Select a Number type item

  • Click on an item of Number type to begin.

  • Type your desired number to filter.

  • Click the operator dropdown to select your desired option.

Finish your Number filter setup

  • You can also change the filter name in the Filter name field.

  • You can multi-select all items or deselect an item normally.

  • Press the Done button to confirm.

  • Press the Reset button to start again.

  • All the data will be filtered and displayed according to that filter.


Select a Boolean type item

  • Click on an item of Boolean type to begin.

The default boolean state is ON, which is the "True" option.

  • To change to the "False" state, click on the toggle to turn OFF.

Finish your Boolean filter setup

  • You can also change the filter name in the Filter name field.

  • You can multi-select all items or deselect an item normally.

  • Press the Done button to confirm.

  • Press the Reset button to start again.

  • All the data will be filtered and displayed according to that filter.


Dashboard filter rules

Each Filter tag must have a name.

  • You can not set up the different filer types at the same time. For example: if you are adding or editing the Date type, other types will be disabled to choose.

  • You can start to add another filter by clicking on the "Add filter" button.


Save your changes publicly to the team

  • All the data will be filtered and displayed according to all the applied filters.

  • Click the Discard button to remove all your "personal filters".

  • Click the Save changes button to publicly apply all the filters to that Dashboard.

You can turn OFF the Filter toggle to disable and hide your "personal filters". Those filters will not be deleted until you click on the Discard button.

Associated values

  • After you have more than one filter, you can see that some values are associated with any previous filter, which provides better insight into how to filter your Dashboard.

Your Date filter will be displayed as a "".

String

Your String filter will be displayed as a "".

Number

Your Number filter will be displayed as a "".

Boolean

Your Boolean filter will be displayed as a "".

Your filters will be displayed as "" if you do not save changes.

📊
🅰️
🔢
🚩
personal filter
personal filter
personal filter
personal filter
personal filters
🗓️