updating multiple dashboards

mhd7

Hello, 

 

I have a "can this  be done" question. Using the same data table (main sheet), I have created 4 different data tables (a,b,c,d) by sorting/splitting data from the main sheet. The data is identical on tables a,b,c,d but is arranged differently to answer different questions. From each of the 4 data tables I have created a dashboard. Hence I have one dashboard associated with table a, one dashboard associated with table b, etc. 

 

Is there an easy way to update the 4 dashboards without having to sort/split all of the data again 4 times (once for each data sheet)??

 

Thank you!

ian_jmp

I believe the answer is "almost certainly yes". But the details will depend on what you want to trigger the update, the specific table manipulations you have done, and what particular reports you have generated from the result of this.

 

Some JSL will be required, and here's a (probably) not very useful example:

NamesDefaultToHere(1);

// Make a table with some initial data
dt = NewTable("Time Series", NewColumn("Data", Numeric, Continuous, Formula(RandomNormal(0,1))));
dt << addRows(20);

// Make a control Chart
ccb = dt << Control Chart Builder(
					Show Control Panel( 0 ),
					Show Capability( 0 ),
					Variables( Y( :Data ) )
				);

// Simulate the arrival of new data
for(t=1, t<=10, t++,
	Wait(2);
	Beep();
	dt << addRow(1);
	);