Forum Discussion
Kerslaing
Helper I
Helper ILine Chart - is it possible to display dates that have multiple values
I am trying to create a timeline for my team with tasks that need done on certain dates. The date look likes this, the attribute usually has a name as well I would like this is a line cha...
bhanu_gautam
Super User
Super UserKerslaing Add a new column with a formula that combines the date and the index to create a unique identifier.
UniqueID = CONCATENATE([Date], "-", [Index])
Go to the "Report" view.
Add a scatter chart to your report.
Drag the "Date" field to the x-axis.
Drag the "UniqueID" field to the y-axis.
Optionally, you can add the "Attribute" field to the "Details" or "Legend" to differentiate between tasks.
Add a scatter chart to your report.
Drag the "Date" field to the x-axis.
Drag the "UniqueID" field to the y-axis.
Optionally, you can add the "Attribute" field to the "Details" or "Legend" to differentiate between tasks.
Click on the x-axis in the scatter chart.
Set the x-axis type to "Continuous" to ensure all dates are displayed correctly.
Set the x-axis type to "Continuous" to ensure all dates are displayed correctly.
KerslaingHelper I
Helper Ithanks for the quick response, but I cant add the unique ID to the y-axis as it is only allowing numbers in the y-axis because the x-axis is a date