Using Dashboards
Overview
Section titled “Overview”Dashboards let you build interactive views over data from any project or workspace you have access to. A single dashboard can combine tables from multiple projects, mix visualizations with raw exploration, and serve both standing reports and ad-hoc analysis. Dashboards scale from small reference tables to billion-row datasets without configuration changes.
Dashboard Accounts
Section titled “Dashboard Accounts”Your dashboard account is set up for you the first time you open a dashboard from PlaidCloud, so there is nothing to create by hand. What you can see follows from your PlaidCloud workspace membership and security groups.
Which Dashboards You See
Section titled “Which Dashboards You See”The Dashboards page in PlaidCloud shows the published dashboards belonging to the projects you can access. That is the usual case and covers nearly every dashboard.
A dashboard’s owners and workspace admins can limit it to particular security groups. A restricted dashboard is listed only for members of those groups, along with its owners and workspace admins, who see every dashboard. A dashboard with no restriction is listed to everyone with access to its projects, so restricting one dashboard never changes who sees the others.
Two things are worth knowing if a dashboard is missing from your list:
- A restricted dashboard is hidden from the list, not just from opening it. If you can access the dashboard’s project and open its link, you’ll see a Request access page; otherwise ask the owner rather than assuming it was deleted.
- Your dashboard account has to exist for a restricted dashboard to reach you. It is created for you the first time you open a dashboard from PlaidCloud, and your groups are applied then.
The Dashboards Workspace
Section titled “The Dashboards Workspace”Dashboards opens with a rail on the left and the page you pick beside it. Members who can’t open a page don’t see its item. Pages have a title at the top, often with a short subtitle, and their actions in the header beside it.
| Rail item | What it shows |
|---|---|
| Overview | Tiles for Dashboards, Visible to everyone, Restricted, You manage, Apps ready and Apps failed. Select a tile to open its list, already filtered. Recently opened and favorites lists what you opened or starred lately on this device. Needs attention lists failed apps and access requests waiting on you, with Review, which opens the dashboards you manage. Most opened in the last 30 days shows for members with usage access. |
| Dashboards | The dashboards you can see. Choose All, You manage or Favorites above the list. Columns include Audience, Owner and Opens (30 days). Import dashboard archive… and Set audience… are in the toolbar. |
| Apps | Panel, Dash and browser apps built on your projects, with Kind, Status and Project. Status updates live. The New app menu has a Panel app heading over Studio, Browser only and Server based, then Dash app and From gallery…. The Type column uses the same names. |
| Notebooks | Your JupyterLite deployments. |
| Access review | Under Admin, for workspace admins. See Control Who Can See a Dashboard. |
| Open navigator ↗ | At the bottom of the rail. The arrow marks it as the one item that opens its own window: the dashboard service, in a new tab. |
Counts beside Dashboards and Apps show how many you can see.
Opening a Dashboard from the Dashboards Page
Section titled “Opening a Dashboard from the Dashboards Page”On the Dashboards page, click the Open icon at the start of a dashboard’s row to open it in a new tab. Double-clicking the row opens it too.
The Row Actions Menu
Section titled “The Row Actions Menu”Every list in PlaidCloud that has per-row actions, including the Dashboards page, has a row actions menu. Open it from the ⋯ button at the start of a row, by right-clicking the row, or from the Actions menu in the toolbar. The menu always has the same layout:
- Open, Details and Edit, in that order.
- The list’s own actions, such as Access, Groups, Reset password or Clone.
- Delete or Remove, last.
A separator divides the groups. An action that doesn’t apply to the selected row stays in its place but is greyed out, so items never move from one row to the next.
Two items show a shortcut. The item the Enter key runs, which opens the row, shows Enter. The item the Delete key runs shows Del (Backspace on a Mac).
A list whose rows have only one action shows that action’s icon at the start of the row instead of ⋯. Click the icon to run the action; a destructive one still asks you to confirm. Rows that can’t take the action show no icon.
Standard, Roomy and Cards Views
Section titled “Standard, Roomy and Cards Views”Lists in PlaidCloud’s workspace apps, such as Dashboards, Apps, the ERP Register and Identity Members, have a View menu in the toolbar with three choices:
- Standard rows: the compact list, one line per row.
- Roomy rows: the same list with more space around each row.
- Cards: one card per row. Dashboards cards show a thumbnail of the dashboard, and ERP register cards show the amount, date, entity, connection and document.
Cards behave like the list: select a card, extend the selection with Shift, sort and choose columns from the View menu, right-click for Copy and the row’s actions, and, in lists that have favorites such as Dashboards and Apps, click the star to favorite it.
Ask Why a Number Is What It Is
Section titled “Ask Why a Number Is What It Is”On a dashboard, right-click a point on a chart, or a cell in a table chart, and choose Why this number. PlaidCloud opens in a new tab, and Weave says which step writes the figure, what it comes from, and how it changed since the run before. See Why a Number Is What It Is.
Opening a Dashboard Link After Your Session Expires
Section titled “Opening a Dashboard Link After Your Session Expires”If your session has expired when you open a link to a dashboard, you are asked to sign in and then taken to that dashboard, instead of to the dashboards home page.
Display Controls
Section titled “Display Controls”A display control is a filter bar control that lets anyone viewing a dashboard change what a chart is grouped by — swapping “Region” for “Product Line,” for example — without opening the chart to edit it. A dashboard editor adds and configures display controls from the filter bar’s settings menu: choose Add or edit filters and controls, then Add display control from the New menu.
Limiting Which Columns Appear
Section titled “Limiting Which Columns Appear”By default, a display control’s dropdown lists every column on the underlying dataset marked Is filterable. On a wide dataset that can mean hundreds of columns to scroll through to find the one you want.
Every display control now has its own Available columns field in its configuration panel. Set it to a specific list of columns and the control’s dropdown offers only those columns. Leave it empty and the control behaves exactly as before, offering every filterable column — no dashboard needs any changes to keep working as it always has.
To limit a display control:
- Open Add or edit filters and controls from the filter bar’s settings menu.
- Select the display control you want to limit, or add a new one.
- In Available columns, search for and select the columns you want viewers to see.
- Save.
How This Interacts with “Is Filterable”
Section titled “How This Interacts with “Is Filterable””Available columns only ever offers columns already marked Is filterable on the dataset — it narrows that list further, it doesn’t reach around it. Unchecking Is filterable on a column still removes it everywhere: from Available columns, from adhoc filters, from native filters, and from the Simple Metric picker on every chart built against that dataset.
That wide reach is exactly why Available columns exists. Before it, the only way to shorten a display control’s dropdown was to uncheck Is filterable on the columns you didn’t want offered there — which also hid those same columns from every chart’s metric picker on that dataset. Leave Is filterable checked on every column a chart might need as a metric or an adhoc filter, and use each display control’s own Available columns to decide what that control shows in its Group By dropdown.
Where It’s Saved
Section titled “Where It’s Saved”Available columns is saved per display control, along with the rest of that control’s settings. It travels with the dashboard through export and import, and it has no effect on any other control — on the same dashboard or any other dashboard built from the same dataset.
Editing a Table
Section titled “Editing a Table”The message you receive after creating a new table also directs you to edit the table configuration. While there are more advanced features to edit the configuration, we will start with a limited and more simple portion. To edit table configuration:
- Click on the edit icon of the desired table
- Click the “List Columns” tab
- Arrange the columns as desired
- Click “Save”
This allows you to define the way you want to use specific columns of your table when exploring your data.
- Groupable: If you want users to group metrics by a specific field
- Filterable: If you need to filter on a specific field
- Count Distinct: If you want to get the distinct count of this field
- Sum: If this is a metric you want to sum
- Min: If this is a metric you want to gather basic summary statistics for
- Max: If this is a metric you want to gather basic summary statistics for
- Is temporal: This should be checked for any date or time fields
Exploring Your Data
Section titled “Exploring Your Data”To start exploring your data, simply click on the desired table. By default, you’ll be presented with a Table View.
Getting a Data Count
Section titled “Getting a Data Count”To get a the count of all your records in the table:
-
Change the filter to “Since”
-
Enter the desired since filter
- You can use simple phrases such as “3 years ago”
-
Enter the desired until filter
- The upper limit for time defaults is “now”
-
Select the “Group By” header
-
Type “Count” into the metrics section
-
Select “COUNT(*)”
-
Click the “Query” button
You should then see your results in the table.
If you want to find the count of a specific field or restriction:
- Type in the desired restriction(s) in the “Group By” field
- Run the query
Restricting Result Number
Section titled “Restricting Result Number”If you only need a certain number of results, such as the top 10:
- Select “Options”
- Type in the desired max result count in the “Row Limit” section
- Click “Query”
Additional Visualization Tools
Section titled “Additional Visualization Tools”To expand abbreviated values to their full length:
- Select “Edit Table Config”
- Click “List Sql Metric”
- Click “Edit Metric”
- Click “D3Format”
To edit the unit of measurement:
- Select “Edit Table Config”
- Click “List Sql Metric”
- Click “Edit Metric”
- Click “SQL Expression”
To change the chart type:
- Scroll to “Chart Options”
- Fill in the required fields
- Click “Query”
From here you are able to set axis labels, margins, ticks, etc.