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
v-xiaotang
Community Support
Community SupportHi Anonymous
Have you solved your problem? If yes, kindly accept the answer helpful as the solution. so the others can find it more quickly.
Or
if problem still persists, please let me know.
Best Regards,
Community Support Team _ Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.