How to select wider set of data from the graph builder?

[#1]

I'm working with data from multiple tests, ran on multiple devices. The tests produce different parameters and require different axes to plot and view.

I can create a graph builder plot for data from test 'A', and a separate one for test 'B'. There are times when I would like to be able to select a test result (highlight and drag) in plot 'A', and see the corresponding data in plot 'B' highlighted for the same device.

Data in both plots is continuous bivariate, plotted as a line. I already create a 'unique ID' column, to specify an individual test on an individual device, this is used in the overlay box to separate the plots within one graph.

The way I have to do it at the moment is to create another ID column, that identifies the device uniquely. Then I select the data in the graph I'm interested in, then I go to row editor and copy the value in the device ID column. I then do a row selection on this to select all rows for that device, then the data in the other graph is highlighted to see.

That isn't very convenient, I was wondering if there was an easy way to do it? As I see it, the graph builder platform needs something like a 'sub-overlay' category. Entering a column to it will select all rows matching the value in the data you just selected.

[#2]

Hi @GRoberts86 ,

You can use a global data filter on the data table that the Graph Builder report is attached to to select the rows that meet the criteria of the equipment you're using, i.e. in the example below I have a filter on the table below that is selecting certain groups of particle sizes that have been used and is highlighting the associated rows in the graph. It's essentially doing the row selection that you are already trying to do but making it easier

thanks,

Ben

[#3]

How is your data structured? You can create quite interactive graphs when you combine local data filter(s) and column switcher(s) (and sometimes global data filter). There are also hover labels which can help in some cases. You could also create "selection" which can be utilized in filters or in the graph.

Here is example of selection formula from Big Class, if any value from age is selected, all values will get one for "Column 6" for that specific age

with few age selections

Formula used 

Col Sum(Selected(), :age) > 0

[#4]

Thanks, that idea makes it easier to find the rows in the table, less clicking than using the row editor and search. It needs formula evaluation on, however, which is a problem for my large tables. Maybe a table script, that does the same. That could be run manually to select the rows

[#5]

dt = CurrentDataTable();
dt << Go To( :Unique ID 2 );
Wait( 2 );
dt << Select All Matching Cells();

I just created the table script above. Where 'Unique ID 2' is the ID column that specifies an individual device.

This seems to do what I want. The 'CurrentDataTable' use in this case isn't dangerous... As far as I can see...

[#6]

Using Current Data Table() can sometimes be a bit risky in table scripts but most of the time it isn't an issue. Other option could be to add a button to your report which would then do the selection. In this case you could make sure that the button will always use the correct table. You can also trigger scripts when user clicks on hover label which could be used for something like this, but it is a bit more involved solution.

[#7]

I'm just selecting rows, so I don't think that it's very dangerous here.

How do I add a button to a report? Thanks

[#8]

An example dataset would be very useful for investigating your problem.

[#9]

I've made a mock up to try to illustrate.

Two different devices [X/Y], receive two different tests, producing parameters A and B for test T1, and C and D for test T2.

Charts for B vs A, and D vs C are included, and they split the data plots by the unique test ID [UID].

While looking at the T1 chart, I might decide I like the look of the result for device 'Y' in red, and want to see the T2 data corresponding to it. If I select the Y device line in the T1 chart, it only selects the T1 row data, so the highlighting doesn't carry over to the T2 chart. I'm looking for a way to easily select all data for that device. I'll have a play around with the row selection formula from jthi, thanks. Any other ideas are much appreciated, thanks.

[#10]

@GRoberts86, if the challenge is only to select all data for one device so it highlights across graphs, you can use the histograms under the column headers in the data table. You can find them by clicking the green histogram icon in the column header row. Then, you can click into the bars of the histogram under the "Device" column header to select the device for which you want to highlight the data. See the screenshot below using your example.

Unless, of course, selection from the graph builder itself is a must?