I need to create an analysis that shows the Count of Tasks that ran yesterday but since they ran twice they are getting divided into two rows and two counts are shown. How do I choose only the latest run ?
Please help me out with this. Thanks in advance!
Try max(W insertdate by wid)