Lesson 6 of 8 · Lab

Publish a dashboard and hand over the rerun

Publishing gives people a link to a saved version of a dashboard, which they can view but not edit. It reads its Cloud files when opened, but only the files that version points at, so a new month needs Update publication.

This lesson runs in Strata, Oplema's browser app for data prep, rather than in this page, so you need a desktop browser. It uses the free account and project from the last lesson.

Marit, who owns fictional Kramerica Bikes, should be able to open a link and see each shop's days. Noor should know exactly what to do with October's files. The dashboard shows Marit's chosen line, 90%, through the flow's short_90, so moving the line means editing the flow.

Noor reruns the flow on next month's files. Does Marit's link change by itself?

No. The link shows the version you published. After a rerun, Noor updates the publication.

Build, publish and rehearse the rerun

  1. Open Strata, open your project from Move a flow's files to Cloud and select the Vista tab at the top (Vista is Oplema's browser app for dashboards).
  2. In the palette, select Lines & areas and drag Line onto the page. It picks kramerica_daily, groups hire_on by day and sums bikes_out. The 7-day average from Fill missing dates stays out, to keep this flow small.
  3. From Metrics, drag Number onto the page. Under Value, choose short_90. It reads 13: the days a shop had 90% of its bikes out.
  4. Drag a second Number onto the page and choose bikes_out under Value: 1,717.
  5. From Controls, drag Filter onto the page and select shop under Available filter fields. Applies to reads This page.
  6. Choose Old Town in the filter: the first Number reads 9. Harbour reads 4 and Station Road 0. Clear the choice to show every shop again.
  7. From Content, drag Text onto the page, select Edit text, select all (Ctrl+A or Cmd+A) and type September 1–30, 2026. Short: 90% of a shop's bikes out. Customers turned away aren't recorded.
  8. Select Publish in the toolbar, then Publish dashboard. You should see "Dashboard published." Select Open dashboard to see what Marit will see.
  9. For readers without an account, select Anyone with the publication link can view, then select Copy link.

Now rehearse next month. Harbour's export to September 27, kramerica-harbour-to-sep-27.csv, stands in for a new month's file: a different file, with fewer days. It's the export that broke your flow in Fix a data flow when next week's file changes. This one copes: it never reads the price column, and its Filter already keeps returned.

Point Harbour's Input at that file, rerun the flow and update the publication. Check: Formula has 83 rows and Marit's link reads 1,666 bikes out. Then put the month's file back and update the publication again.

If you're stuck
  1. In Cloud, upload kramerica-harbour-to-sep-27.csv to Kramerica.
  2. In Strata, select Harbour's Input, select Browse, choose that file and select Run local: Formula has 83 rows. Marit's link still shows 1,717.
  3. In Vista, select Publish, then Update publication. Reload Marit's link: the second Number reads 1,666.
  4. Select Harbour's Input again, choose kramerica-harbour-sep.csv and select Run local: 86 rows. Then update the publication again.
What you should see

The published dashboard shows 1,717 bikes out and 13 short days. With Harbour's file to September 27 there are three days and 51 bikes fewer. Marit's link changed only when you updated the publication.

The note for Noor

At handover you give Noor access. Open the menu at the top right and choose Share…: there you'd enter Noor's email and choose admin, because only an Admin or the Owner can update a publication. Select Add and select the three Kramerica files under "This project reads these Cloud files". Share the Kramerica folder from Cloud too, so she can upload next month's files. Noor is fictional, so look at the dialog and select Done. See Sharing.

Your note for Noor, three lines:

  1. Upload the month's three till files to Kramerica in Cloud, and pick each one in its Input.
  2. Select Run local, and check the row count and short days against last month's.
  3. In Vista, change the Text visual's dates to the new month, then select Publish, then Update publication, so Marit's link shows the new month.

A schedule wouldn't replace the note: it runs the flow at a set time, but it can't fetch new exports, and each Input points at one file.

Marit opens the link. She sees Old Town short on 9 days at 90%, Harbour on 4 and Station Road on none, and the page says what the till can't record. Whether to buy bikes, move a few from Station Road or do nothing is her decision.

See Publish a dashboard and Scheduling. For later: Checking a dashboard after a refresh covers the reasoning behind the note.

Common publishing mistakes

  • Expecting the link to update itself. Editing the project changes nothing for viewers until you update the publication.
  • Publishing rows viewers shouldn't read. A published dashboard lets viewers read the input rows it uses, whatever the filters show.
  • Leaving the dates off the page. A link opened in November still shows September. The Text visual says which month it is.

Publishing in other tools

Power BI's Publish and Tableau's Publish Workbook work the same way: readers get a copy of the report as published, and a refresh or republish is a separate step. Sharing a spreadsheet instead hands over the working file, so every reader can also change it.