Forum Discussion
Timeline showing start date, end date and current date per project/initiative
Community ChampionRajbunny maybe its better to discuss what your objective is? are you wanting to slice by month? which visual are you using because there are several that use time, is the the timeline storyteller?
My objective is to achieve a visualisation that looks like this image (which is manually created in the most hateful powerpoint)
It shows a timeline in months, positions a start and end indicatior on the time line as well as today's date. Another thing I have to do is change the colour of the arrow based on wether the project is on track or delayed (red, amber, green)
Im trying to use a Gantt chart now - I WAS having issues with duration showing as 1 day regardless (managed to fix duration with a datediff converstion - this requirement is not made clear in the video guide).
I am now struggling with the % complete (showing as 100% for all initiatives, regardless -so I assume once again the data needs to be converted from a percentage to a decimal value). Also, once I have figured out how the data must look to for a visualisation to show anything at all, I still have to learn how to customise the look and feel as well as determine how i can set start and end dates for both the timeline (jul 17-jul18) start and end dates for the selected initiative (currently only shows the latter) - it will be devastating to learn in the end that it can not create the visualisation I am after. First prise would be a recommendation to use a custom visualisation that someone knows will do the job along with advice on how the source data should look (to avoid more time waste). Second prise is advice on how to set up the source data to get the Gantt custom visualisation to get as close to expected as possible