Date line graph--is this possible?

Lyndsy Haviland · 12/08/20

Hello, I'm trying to figure out how to create something like the image attached. Each point is a project and the dates correspond to the approval of each project. Each dot would have a project name label on it (removed here for privacy). They are horizontally divided by market (each color is a market and label also removed for privacy). I've already entered in a few sample projects into smartsheet but I'm not finding a way to pull one date from each project into it's own sheet/chart. Is there any way this can be created in Smartsheet?

Andrée Starå · 12/08/20

Hi @Lyndsy Haviland

I’d recommend using a 3rd party BI tool like Power BI or similar that integrates with Smartsheet.

Is that an option?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Lyndsy Haviland · 12/08/20

https://community.smartsheet.com/discussion/comment/271091#Comment_271091

Thank you Andree! We have Power BI too but unfortunately I know that the particular graph I'd like to create cannot be created there. This data is currently in Excel. I'm looking for any tool (Power BI or Smartsheet) that can create this chart without constant manual intervention.

Andrée Starå · 12/08/20

@Lyndsy Haviland

Happy to help!

Would any of the following alternatives work?

https://www.smartsheet.com/marketplace/apps/easy-insight

https://www.smartsheet.com/marketplace/apps/qlik

https://www.smartsheet.com/marketplace/apps/tibco-spotfire

https://www.smartsheet.com/marketplace/apps/tableau

https://www.smartsheet.com/marketplace/apps/domo

Lyndsy Haviland · 12/09/20

https://community.smartsheet.com/discussion/comment/271110#Comment_271110

Hi Andree, unfortunately I'm limited to licenses with only Power BI and Smartsheet. I'm not sure if there is a different way I can show the data instead? I may be trying to put too much onto one graph. Is there a way to break it down to at least figure out if it's graphable in BI or Smartsheet?

Andrée Starå · 01/04/21

@Lyndsy Haviland

Unfortunately, it's not possible at the moment to create something similar in Smartsheet, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

What kind of data is it, and what do you want it to show?

I hope that helps!

Have a fantastic week & Happy Holidays!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Date line graph--is this possible?

Answers

Help Article Resources

Categories