Forum Discussion
Separate data with the same date
I created a control chart by unpivoting my rows. My original data set looked like this where 5 measurements were taken. Sometimes, there were two loads in one day, each load having 5 separate measure...
If there is an existing field that differentiates the different loads (e.g., Load ID, Load Name), you can use that in the Details field of a scatter plot or as a legend in other plot types. If not, you can always add an index column in the query editor before you unpivot your columns to serve as that.
Pat
mahoneypat
Microsoft Employee
Microsoft EmployeeIf there is an existing field that differentiates the different loads (e.g., Load ID, Load Name), you can use that in the Details field of a scatter plot or as a legend in other plot types. If not, you can always add an index column in the query editor before you unpivot your columns to serve as that.
Pat