Forum Discussion
trend over time based on application
Hello Experts,
Based on the application and submitted date - I'd like to create a trend over time visual using start date/start time and end date/end time. Help me on how to achieve this. Thank you
| Application | Submitted Date | Start Date | Start Time | End Date | End Time |
| Test 123 | 22-Feb-20 | 2/22/2020 | 4:32:17 | 2/22/2020 | 4:32:28 |
| Test 124 | 22-Mar-20 | 3/22/2020 | 4:32:17 | 3/22/2020 | 4:32:24 |
| Test 125 | 22-Apr-20 | 4/22/2020 | 4:32:17 | 4/22/2020 | 4:32:23 |
| Test 126 | 22-May-20 | 5/22/2020 | 4:32:17 | 5/22/2020 | 4:32:23 |
| Test 123 | 22-Jun-20 | 6/22/2020 | 4:32:17 | 6/22/2020 | 4:32:23 |
| Test 124 | 22-Jul-20 | 7/22/2020 | 4:32:17 | 7/22/2020 | 4:32:23 |
| Test 125 | 22-Aug-20 | 8/22/2020 | 4:14:12 | 8/22/2020 | 4:32:16 |
| Test 126 | 22-Sep-20 | 9/22/2020 | 3:50:28 | 9/22/2020 | 3:50:51 |
| Test 123 | 22-Oct-20 | 10/22/2020 | 3:34:07 | 10/22/2020 | 3:50:22 |
| Test 124 | 22-Nov-20 | 11/22/2020 | 3:04:37 | 11/22/2020 | 3:04:38 |
| Test 125 | 22-Dec-20 | 12/22/2020 | 3:04:12 | 12/22/2020 | 3:04:12 |
| Test 126 | 22-Jan-21 | 1/22/2021 | 2:43:13 | 1/22/2021 | 2:43:34 |
| Test 123 | 22-Feb-21 | 2/22/2021 | 11:30:00 | 2/22/2021 | 1:21:13 |
| Test 124 | 22-Mar-21 | 3/22/2021 | 11:34:19 | 3/22/2021 | 11:37:23 |
| Test 125 | 22-Apr-21 | 4/22/2021 | 9:54:56 | 4/22/2021 | 9:55:04 |
| Test 126 | 22-May-21 | 5/22/2021 | 8:32:58 | 5/22/2021 | 8:59:55 |
2 Replies
Could you provide a little more information on what trend you would like to see? Is it the difference between start/end date?
For an example - I'd like to see a trend of end times for application "test 123" spanned over months/years
