Bar Chart with Series Sorting

  • 0
  • 1
  • Question
  • Updated 1 month ago
  • Answered
I'm creating a bar chart with a series.

The chart differentiates between laptop and desktop machines is broken down by average cost by month based on a date field called "date acqird".

But I can't get the chart to sort by date acquired -- and I'm not really given options on how it's sorted except for "low to high" or "high to low".

How would I do this?

Thank you!

Photo of Amber

Amber

  • 506 Points 500 badge 2x thumb

Posted 1 month ago

  • 0
  • 1
Photo of Kingsly SD Samuel

Kingsly SD Samuel

  • 476 Points 250 badge 2x thumb
Just wondering: Does it solve the issue if you uncheck "show month as a name" option in the field properties of Date Acquired? I think having the month in alphabet format is causing this issue. If you make it show in number, this should be sorted appropriately
Photo of Amber

Amber

  • 506 Points 500 badge 2x thumb
Thanks for your reply! The date acquired field actually just displays the dates as numbers "08-01-2018", etc, but the report is summarizing them by month so it can average the monthly cost.

What would you suggest?
Photo of Kingsly SD Samuel

Kingsly SD Samuel

  • 476 Points 250 badge 2x thumb
Try changing the x axis group by to "day" instead of "month"
Photo of Amber

Amber

  • 506 Points 500 badge 2x thumb
Ah, that helped immensely...thank you!!!