cancel
Showing results for 
Search instead for 
Did you mean: 

Report on Surveys - How to extract only latest answers submitted

0 Kudos

Hi Experts,

I need to create a report on a survey that extracts only the latest answers submitted for each account. For example, if the survey has been submitted twice for a certain account, then the report should show only the answers related to the latest survey submitted.

Does anyone know how I can achieve it?

Thanks ans Regards,

Lorenzo

Accepted Solutions (0)

Answers (1)

Answers (1)

Bharathraj_A
Active Participant
0 Kudos

Hi Lorenzo,

You can try the below approach , if the survey submitted date is available in the data-source.

Step 1. Create a calculated Key Figure (Submitted Date -Today)
Step 2. Create a a ranked condition in Report ( Key Figure : Created in Step 1, Characteristics: Account, Rule : Top Count, Values : 1.

Note: It will not work, if it is submitted twice on the same day. We don't have any common date as "Now"

Regards,
Bharathraj