Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Emily
Contributor
Contributor

How to compare data overtime

I have survey responses that I am trying to visualize.

 

We have customers and we ask how likely are they to recommend the company.  Some customers fill out the survey more than once as they continue to do business with the company a few months later. I want to track how or if any responses changed.

 

Full name     month/year                  Likely to recommend (1-10)

John Doe     Jan 18                                     10

Alex Smith  March 18                                  9

John Does  October 18                             8

Alex Smith  Jan 19                                        9

 

From this list, I want a way to visualize repeat respondents and if their scoring has changed. Based on my fake data, John was less likely to recommend whereas Alex said the same. 

 

 

A possible solution only shows a filter that shows names of people that have two different ranking scores.  So we can see which customer has changed their opinion from a previous date.

 

Or can I have a scatter plot with the dates by month and year on the x-axis and likely to recommend on the y-axis and customers each has a unique color to distinguish themselves?  But only show customers who have taken the survey more than once.

 

I'm sorry if this is confusing but I'm trying to think of an easy way to navigate changes in likelihood to recommend on a customer level.  But I want to just focus on customer who has taken the survey more than once. 

 

 

0 Replies