I created a timeline component based on a query that retrieves some events from an element table. The columns used for the Start and End fields of the component are regular Datetime parameters in DataMiner:
However, in the timeline you can see that the events are not placed correctly in the timeline. Is there a chance that the expected time format is UTC? If that's the case what would be the recommendation, perhaps a custom GQI that transforms the dates to UTC?
Thank you.
Hi Sebastian. I checked the Dashboard from our Empower event and there the format is dd/MM/yyyy hh:mm:ss
In your case it's MM/dd/yyyy hh:mm:ss tt
I would suggest to first try with an entry in the format that we know works ok to see if indeed that's the issue.
If it is the issue, you could use a custom GQI operator to perform the transformation in the time format.
The display format of the datetime does not matter. Each cell in GQI contains a display value (using a certain format) and a raw value. The timeline is using this raw value to determine where to position its templates.