Line chart with multiple date-numbers traces

Jakub Gill
edited 12/09/19 in Smartsheet Basics

Hello everyone!

 

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'.

 

Any ideas?

comparision.chart_.png

data.png

«1

Answers