topic Re: How to get formula column included in dashboard building using scripting in Discussions

How to get formula column included in dashboard building using scripting

aju_philip — Sat, 10 Jun 2023 23:32:23 GMT

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

aju_philip — Thu, 24 Jun 2021 04:40:37 GMT

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 — Sun, 27 Jun 2021 06:50:41 GMT

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

Regards
Aju

hogi — Wed, 23 Mar 2022 11:23:11 GMT

I think this is a quite common trap:

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 — Wed, 23 Mar 2022 13:58:17 GMT

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: