How to format data for chart to sort by date?

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 :slight_smile:

Hello, welcome to the community. Could you share screenshot and detail code of chart?

It actually ended up resolving itself today, I believe it may have just been a bug that was giving me trouble. I did notice while testing yesterday that if there were two "provider" values on one date, and I grouped by provider it was out of order in terms of date.