Discrepancy between raw data and data in Vocalize | XM Community
Skip to main content
Solved

Discrepancy between raw data and data in Vocalize

  • July 23, 2018
  • 5 replies
  • 53 views
KristyP
Level 2 ●●
Forum|alt.badge.img+10
Hello everyone! Has anyone experienced discrepancies between what is pulled via raw data and what is showing in Vocalize? For the past couple of months I'm always a handful of responses off, either a few too many or a few too little. Everything seems to be aligned with dates, survey status (i.e. Finished) and anything else I have set, but I always have these stragglers in the raw data. For example this month I exported raw data for July 1 to 22, and I seem to have 5 less responses in the raw data than what I have in vocalize for the same data range/filtering. Hoping to shed some light on the cause so I'm at least able to explain any slight adjustments in scoring or totals. Thanks, Kristy

Best answer by KristyP

Hi @Mohammedali_Rajapakar_Ugam I just realized in my test one I hadn't set the dashboard time zone so thank you for pointing that out, however we're still an hour off. Thinking about when we started seeing issues, it was the same month we changed to Daylight Savings Time, so now we're looking at the data taking into account that hour change over. If the data lines up and there is no fix we might have to just manually change the time zone by an hour to accommodate the time change until we go back in November. Getting closer to the solution at least ;) Thanks!

    5 replies

    PeeyushBansal
    Level 6 ●●●●●●
    Forum|alt.badge.img+44
    • PeeyushBansal
    • Level 6 ●●●●●●
    • July 24, 2018
    Only records with Finished=1 appear in vocalize, can you check by assigning flag say 1 to your raw data file and than filtering in dashboard with flag=1.
    Best Regards, Peeyush
    KristyP
    MohammedAli_Rajapkar
    QPN Level 5 ●●●●●
    Forum|alt.badge.img+20
    Hi @KristyP I hope you know that Vocalize show only recorded data and since as per your statement the difference is only a few records then you should check the timezone in which Vocalize showing the data. Maybe the 5 records are getting shown under June 30. In vocalize, the time-zone is shown at the bottom of the dashboard screen. You can try changing it to what you have for raw data.
    Regards, Mohammed Ali
    KristyP
    KristyP
    Level 2 ●●
    Forum|alt.badge.img+10
    • KristyP
    • Author
    • Level 2 ●●
    • July 24, 2018
    Hi @bansalpeeyush29 and @Mohammedali_Rajapakar_Ugam Thanks for your help! The filters were set properly (as I thought the same thing with the Finished=1 being off) and the time zones looked like everything was good to go and both environments listed EST time which is perfect. That being said, looking closer at that I ran a quick test and noticed that despite the time zone being set properly, the time of the data being presented in Vocalizer was set to 4 hours ahead of my local time. So my test that went through at 8:55am this morning was listed as 12:55pm in Vocalizer. I've reached out the Support team to see if they can have a look as that is most likely what is messing up my data in between the two. I'll post their response here in hopes of helping anyone else seeing the same issue. Thanks again! Kristy
    MohammedAli_Rajapkar
    QPN Level 5 ●●●●●
    Forum|alt.badge.img+20
    ! Just checking, did you try changing the time zone on dashboard page? Try edit dashboard and scroll to the bottom of the page and select "EST" (if you are collecting response in EST timezone).
    Regards, Mohammed Ali
    KristyP
    Level 2 ●●
    Forum|alt.badge.img+10
    • KristyP
    • Author
    • Level 2 ●●
    • Answer
    • July 24, 2018
    Hi @Mohammedali_Rajapakar_Ugam I just realized in my test one I hadn't set the dashboard time zone so thank you for pointing that out, however we're still an hour off. Thinking about when we started seeing issues, it was the same month we changed to Daylight Savings Time, so now we're looking at the data taking into account that hour change over. If the data lines up and there is no fix we might have to just manually change the time zone by an hour to accommodate the time change until we go back in November. Getting closer to the solution at least ;) Thanks!
    Terms & ConditionsAccessibility statement