Hi all,
Has anyone created a line chart having the Time on Y-Axis and Date on X-Axis? We're looking to visualise data for the time of day that requests enter the queue for an application to identify peak periods.
Below is a sample interface we're playing with, essentially we want to change the "# cases" on the Y-axis to "time of day". Any information or examples will be much appreciated! Thank you.
a!localVariables( local!requests: a!dataSubset( data: { { created_on: datetime( 2019, 1, 10, 5, 7, 10, 0 ), id_count: 65, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 1, 11, 5, 7, 10, 0 ), id_count: 66, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 1, 12, 5, 7, 10, 0 ), id_count: 67, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 1, 13, 5, 7, 10, 0 ), id_count: 70, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 1, 14, 6, 7, 10, 0 ), id_count: 72, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 1, 15, 6, 7, 10, 0 ), id_count: 69, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 1, 16, 6, 7, 10, 0 ), id_count: 75, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 1, 17, 6, 7, 10, 0 ), id_count: 73, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 1, 18, 6, 7, 10, 0 ), id_count: 77, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 1, 19, 6, 7, 10, 0 ), id_count: 80, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 1, 20, 6, 7, 10, 0 ), id_count: 76, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 1, 21, 6, 7, 10, 0 ), id_count: 78, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 1, 22, 6, 7, 10, 0 ), id_count: 80, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 1, 23, 6, 7, 10, 0 ), id_count: 77, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 1, 24, 6, 7, 10, 0 ), id_count: 75, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 1, 25, 6, 7, 10, 0 ), id_count: 80, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 1, 26, 6, 7, 10, 0 ), id_count: 83, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 1, 27, 6, 7, 10, 0 ), id_count: 86, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 1, 28, 6, 7, 10, 0 ), id_count: 83, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 1, 29, 6, 7, 10, 0 ), id_count: 88, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 1, 30, 6, 7, 10, 0 ), id_count: 90, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 1, 31, 6, 7, 10, 0 ), id_count: 94, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 3, 1, 1, 7, 10, 0 ), id_count: 135, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 3, 2, 1, 7, 10, 0 ), id_count: 132, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 3, 3, 1, 7, 10, 0 ), id_count: 136, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 3, 4, 1, 7, 10, 0 ), id_count: 138, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 3, 5, 1, 7, 10, 0 ), id_count: 134, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 3, 6, 1, 7, 10, 0 ), id_count: 137, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 3, 7, 1, 7, 10, 0 ), id_count: 135, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 3, 8, 1, 7, 10, 0 ), id_count: 137, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 3, 9, 1, 7, 10, 0 ), id_count: 135, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 3, 10, 0, 0, 0, 0 ), id_count: 138, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 3, 11, 0, 0, 0, 0 ), id_count: 137, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 3, 12, 0, 0, 0, 0 ), id_count: 139, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 3, 13, 0, 0, 0, 0 ), id_count: 140, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 3, 14, 0, 0, 0, 0 ), id_count: 136, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 3, 15, 0, 0, 0, 0 ), id_count: 142, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 3, 16, 0, 0, 0, 0 ), id_count: 146, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 3, 17, 0, 0, 0, 0 ), id_count: 144, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 3, 18, 0, 0, 0, 0 ), id_count: 146, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 3, 19, 0, 0, 0, 0 ), id_count: 150, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 3, 20, 0, 0, 0, 0 ), id_count: 146, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 3, 21, 0, 0, 0, 0 ), id_count: 146, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 3, 22, 0, 0, 0, 0 ), id_count: 148, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 3, 23, 0, 0, 0, 0 ), id_count: 145, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 3, 24, 0, 0, 0, 0 ), id_count: 147, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 3, 25, 0, 0, 0, 0 ), id_count: 145, time: time( 5, 7, 10, 0 ) } } ), { a!lineChartField( label: "Requests", categories: index( local!requests.data, "created_on" ), series: { a!chartSeries( label: "Requests", data: index( local!requests.data, "id_count" ), color: "GREEN" ) }, yAxisTitle: "# cases" ) } )
Discussion posts and replies are publicly visible