Anyone have this issue where months don't appear in time order? | XM Community
Question

Anyone have this issue where months don't appear in time order?

  • 24 September 2018
  • 3 replies
  • 6 views

Anyone have this issue where months don't appear in time order in a widget ?
Hoping images appears below but if not it has jun- aug- jul - sept

I can manually update order in edit but it's a bit annoying
It is feeding from a "month" column added to dataset rather than "complete date"
Our months historically did not exactly align with calendar so for consistency we kept BUT can it still recognize as a date sequence?

3 replies

Userlevel 7
Badge +27
Hi @SoniaC18 ,
When we create a simple chart with x axis as date , it removes the axis sorting option , so if your data sequence is being recognized as date there wouldn't be an option to sort . So what i assume is that your axis is sorted in custom format and by default in custom formatting it aligns in the order of the data import format. hence most likely you will be required to manually update the order.
Hope this helps 🙂
Userlevel 7
Badge +33
You can sort this by customize.
Userlevel 7
Badge +20
I am not sure other than sorting it manually it will work... however if this data set has been imported with legacy import (documentation below) with month column data added in (Qualtrics default) "end date" column then you could have used Qualtrics default column "end date" with Month as a trend.

https://www.qualtrics.com/support/survey-platform/data-and-analysis-module/data/import-responses/#ImportingYourResponses

Leave a Reply