Dashboard

App.tsx

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

function App() {
  return (
    <QuillProvider tenants={[2]} publicKey="6579031b3e41c378aa8180ec">
      <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

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}
    />
  );
}

Props

name

string

required

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

MetricComponent

(props: QuillReportProps) => JSX.Element

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

Show props

QuillReportProps

object

Show properties

report

QuillReport

required

The current report.

See the API Reference for a QuillReport here.

onClick

(report: QuillReport) => void

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

isLoading

boolean

Whether this report is loading.

error

string

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

ChartComponent

(props: QuillReportProps) => JSX.Element

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

Show props

QuillReportProps

object

Show properties

report

QuillReport

required

The current report.

See the API Reference for a QuillReport here.

onClick

(report: QuillReport) => void

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

isLoading

boolean

Whether this report is loading.

error

string

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

children

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.

TableComponent

(props: QuillReportProps) => JSX.Element

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

Show props

QuillReportProps

object

Show properties

report

QuillReport

required

The current report.

See the API Reference for a QuillReport here.

onClick

(report: QuillReport) => void

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

isLoading

boolean

Whether this report is loading.

error

string

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

SelectComponent

(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>
	);
}

SelectComponentProps

object

Hide properties

value

string

required

The value of the select element.

width

number

required

The width of the select element in pixels.

label

string

The label above the select element.

onChange

(event: ChangeEvent<HTMLSelectElement>) => void

required

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

options

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

required

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

DateRangePickerComponent

(props: DateRangePickerComponentProps) => JSX.Element

A date range picker component.

Show props

DateRangePickerComponentProps

object

Show properties

preset

string

required

The date preset.

label

string

The label above the date range picker.

dateRange

{ startDate: Date; endDate: Date }

required

The current date range.

presetOptions

{ label: string; value: string }[]

required

A set of options to select presets from.

onChangeDateRange

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

required

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

onChangePreset

(event: ChangeEvent<HTMLSelectElement>) => void

required

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

DashboardSectionComponent

(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

DashboardSectionComponentProps

object

Show properties

section

'metrics' | 'charts' | 'tables'

required

The name of the section.

children

ReactNode

required

The children of the dashboard section.

DashboardSectionContainerComponent

(props: DashboardSectionContainerComponentProps) => JSX.Element

A component that wraps all dashboard sections.

Show props

DashboardSectionContainerComponentProps

object

Show properties

children

ReactNode

required

The children of the dashboard section.

FilterContainerComponent

(props: FilterContainerComponentProps) => JSX.Element

A component that wraps the row of dashboard filters.

Show props

FilterContainerComponentProps

object

Show properties

children

ReactNode

required

The children of the filter container.

EmptyDashboardComponent

() => JSX.Element

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

onClickReport

(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.

onChangeLoading

(isLoading: boolean) => void

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

hideFilters

boolean

default:false

Whether to hide dashboard filters.

hideDateRangeFilter

boolean

default:false

Whether the date range filters on the dashboard are hidden.

hideXAxis

boolean

default:false

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

hideYAxis

boolean

default:false

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

hideCartesianGrid

boolean

default:false

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

comparisonLineStyle

'solid' | 'dashed'

default:"solid"

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

className

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.

containerStyle

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.

chartContainerStyle

React.CSSProperties

The styles for the chart container.

QuillReport

string

required

The report’s unique id.

name

string

required

The name of the report.

dashboardName

string

required

The name of the dashboard this report belongs to.

rows

{ [key: string]: any }[]

The rows of data returned from this report’s query.

columns

any[]

The columns data returned from this report’s query.

chartType

The type of this chart.

dateField

{ table: string; field: string } | null

The table and field this chart uses for date filtering.

pivot

Pivot | null

The pivot used in this query, if any.

Show Pivot

title

string

required

The pivot title.

aggregationType

'sum' | 'average' | 'count' | 'min' | 'max'

required

The aggregation type for the values in this pivot.

rowField

string

required

The row field.

rowFieldType

string

required

The type of the row field.

columnField

string

The column field, if any.

columnFieldType

string

The type of the column field, if any.

valueField

string

required

The value field, if any.

valueFieldType

string

required

The type of the value field, if any.

primaryAggregation

string

The formatted primary range aggregation value, if any.

comparisonAggregation

string

The formatted comparison range aggregation value, if any.

aggregationPercentChange

number

The percent change in the aggragations, if any.

xAxisLabel

string

required

The label of the xAxis.

xAxisField

string

required

The field to use for the report’s xAxis.

xAxisFormat

string

required

The format for the report’s xAxis.

yAxisFields

{ field: string; label: string; format: string; }[]

required

A list of metadata bout the yAxes of this report.

order

number

required

The relative ordering of this report in relation to its siblings. Ordering starts at 1 and counts up.

Reports in the same section are first grouped by chartType and then each group is sorted by order.

Currently, the first group is metric and the last group is table with the rest of the reports in between.

compareRows

{ [key: string]: any }[]

The rows of data returned from this report’s query over the comparison date range as opposed to the primary date range.

filtersApplied

{ [key: string]: any }

A map of filters that have been applied to this query.

Getting Started

Use cases

Components

Hooks

Functions

Examples

Props

QuillReport

Getting Started

Use cases

Components

Hooks

Functions

​Examples

​Props

​QuillReport

Examples

Props

QuillReport