Brainstorming - Data visualization

Hi all,
I’ve been checking out the great posts about QuickChart, as introduced by @Robert_Petitto. It is truly a super tool and very easy to use. When browsing the options there, I thought that perhaps it could solve another question I had previously, about how to build a nice graphical timeline view.

I was thinking about using their GraphViz option

Something like this
https://quickchart.io/graphviz?graph=digraph{NewLead->IntroCall->FirstMeeting->Signing->FirstOrder->OrderFullfilled->Payment;}

That will result in this

I’ve looked, but I can’t find a way to add labels on the arrow lines, for either the date or the milestone name, or anything else.
I also cannot think about any other way to beautify this.

Assuming we have found a way to make this pretty, how do we approach the challenge of not all timelines/roadmaps being the same? i.e. some clients will need just an intro call to sign, while others might need the call plus five meetings. Other leads will of course be DOA and this should also be reflected in this visual aid.

Any ideas?

BTW - I’ve also look into DataWrapper

Could make it pretty enough there as well.

The urls for the quickchart images don’t have to be static. A Template column, and/or Construct URL column will allow you to dynamically build the url with whatever parameters you want. If you want a different timeline/roadmap, then only pass in the parameters you need to built the url. That way it’s a dynamic image based on your data.

Sure, that was my intention of doing. But my questions have been regarding adding some data to the visual. Something to make it clearer if you are looking at it with a quick glance during a busy workday. And, forgive me for saying, also make it clearer for our less-than-techy users.
BTW - the template section is rather challenging here, similar to my other question from yesterday about an accumulated list. Here, same as in the use case in the other question, we don’t always have the same flow/parameters so we might be left with “->” that are point to nothing, thus breaking the URL.

A template for something like this shouldn’t be challenging. It’s just a matter of the url being the template, and just replacing the ‘digraphc’ parameter with something like a Joined List column value, or another Template value. Something like this.

https://quickchart.io/graphviz?graph=digraph{REPLACE;}

A joined list let’s you specify any delimiter, so you could use a → in place of a comma. Very easy to make it dynamic. I don’t know your workflow, but if your timeline items are in rows, then I would use a joined list. If they are in a single row, then I would use a template.

Either way, I think it would help to understand how you are building that timeline list.

I have your other thread bookmarked. I haven’t taken the time to fully comprehend it. Chris what @Darren_Murphy will come up with.