Hi Everyone,
I have an issue with a chart I've created and sorting by date on the x-axis. I have a date key value pair returning from my mongo query (then run through a transformer), but it isn't sorting on the x-axis by date. The currently x axis order is is 08/21, 08/24, 08/28, 08/25, with y axis values for the different providers. This is the format I want, but the dates are out of order.
X-axis values: date
group by: provider
Data source:
[
{
"date": "08/21",
"provider": "ATT",
"status": 1
},
{
"date": "08/24",
"provider": "ATT",
"status": 4
},
{
"date": "08/25",
"provider": "ATT",
"status": 1
},
{
"date": "08/28",
"provider": "Verizon",
"status": 1
},
{
"date": "08/28",
"provider": "ATT",
"status": 2
}
]
In the end I'd like to have the dates be MM/DD, how would I sort this in sequence by date? I appreciate any help