nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to get formula column included in dashboard building using scripting

aju_philip

Hello,

I am a beginner with JMP scripting and building a dashboard using script (assisted).

I have created a formula column in data table prior to making graphs in dashboard.

When i run the dashboard script, graph with formula column is not appearing.

Graphs with original data table is plotted correctly. But In dashboard preview everything is appearing.

When further analyzed, i can see the formula column is not created in data table built when running the dashboard.

How can i include the formula column to the data table import script and then create the dashboard.

Regards

Aju Philip

Accepted answers

aju_philip

I have found a solution myself,

In dashboard properties, selected the data table source as "Current data table" rather than embedded script.

So the formula column generated in data table with script in current data table can be used in dashboard.

Thanks

Aju

All comments

aju_philip

I have found a solution myself,

In dashboard properties, selected the data table source as "Current data table" rather than embedded script.

So the formula column generated in data table with script in current data table can be used in dashboard.

Thanks

Aju

aju_philip

This could be one of solution, but I am sure the experts out there can find another one.

Regards
Aju

hogi

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.

danschikore

In Dashboard Builder the property panel is closed by default. The easiest way to open and close the property panel is from the red-triangle menu:

From the property panel you can then change the initial settings for the Data Table Location: