- Connect to your database(s) with a data connector
- Visualize trends over time with a plot
- Show detailed breakdowns with tables
The tile creation flow
Creating a tile in Julius follows the same basic flow every time:- Open the tile creator
- Connect a data connector
- Build your query (manually or with Julius)
- Run the query and review the results
- Edit the visualization and tile details
1. Open the tile creator
From the Tiles tab
Go to the Tiles tab in the sidebar, then click New Tile to open the tile creator.From a Dashboard
Open the Dashboard where you want to add a tile, click Add Tile in the upper right corner, then choose Create a New Tile (or pick an existing one to reuse).2. Connect a data connector
1
Select a data source
Choose the Data Source for your tile — this is the Data Connector you want to use.
2
Choose what to query
Pick the table, view, or schema you want to query (depending on the connector).
3. Build your query
1
Choose how to build your query
You can either write or paste the query manually in the query editor to control exactly what data is returned, or ask Julius to generate a query using plain English.
2
Refine the query
Add filters (for example, date range, campaign, or region), choose group-bys and aggregations, and adjust limits or ordering until the query matches what you want to see.
4. Run the query
1
Run and review
Click Run to execute your query, then review the preview table to make sure the results match what you expect. Adjust the query and re-run as needed.
5. Edit the visualization
With a successful query in place, you can use Edit visualization to design the tile:1
Choose a visualization type
Pick a visualization type (for example, bar chart, line chart, area chart, or cohort chart).
2
Map your fields
Map fields to axes and groupings (for example, x-axis, y-axis, color, or group by) so the visualization shows the right breakdown.
3
Name and save the tile
Set the tile name, then save it. You can now add the tile to your Dashboards and reuse it elsewhere.
6. Add tiles to a dashboard
To add your tiles to a dashboard:1
Open your dashboard
Go to the Dashboard where you want to add your new tile.
2
Click 'Add tiles'
In the upper right corner of the dashboard page, click the Add tiles button.
3
Pick your tile(s)
In the menu or dialog, select one or more tiles you’ve created from the list. You can search by tile name if you have many.
4
Add to dashboard
Confirm your selection. The tile(s) will be added to your dashboard view.
- You can easily organize tiles within a dashboard by clicking and dragging the 6 dots (⋮⋮) in the upper left corner of each tile to move it wherever you’d like within the dashboard layout.
