I have tests where I have multiple variables that are swept. Each one of these variables is saved in a separate column in the database.
I was not able to find a good way of plotting the info similar to pivot charts where you can use drop down boxes to select individual values of the parameters that are swept.
I am not sure I understand what you want, but have a look at Graph Builder. In combination with a Local Data Filter you can get create a very versatile and "pivot-like" graph. Especially if you first stack your data and use the local data filter to not only select values but also variables.
Thanks. the local data filter only provides a sliding bar which is hard to set discrete values. I think you can type both the start and end value to be the same but it's suboptimal.
when you mention stack your data, do you mean to have the separate variables in the same column?
Yes, continuous variables are represented by a slider in the local data filters. If your data are numeric but in practice represent categories or levels you can change data type to nominal or ordinal which would provide a list box with the values.
And yes, with stack I mean just that. The Stack command (in Tables menu) can do this quickly.
Alternatively, instead of stacking your columns, you can use the Column Switcher to swap one column out for another. The video below shows both the Column Switcher and the Data Filter in use.