Get a Demo

Documentation

7 topics

Filters and Slicers

Delphi uses various filters and slicers to help you narrow down and customize your data views. Understanding these tools allows you to quickly find the exact information you need across projects, companies, and market data.

Between Filters

Range-based filters allow you to specify minimum and maximum values. Use the slider handles or type directly into the input fields to set your desired range. These are commonly used for capacity (tons H2/y, MW_EL_CAP), dates (Start of Operation), and other numerical values.

List Filters

Dropdown lists let you select from predefined options. Many lists support hierarchical selection - for example, selecting a region will show all countries within it. Use the search box within the dropdown to quickly find specific items, and use 'Select all' to include all options at once.

Search Filters

Search filters provide free-text search capabilities. Type your search term and the filter will match against relevant fields. The eraser icon clears your current search. Search filters are particularly useful for finding specific companies or projects by name.

Buttons and Multi-Selection

Delphi uses button-based selectors for categorical filtering. These provide a visual way to select one or multiple options from a set of choices.

Single-Select Buttons

Some button groups allow only one selection at a time. Click a button to select it - the previously selected option will be automatically deselected. These are used when options are mutually exclusive, such as selecting a capacity metric.

Multi-Select Buttons

Other button groups allow multiple simultaneous selections. Hold Ctrl (Windows) or Cmd (Mac) while clicking to select multiple options. Selected buttons appear highlighted. Use 'Select all' to include all options, or click individual buttons to toggle them on/off.

Clearing Filters

To reset all filters and return to the default view, use the 'Clear Filter' button located in the top-right corner of the dashboard. This removes all active filter selections and restores the full dataset view.

You can also clear individual filters by clicking the eraser icon within each filter control, or by deselecting all options in a dropdown list.

Cross-Filtering

Delphi dashboards are fully interactive - clicking on any visual element filters the entire page. This cross-filtering capability allows you to explore data relationships dynamically.

For example, clicking on a company in a bar chart will filter all other visuals on the page to show only data related to that company. Click on a country in a map to see all projects, investments, and contracts for that geography.

To remove a cross-filter, click the same element again or use the 'Clear Filter' button to reset all selections.

Drill-Down

Many charts in Delphi support drill-down functionality, allowing you to explore data at different levels of granularity. Look for the drill icons in the chart header to access these features.

For time-based charts, you can drill from years down to quarters, or from quarters down to months. For geographic charts, drill from regions to countries to specific locations.

Use the up/down arrows in the chart header to move between hierarchy levels. The current drill level is indicated by the chart title and axis labels.

Drill-Through

Drill-through allows you to navigate from a summary view to a detailed page for a specific item. This is particularly useful for accessing full project details or company profiles.

To use drill-through: right-click on a data point (such as a project name in a table or a bar in a chart), then select 'Drill through' from the context menu and choose the destination page (e.g., 'Project Details').

The destination page will be filtered to show only information related to your selected item. Use the back button or navigation menu to return to your previous view.

Best Practices

To get the most out of Delphi, we recommend the following workflow practices:

Start Broad, Then Filter

Begin with an overview of your area of interest, then progressively apply filters to narrow down to specific segments, regions, or time periods.

Use Cross-Filtering for Exploration

Click on visual elements to discover relationships in the data. This is often faster than manually setting multiple filters.

Leverage Drill-Through for Details

When you find an interesting project or company, right-click and drill through to access the full profile with all related data.

Clear Filters Regularly

If results seem unexpected, use 'Clear Filter' to reset and start fresh. Hidden filter selections can sometimes cause confusion.

Export Data as Needed

Every table and chart in Delphi supports data export. Use this to integrate Delphi insights into your own reports and analyses.

See Delphi in action.

Request a demo