Getting last value by combining two filters

Question

Hello to all&nbsp;I have the following historical table:Id&nbsp; &nbsp;Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;issueid&nbsp; &nbsp; Release&nbsp; &nbsp;LastRelease1&nbsp; &nbsp; 2017-10-12&nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;False2&nbsp; &nbsp;&nbsp;2017-11-12&nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;False3&nbsp; &nbsp;&nbsp;2017-12-12&nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;True4&nbsp; &nbsp;&nbsp;2017-10-12&nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; True5&nbsp; &nbsp;&nbsp;2017-11-12&nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; True6&nbsp; &nbsp;&nbsp;2017-12-12&nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;False7&nbsp; &nbsp;&nbsp;2017-11-12&nbsp; &nbsp; 6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;False8&nbsp; &nbsp;&nbsp;2017-12-12&nbsp; &nbsp; 7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;False&nbsp;What I need is to display a table to display the issueid.In the case above I would like to display to release 2 (Release true):issueid34&nbsp;Because in fact 5 was moved to Release 3 and it should not be displayed.&nbsp;I'm able to make a table but 5 keeps showing... because in fact we have a True in the list.&nbsp;&nbsp;Any ideias?

anonymous · Accepted Answer

Zubair_Muhammad&nbsp;Thanks for the reply&nbsp;I'm getting a duplicate dates in last date... which is correct because I can get the same date for different issueid.

Forum Discussion

Getting last value by combining two filters

2 Replies

Related content

Tables combine

Filter combinations

How to get the conditional formatting for missing combinations

Combined conditional filtering

Dynamic RLS combination