Hi all,
I’m trying to sort these ids based on the date they’ve been delivered in descending order, which requires a custom sort.
However, nothing seems to be changing when I apply a custom sort based on the date attribute in my pivot table. I assume the issue is because of the aggregation, but the only options available for that is ‘Count’ & ‘Count Distinct’. I would ideally like to show the most recently sent deliveries first. Does anyone know a workaround for this? Thanks!
Hi @Nausheer_Syed
can you show the definition of the visual?
did you sort the columns or rows?
BR
Hi @Nausheer_Syed
you would need to try to use a “off-visual field”.
BR
Hi @ErikG,
I’ve tried doing this already but it does not work.
In this case, please create a new calculated field named Min Delivery Date. Then, go to the field well, select the delivery ID, click on the visual field, and select the newly created calculated field. Finally, apply the descending order.
I believe this will provide the solution. Please let me know if you encounter any further challenges.
Please follow this pic for your reference.
Pic -1 :
Pic -2 :
Pic -3 :
Thanks & Regards
Biswajit Dash
It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.
If we don’t hear back within the next 3 business days, we’ll proceed with closing this topic.
Since we have not heard back from you, I’ll go ahead and close this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.
Thank you!
