Dashboard

App.tsx

import { QuillProvider, Dashboard } from "@quillsql/react";

function App() {
  return (
    <QuillProvider
      tenants={[{ tenantField: "customer_id", tenantIds: [2] }]}
      publicKey={process.env.QUILL_PUBLIC_KEY}
    >
      <Dashboard name="Transactions" />
    </QuillProvider>
  );
}

Dynamically displays a filterable grid of charts, metrics, and tables with live data from your database. Once implemented, Quill lets you perform zero-downtime, zero-code updates to your dashboard on an org-level as well as company-wide.

Make sure QuillProvider is a parent of the Dashboard component.

Don’t have a dashboard name yet? Learn how to create a dashboard in the Quill BI Platform to get started.

Examples

Ant Design
Material Design

Edit [Ant Design] Quill React Components

import { Dashboard } from "@quillsql/react";
import { AntDateRangePickerComponent } from "./ui/ant/DateRangePickerComponent";
import { AntTableComponent } from "./ui/ant/TableComponent";
import { AntSelectComponent } from "./ui/ant/SelectComponent";
import { AntChartComponent } from "./ui/ant/ChartComponent";
import { AntMetricComponent } from "./ui/ant/MetricComponent";

export function AntDashboard() {
  return (
    <Dashboard
      name="Transactions"
      containerStyle={dashboardStyles}
      DateRangePickerComponent={AntDateRangePickerComponent}
      SelectComponent={AntSelectComponent}
      TableComponent={AntTableComponent}
      MetricComponent={AntMetricComponent}
      ChartComponent={AntChartComponent}
      FilterContainerComponent={AntFilterContainerComponent}
    />
  );
}

Edit [Material Design] Quill React Components

import { Dashboard } from "@quillsql/react";
import { MaterialDateRangePickerComponent } from "./ui/material/DateRangePickerComponent";
import { MaterialTableComponent } from "./ui/material/TableComponent";
import { MaterialSelectComponent } from "./ui/material/SelectComponent";
import { MaterialChartComponent } from "./ui/material/ChartComponent";
import { MaterialMetricComponent } from "./ui/material/MetricComponent";
import { MaterialFilterContainerComponent } from "./ui/material/Layout";

export function MaterialDashboard() {
  return (
    <Dashboard
      name="Transactions"
      containerStyle={dashboardStyles}
      DateRangePickerComponent={MaterialDateRangePickerComponent}
      SelectComponent={MaterialSelectComponent}
      TableComponent={MaterialTableComponent}
      MetricComponent={MaterialMetricComponent}
      ChartComponent={MaterialChartComponent}
      FilterContainerComponent={MaterialFilterContainerComponent}
    />
  );
}

Props

string

required

The name of the dashboard you created in the Quill BI Platform.

(props: QuillReportProps) => JSX.Element

A component that wraps a report for ‘metric’ chart types.

Show props

object

Show properties

QuillReport

required

The current report.

See the API Reference for a QuillReport here.

(report: QuillReport) => void

A callback that should be fired when the user clicks on this report.

boolean

Whether this report is loading.

string

An error message that resulted from the loading of this report, if any.

(props: QuillReportProps) => JSX.Element

A component that wraps a report for non-metric, non-table chart types.

Show props

object

Show properties

QuillReport

required

The current report.

See the API Reference for a QuillReport here.

(report: QuillReport) => void

A callback that should be fired when the user clicks on this report.

boolean

Whether this report is loading.

string

An error message that resulted from the loading of this report, if any.

ReactNode

The child of a chart component is a chart graph by default.You can override this behavior by not passing children in your implemented version and instead rendering your own Chart.

(props: QuillReportProps) => JSX.Element

A component that wraps a report for ‘table’ chart types.

Show props

object

Show properties

QuillReport

required

The current report.

See the API Reference for a QuillReport here.

(report: QuillReport) => void

A callback that should be fired when the user clicks on this report.

boolean

Whether this report is loading.

string

An error message that resulted from the loading of this report, if any.

(props: SelectComponentProps) => JSX.Element

A select component.

Show props

Example

export function SelectComponent({ value, label, width, onChange, options }) {
	return (
		<label>
			{label}
			<select value={value} onChange={onChange} style={{ width }}>
				{options.map(({ value, label }) => <option value={value}>{label}</option>)}
			</select>
		</label>
	);
}

object

Hide properties

string

required

The value of the select element.

number

required

The width of the select element in pixels.

string

The label above the select element.

(event: ChangeEvent<HTMLSelectElement>) => void

required

An event callback that is fired when the select value changes.

{ value: string; label: string; }[]

required

An array of value, label pairs which represent the select options.

(props: DateRangePickerComponentProps) => JSX.Element

A date range picker component.

Show props

object

Show properties

string

required

The date preset.

string

The label above the date range picker.

{ startDate: Date; endDate: Date }

required

The current date range.

{ label: string; value: string }[]

required

A set of options to select presets from.

({ startDate, endDate }: { startDate: Date; endDate: Date; }) => void

required

A callback that is fired when the selected date range changes.

(event: ChangeEvent<HTMLSelectElement>) => void

required

An event callback that is fired when the preset value changes.

(props: DashboardSectionComponentProps) => JSX.Element

A component that wraps each dashboard section.Each dashboard is grouped into three sections: metrics, charts, and tables (in that order). Some sections may be empty, in which case they are omitted.

Show props

object

Show properties

'metrics' | 'charts' | 'tables'

required

The name of the section.

ReactNode

required

The children of the dashboard section.

(props: DashboardSectionContainerComponentProps) => JSX.Element

A component that wraps all dashboard sections.

Show props

object

Show properties

ReactNode

required

The children of the dashboard section.

(props: FilterContainerComponentProps) => JSX.Element

A component that wraps the row of dashboard filters.

Show props

object

Show properties

ReactNode

required

The children of the filter container.

() => JSX.Element

A fallback component displayed when an active dashboard has no reports.

(report: QuillReport) => void

Callback function that fires when a report is clicked. A common use case is navigating to a new page based on the report’s id. A dashboard is composed of a list of reports that could be metrics, charts, or tables.

See the API Reference for a QuillReport here.

(isLoading: boolean) => void

A callback that is fired when the loading status of the dashboard changes.

boolean

default:false

Whether to hide dashboard filters.

boolean

default:false

Whether the date range filters on the dashboard are hidden.

boolean

default:false

Whether to hide the xAxis for all charts on this dashboard.

boolean

default:false

Whether to hide the yAxis for all charts on this dashboard.

boolean

default:false

Whether to hide the cartesian grid for all charts on this dashboard.

'solid' | 'dashed'

default:"solid"

The line style for comparison ranges on all line charts on this dashboard.

string

Applies the following classes to the ReportBuilder.This container is the parent of all the filtering buttons as well as any dashboard sections. This can be useful for TailwindCSS-style classname strings.

React.CSSProperties

The CSS styles that wrap the dashboard container.This container is the parent of all the filtering buttons as well as any dashboard sections.

React.CSSProperties

The styles for the chart container.

QuillReport

The full QuillReport schema is documented on the Types reference page.

Getting Started

Use cases

Components

Hooks

Functions

Reference

Examples

Props

QuillReport

​Examples

​Props

​QuillReport

Examples

Props

QuillReport