How to use transaction date on dashboard? | XM Community
Question

How to use transaction date on dashboard?

  • 30 August 2023
  • 4 replies
  • 69 views

Userlevel 3
Badge +12

We distribute surveys following business transactions using ‘transaction date’ in ISO-8601 format as required by XMD 'Transactions' specifications. This date is accurately picked up during distribution, however, it appears blank in data & analysis tab as well as on dashboard. We need to do reporting based on transaction date. Can anyone please help?


4 replies

Userlevel 7
Badge +20

@AnalystRAC This support page might help you: Date Field Format (CX) (qualtrics.com)

Userlevel 3
Badge +12

@AnalystRAC This support page might help you: Date Field Format (CX) (qualtrics.com)

Thanks @dxconnamnguyen for your reply. Customising date format is good but unfortunately it doesn’t work for transaction date in ISO-8601 format. 

Userlevel 5
Badge +14

If the transaction date in ISO-8601 format is being accurately picked up during distribution but appears blank in the Data & Analysis tab as well as the dashboard, there might be a formatting or mapping issue.
check for field mapping or date format settings

also have a look at the dashboard Configuration or Check if there are any filters or settings in the Data & Analysis tab that might be causing the transaction date to appear blank. Make sure the date field is selected for analysis.

Userlevel 3
Badge +12

Below is the response I received from Qualtrics Support, however, it doesn’t solve my problem. 

 

“You would have had to setup the respondent funnel before you started collecting responses.

If you are not able to give up the data, unfortunately you will have to manually update the data.”

Leave a Reply