ⓘ  Application Help

Overview

This application lets you explore and visualize data from the Fidelity database. Use the filters to narrow your date range and choose which data columns to display in both the table and chart.

Filters

  • Date range Choose a preset — This week, This month, or This year — or leave it on Custom and enter specific From / To dates. Selecting a preset automatically clears any custom dates.
  • From / To Enter dates manually when you need a precise range. Leave blank to include all available dates.
  • Columns Multi-select list. Hold Ctrl (Windows) or Cmd (Mac) to select multiple columns. Only the columns you select will appear in both the table and the chart. At least one column must be selected.
  • Apply Submits the filter form and reloads the page with updated data. Results are capped at the 50 most recent rows.

Toolbar Controls

  • Show / Hide Table Toggles the data table below the toolbar. Useful when you want more space for the chart.
  • All Series Displays every selected column as a dataset in the chart.
  • Small-Value Series Filters the chart to show only columns whose median value is less than 5% of the overall median. Useful when a few large-value columns are dwarfing smaller ones.
  • Use Logarithmic Scale Switches the Y-axis between linear and logarithmic. Best used when your selected columns span very different magnitudes (e.g. one series in hundreds, another in millions). A warning banner will appear automatically when this is recommended.
  • Chart type Switch between Bar, Line, Radar, Pie, Doughnut, and Polar Area charts instantly — no page reload required.
💡 Tip: The Y-axis always auto-fits to the range of your visible data, so trends in tightly clustered values remain visible. Toggle logarithmic scale if series with very different magnitudes need to appear together clearly.

Chart Interaction

  • Hover over any data point or bar to see a tooltip with the exact value.
  • Click a legend item to hide or show that series without changing your filter selection.
  • Pie, Doughnut, and Polar Area charts aggregate all rows — they work best with a small date range or a single column selected.

Scale Warning

If the ratio between the largest and smallest values across all visible columns exceeds 100×, a yellow warning banner appears. This is your cue to either use the Small-Value Series mode or switch to Logarithmic Scale for a more readable chart.

Tips & Limits

  • Results are limited to the 50 most recent rows per query.
  • The Date column is always included in the table for reference, even if not selected in the Columns list.
  • If no data appears after applying filters, check that your date range contains records and that at least one numeric column is selected.