Assuming this imaginary data table:
is it possible to create a variablity chart for Student by Course, while only counting in Ted score once (1 occurence) ?
I'd like to perform it without creating a new data table or filtering it out using a data filter.
Solved! Go to Solution.
Thank you for your reply,
I guess my example wasn't good enough, so it didn't give a good idea on what I tried to achieve. I'll try to be more specific:
So currently, the variability chart include both values as observations.
My window for the charts is created using scripts, so I initially thought about creating a New Data Table for the variability chart, that will have duplicate rows removed, but it'll have to be recreated each time the user change the selection on the data filters, so it's a no-go.
I'm also thinking about ranking the duplicate rows and somehow tell the variability chart to select only rows where (rank==1) but I'm not sure if it's even possible.