Solved
Outputting the latest response only
There is a data point that I am looking to just output the latest response only (i.e. rather than showing the trend of responses, I just need to know the last response data from user).
Maybe I'm missing something - as I've been browsing the widgets and couldn't find anything readily for this. Is there a widget or a setting that I've overlooked?
Best answer by bstrahin
@sPham you can achieve this by inserting a Results table. Sorting by Recorded Date (Z-A) and putting the number of rows to show as 1.
View original
+38@sPham you can achieve this by inserting a Results table. Sorting by Recorded Date (Z-A) and putting the number of rows to show as 1.
Interesting workaround. I'll have to keep this in mind for some items.
A workaround I did was that I ended up filtering by months (like last 30 days) in order to "force" the latest one. This can be problematic should there be more than one entry in 30 days however.
If only if there was a filter for "latest response".
Leave a Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.