on 04-01-2020 4:50 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.