Forum Discussion
Sorting by Completion Time
I'm sorry, I'm not sure what I was thinking here...the dataset I was using is a bit different (I can't edit your data model in PQ because of access to the data sources).
Honestly, since there are multiple values in the response fields that are exactly the same and they have different completion times, I don't find a way this will be possible. For example, the 30 Day New Hire Survey table, even if you got rid of the blanks in the response column you still have multiple values that say "None" and each one of those have different completion times.
In order to sort, you would need to either change those completion times to be the same or make those responses uniquely different, e.g. concatenate a unique id at the end of the responses. Then you would be able to sort the respones by completion time. The only downside is that the end user of this report would see that id at the end of the response.