Timeline chart using Date field in JPD

Guy Geron_fidbxy

Hello, 

We have ideas in our JPD project that will attract revenue. 

I'd like to create a timeline widget to demonstrate when we should expect this revenue to commence based on a date field. 

The date field isn't a date field and looks like a string. 

I've tried using Analytics, but the date field doesn't appear in the dataset. I did resync repeatedly, and still nothing. 

It feels like something that should have been simple, became quite complex to do. 

Does anyone have any idea how to approach something like that?

 

 

Joey_x4f3b3

Hi @Guy Geron,

The issue with the date field being recognized as a string can indeed be frustrating. Here are a few steps you could try to resolve this issue:

• Check Field Format: Ensure the date field in your dataset is formatted correctly as a date. Sometimes data might look like a date but is stored as a string.
• Data Conversion: If the date field is a string, you may need to convert it to a date format. This can often be done within your data preparation or ETL process.
• Custom Fields in Jira: If you're using Jira Product Discovery, ensure that your custom date field is properly configured and synchronized.
• Analytics Tool Settings: Double-check the settings in your Analytics tool to ensure it is capable of recognizing and processing date fields.

Additionally, you might find the TeamBoard ProScheduler plugin for Jira very helpful. It provides advanced scheduling and timeline & Gantt chart functionalities that might simplify the process of creating your desired timeline widget.

I hope this helps!