Line chart with multiple date-numbers traces
I can't find a way to accomplish certain kind of chart using chart widget in dashboard. Chart is supposed to show multiple lines, one for each team member connecting dates when a certain task was completed. Tasks are represented by increasing numbers 1,2,3,etc. and can be completed on different dates. I attached two images showing sheet with data (date completed, protocol number and team member) and chart I would like to create in dashboard. The attached chart was generated by grouping data by third column 'Sheet name'.