How do I create an activity timeline in a Chart?

[msamandadianne]

I want to create an activity time line chart for projects with the idea to get a visual overview of the time spent on a project.

I have a data type Project Timeline with the following fields: Project Name, Date, Timeline Type. Timeline Type is an option set with 5 choices.

Can I create something line the image I drew with Bubble Charts? If so, what would my value expression be? Could each spike be color coded with the Timeline Type?

Thanks!

[Eugene_West]

You can take a range between the start day of the project and the end day, then extract the total hours from that and save it as a number to display in the chart
So:
Vertical Option is Total hours or Days of the time spent on a project ( total hours / 24)
Horizontal Option is Dates or Projects Names

[msamandadianne]

Hi @Eugene_West , thanks for your reply.

I’m not sure if that would work bc there isn’t a time range for each data point.

Each data point is only a date as far as the date data goes. For example Project Name: Test Project 1, Date: 4/20/2022, Timeline Type: Pitch.

In my example I drew, there would be 6 data points.

I can get the graph of those points but it’s just a straight line bc there’s no info for dates that don’t have any activity.

[Eugene_West]

you can add fields start day and end day to DB to count total hours, no?