Creating a line chart using multiple dimensions (using date fields)

[dreweezy]

I am trying to create a line / bubble chart to create a line chart based on how long each department took to approve for a given account. The problem I am seeing is I cannot bring in 5 different department dates into my chart as it discombobulates the logic. I have attached my app and a .png of what I am trying to achieve. I hope it makes much more sense. If you have any thoughts on how to go about this, would love to hear you guys thinking.

Thanks!

[rogerpegler]

I would change the underlying data model into a table that has a row per account and department with a third column for the number of days.

[pedrobergo]

Hi,

You need to unpivoting the table, moving the coluns to lines.

Enter in the script editor and Sees the script that do that to you.

Pedro