Dashboard Training

Basic Usage

Connect to Server

Once you have Row64 Server and Studio installed, open Row64 Studio and connect to the Server in the Connect window:

Browse Example Dashboards

Next, click on the “Browse” button to look at example dashboards

Dashboard Hotkeys

F4 - Interactive slider mode
- NOTE: We don’t recommend interactive sliders for dashboards being used by over 1000 people since it heavily interacts with the server
Alt P - Change Selection for Points, Lines, and Shapes
Space - Hold down space to select Points, Lines & Shapes
Alt ~ - Remove all filters running on the dashboard
Alt L - Adjust Geo Layers
F8 - Frame Rate in bottom left
F2 - Debug Mode. Click on charts to test their inputs. Hit G to see the evaluation graph.

Zoom & Pan

Zoom & Pan In Geography & Diagrams

Zoom: Mouse wheel
Pan: Left mouse drag
R (Reset View) or F (Frame All) to set the zoom back to default

Zoom & Pan in Charts

Zoom: <Ctrl> Mouse wheel
Pan: <Ctrl> Right mouse drag
R (Reset View) or F (Frame All) to set the zoom back to default

Full Screen Or Resize A Pane

Double Click on a pane to make it full screen
To close Full Screen, either:
- Hit the X button on the top right
- Hit the Escape Key
To full screen a dataframe, double click the top bar
You can also drag the bar between panes to resize

Clicking Points

To pull up the details on geo-coordinate, either:
- Double click the point
- <Ctrl> click the point
Please note, to do this you need to be in Coord selection mode. Click Alt-P to switch the selection mode.
Click the images on the pop up to inspect, and the back button on the photo viewer to go back

Selection Basics

You can select by either:

Clicking directly on shape, line, or coord
Drag a rectangle
Drag a circle

Change your selection mode to by clicking Alt-P, or selecting the arrow box in the top left, and in the combo picking: Coord, Shape or Line
Hold down the space key and drag to make a selection

Selection Lasso

Hit Alt-P or top left arrow button and set the Shape to Lasso

Hold down the space bar and freeform drag to sketch out a shape.
Hold down the space bar and lightly click points to select from straight lines.
Selection tools apply to Picking: Coords, Shapes, and Lines

Select Coords From Shape

Hit Alt-P or top left arrow button and set the Shape to Lasso

Hold down the space bar and freeform drag to sketch out a shape.
Hold down the space bar and lightly click points to select from straight lines.
Selection tools apply to Picking: Coords, Shapes, and Lines

Studio Examples

This document includes links for the projects used to create many example dashboards.

Each link contains a .r64 which you can just drag into the Studio application and study the details of how the dashboard was made.

We also include:

Source .csv files
GeoSpatial files (geoJson or Shape)

General Dashboards

Get Started

Video:
https://www.youtube.com/watch?v=W7NVET-KJ-8

Download:
New_Or_Used.zip

This is a simple dashboard to study & get started with
Includes a .pdf diagram on the how cross-filtering is working

R_Squared

Video:
https://www.youtube.com/watch?v=W7NVET-KJ-8

Download:
R_Squared.zip

A basic dashboard with two charts, some pane formulas, and dataframe records
Includes a .pdf diagram on the how cross-filtering is working

Video:
https://www.youtube.com/watch?v=gzJLtA9Rqtw

Download:
Widget.zip

An advanced dashboard with 2 dataframes of input and many widgets
Includes a .pdf diagram on the how cross-filtering is working

Bubble

Video:
https://www.youtube.com/watch?v=EKRIgaSoZCA

Download:
Bubble.zip

A good example of interactive slider use
Shows using multiple cross-filters connecting to a bubble chart

Date Group

Video:
https://www.youtube.com/watch?v=wZjRrKukALQ

Download:
Date_Group.zip

A simple example of working with dates and multiple date columns

Dense Data Sales

Video:
https://www.youtube.com/watch?v=NIUxFxbECbw

Download:
Robotic_Sales.zip

Has 1 million records, so a good speed and scale test
Can test text filtering, for example Swan in the company name

Seasonal

Video:
https://www.youtube.com/watch?v=_zA0e8lxjPc

Download:
Seasonal.zip

Example of advanced cross-filtering, formula columns, conditional formatting
Pulls in transactions and uses formulas for seasonal comparison, blended by slider

Unstructured Text

Paragraph Text

Video:
https://www.youtube.com/watch?v=7UmB8biaFeg

Download:
Amazon.zip

Shows filtering large volumes of paragraph text
Double click (in the browser) on the text column for a paragraph text window to pop up

Sentiment & Word Cloud

Video:
https://www.youtube.com/watch?v=ZyE78gNWUm0

Download:
Sentiment.zip

Shows using word clouds as a sentiment interface and analysis tool
Interactive sliders for filtering sentiment, an example of advanced cross-filtering

Spreadsheet Dashboards

Expenses

Video:
https://www.youtube.com/watch?v=0V3vhr1iqls

Download:
Expenses.zip

A simple example of using spreadsheets for high level analysis within a dashboard

Profit

Video:
https://www.youtube.com/watch?v=J5sXndEZ9pI

Download:
Profit.zip

How to model company profit using a high-level spreadsheet (with over 1M records)
Has 2 dataframes as input (Sales & Expenses) that are linked together
- Clicking on the Quarter will cross-filter both Dataframes

Geospatial Dashboards

Census

Video:
https://www.youtube.com/watch?v=q7gIJd6qCYs

Download:
Census.zip

Simple slider filtering of Census Data
Good example of using layers to build a polished interactive map

Cell Towers

Video:
https://www.youtube.com/watch?v=-H8UJBPnOT4

Download:
Cell_Towers.zip

Speed and scale test of 2 million cell towers
Cross filtering of large dataset while viewed on a map

Weather

Download:
Weather.zip

Animated choropleth of changing weather patterns over time
In the browser, move the mouse near the bottom of the map and you’ll see a play bar pop up

Garden City

Download:
Garden_City.zip

Shows micro-mapping a high resolution city to the sidewalk, median, and fire hydrant level
Detailed example GEO with Images, .pdf files, and 3D Files

Urban Analytics

Download:
Urban_Analytics.zip

Shows city master planning
Detailed example GEO with CAD files (.dwg) and video (.mp4)

Markers

Download:
Marker.zip

Link location data to custom markers
Shows Dataframe filtering dynamically adjusting marker types

Power

Download:
Power.zip

Shows connecting attributes and data to line networks
Visual overlay & cross-filter of multiple systems data based off of line networks and geo-locations