Hi Qualtrics colleagues,We have built a survey that is launched quarterly. First wave was launched on last April’23 and next wave will be launched now in July’23. Next wave is expected to be launched on next October’23.We would like to know if there is a way to build trend widgets so let us to compare results in a quarterly based. It means, we’re interesting on comparing results Q3’2023 vs Q2’20203 and so on. Also, not only for the trend graphs but also in the number widgets and rest of themIs there a way to create a new ‘date field’ that lets us to compare results quarter by quarter? For instance creating a new field in ‘Data Analysis’ tab that identifies which quarter each interview belongs to.The main goal is creating also as a new field coded as ‘date format’ or at least that can be coded as ‘date format’ in the dashboard to work with accordingly.Thanks for your support!

You can create three embedded fields to capture date, month, and year. Field name should “CurrentDate, CurrentMonth, CurrentYear” and paste below code in your very first question of the survey.CurrentDate will capture “07/2023”, CurrentMonth will capture “07” and CurrentYear will capture 2023. Then you can use these field under survey.Qualtrics.SurveyEngine.addOnload(function(){/*Place your JavaScript here to run when the page loads*/var today = new Date();var Month = String(today.getMonth() + 1).padStart(2, '0'); //January is 0!var Year = today.getFullYear();today = Month + '/' + Year; // output 07/2023Qualtrics.SurveyEngine.setEmbeddedData( 'CurrentDate', today);Qualtrics.SurveyEngine.setEmbeddedData( 'CurrentMonth', Month);Qualtrics.SurveyEngine.setEmbeddedData( 'CurrentYear', Year);});Secondary, you can directly use record date as each widget segment (data series) in your dashboard and represent the data quarterly basis. Please refer below option.

@ArunDubeyit seems it also applies for previous interviews, correct? I’ve already applied it for a widget which counts the number of interviews:

Quarterly Survey > How to create a 'Quarter' date new field based on current 'dates' fields in Data & Analysis tab

Quarterly Survey > How to create a 'Quarter' date new field based on current 'dates' fields in Data & Analysis tab | Experience Community

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded