I think this is a quite common trap:
- load a data file (-> source script is generated automatically)
- manually add a column (source script is not updated automatically)
- generate a graph, using the new column
- don't save the table yet (see below)
- generate a dashboard - and wonder about the error message
As the table is not saved yet, the Dashboard decides to use the source script of the data table to generate a new one
- and fails, as the source script doesn't generate the new column.
There are several ways to escape the trap:
- add the generation of the additional column to the source script before you generate the Dashboard
- save the data table before you generate the Dashboard.
Then an additional window opens and ask if it should use the source script or instead use the stored info. -> take the second option by selecting
Would be great if it's possible to change the setting later - where do I find the
dashboard properties, to select the data table source as "Current data table" rather than embedded script.