Fig. 2. Sales overview, by region.
For the owner
Sales overview
Revenue, orders and the average order for the month. Click West and the other charts follow.
Field entry 02 · Dashboards90+ chart and visual types
Dashboards your team explores.
Charts, tables and filters on the same canvas as your app, reading your data each time someone opens them.
1,000 free tokens to try · Unlimited app users · Our cloud or your own servers
We open in waves. Join early access and we'll email you when your workspace is ready.
Sales overview
fernleaf.app/sales?region=West
Dev Preview
Sales overview
This monthRegion: West
Revenue this month$482,310$150,252All regionsWest only
Orders18,9425,901this month
Avg order$25.46per order
Conversion3.8%4.1%store visits
Bar chart
Revenue by regionRevenue by product Click a bar to filterAll›West›product
Show as a table
WestEastSouthCentralNorth
- Trail Runner shoes$38,442
- Basecamp tent 2P$31,410
- Ridge rain jacket$26,838
- Summit pack 32L$19,966
- Canyon water bottle$7,632
- Alpine wool socks$5,706
Orders by week all regionsWest
Top products this month
Trail Runner shoes$1291,204 sold
Basecamp tent 2P$349318 sold
Ridge rain jacket$189542 sold
Data behind this chart Region: West 6 rows · 2 columns Export CSV
| abcproduct | $revenue |
|---|---|
| Trail Runner shoes | $38,442 |
| Basecamp tent 2P | $31,410 |
| Ridge rain jacket | $26,838 |
| Summit pack 32L | $19,966 |
| Canyon water bottle | $7,632 |
| Alpine wool socks | $5,706 |
Revenue_by_product.csv downloaded
01What people build with itThree Fernleaf pages
One shop, three views of it.
Every page below reads the same Fernleaf tables. Each team sees the part of the business it runs.
Fig. 3. Units in stock, product by region.
For operations
Stock watch
A matrix of stock by product and region, and a button next to it that runs the Reorder stock workflow.
Fig. 4. A page in the partner portal.
For partners
Wholesale portal
A page in a customer portal where each partner shop signs in and sees its own orders by month.
02How it worksSeven entries · Fig. 5 to 11
From the first chart to the last row.
Pick a visual, click to filter, drill in, and see the rows behind it. All on a page of your app.
90+chart and visual types
Entry 01
A visual for every question
From a single KPI card to a matrix. Pick a visual, choose a database and drop fields onto it. Slicers let people narrow the page down themselves.
- KPI cards, cards, bar, line, area, combo and scatter charts
- Tables and matrix
- Slicers: a ticked list, buttons, timeline, hierarchy and play axis
Showing 14 of 90+ visual types
- KPI
- Card
- Bar chart
- Line chart
- Area chart
- Combo chart
- Scatter chart
- Table
- Matrix
- Slicer
- Button slicer
- Timeline slicer
- Hierarchy slicer
- Play axis
- 90+visual types in all, on Team and Enterprise
Fig. 5. A slice of the visual gallery. Pick a group to filter it.
02click to filter, share the view
Entry 02
Click a bar. The page follows.
Click a bar and the other charts and tables on the page narrow to it. Hold Ctrl or Cmd to add more values. The filter lives in the page address, so the link you send opens the same view.
- One click filters the other charts and tables
- Filters sit in the page address
- Share the view as a link
- Clear a filter with one click
fernleaf.app/sales
Filters in the addressnone yet
Revenue this month$482,31018,942 orders
Click a bar. The page and the address follow.
Fig. 6. Try it: pick a region and watch the address carry it.
03one search box, every chart
Entry 03
One search box filters every chart.
Type a word and every chart on the page narrows to it, even when the word is misspelt.
- Uses each table's own search, so typos are forgiven when that table has Typos on
- Built on the same search engine as your site search
- Visitors only search the tables that box searches
- A chart that cannot be searched is left out, never broken
This box searchesorders
Revenue this month
$70,230 258 orders of $482,310 in all ordersLatest orders
orders| order | customer | product | amount |
|---|
Site visits
48,210 this month site_visitsNot searchedThis chart reads site_visits, a table the box does not search.
Fig. 7. Type a product, like ridge or trail. Every searchable chart follows; Site visits stays as it is.
04drill down and drill through
Entry 04
Drill down. Drill through.
Go from regions to products, then open a detail page for one product. The values you clicked travel to that page in its address.
- Drill down a level inside the same chart
- A breadcrumb shows where you are
- Drill through to another page with the point's values in its address
Fig. 8. Region, then West, then products, then one product's own page.
05see the data, export CSV
Entry 05
See the data behind any chart
Every number on a chart came from rows. Open them as a table right where the chart is, check them, and take them with you as a CSV file.
- Show any chart as a table
- The table holds the same rows the chart draws
- Export CSV in one click
Revenue by region
| region | orders | revenue |
|---|---|---|
| West | 5,901 | $150,252 |
| East | 4,485 | $114,192 |
| South | 3,658 | $93,158 |
| Central | 2,773 | $70,618 |
| North | 2,125 | $54,090 |
5 rows · 3 columns
Fig. 9. Switch to the rows, then export them. The file is real.
06big tables
Entry 06
Big tables load one page at a time
A table of every order does not load every order. A table built from your database fields asks the server for one page of rows at a time, and you move through the rest page by page.
- Paging, sorting and search happen on the server
- Choose 10, 25, 50 or 100 rows per page
- Only the page you look at travels to the browser
orders18,942 rowssorted by order_id
| order_id | product | region | total |
|---|---|---|---|
| 10482 | Basecamp tent 2P | West | $612.50 |
| 10481 | Trail Runner shoes | East | $129.00 |
| 10480 | Ridge rain jacket | South | $189.00 |
| 10479 | Basecamp tent 2P | West | $349.00 |
| 10478 | Alpine wool socks | Central | $47.00 |
| 10477 | Canyon water bottle | East | $24.00 |
| 10476 | Summit pack 32L | North | $149.00 |
| 10475 | Trail Runner shoes | South | $258.00 |
| 10474 | Alpine wool socks | West | $18.00 |
| 10473 | Ridge rain jacket | Central | $189.00 |
Page 1 of 1,895 · 10 rows per page
Fig. 10. 18,942 orders, one small page at a time. Use the arrows.
07dashboards are pages
Entry 07
A dashboard is a page of your app
Charts sit on the same canvas as forms, buttons and text. So a dashboard can do things, not only show them: a button next to a chart can run a workflow.
- Mix charts with forms, buttons and workflows on one canvas
- Publish it with the rest of your app
- The same sign-in and access rules as every other page
Fig. 11. One page: a chart, a form, and a button that runs a workflow.
03Works withBuilders and data
Better with the rest of the kit.
Dashboards read the same tables as every other builder. Use them alone, or next to the parts you already have.
BuilderWeb appsDashboards live on app pages, next to forms, buttons and text. BuilderWorkflowsA button on a dashboard can run a workflow, like Reorder stock. PlatformData & connectorsCharts read your built-in tables or the databases you connect.
Read data from
- Built-in database
- PostgreSQL
- MySQL
- MariaDB
- SQL Server
- Oracle
- MongoDB
- Firebase
- REST APIs
- and more
Plan notes
Starter
15 common chart types
Team and Enterprise
Compare plans 90+ chart and visual types, all of them
04Questions
Fair questions.
From the tables in your workspace: the built-in database or the data you connect. A chart reads its data each time someone opens the page.
Yes. Filters live in the page address. Send the link and the person who opens it sees the same filters.
Starter has 15 common chart types. Team and Enterprise have all 90+ chart and visual types.
A dashboard is a page of your app. People who use your published apps do not need seats, and they are unlimited on every plan. Everyone in your workspace uses a seat.
Yes. Show any chart as a table and export it as CSV.
Where to begin
Build your first dashboard.
Connect a table, drop a chart on a page, click a bar. Add the rest when you need it.
We open in waves. Join early access and we'll email you when your workspace is ready.