Question
Line Chart with Time on Y-Axis and Date on X-Axis
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"
)
}
)