Need to Total count in Single row with multiple condition

[NavaneethaRaju]

Hi,

I want to show the total count orders for after the missing date, as well as i want to show only one record for each tag id,

which is the last order date and Order id after the missing date , how many order has placed after that date.

I applied latest order date, its showing last order date, but when i applied latest order id, its not showing exact order id for that date.

it showing which order id is maximum in that range. but i want the exact order id for that last date.

And i want to show the total order count on that date range. 

Please advice.

[v-jingzhang]

Hi @NavaneethaRaju 

I don't 100% understand the expected result you want to get. Does all data come from the same table? Does every tag has only one missing date in the table? Do you only want to change the count result after the missing date, but no need to change the count results before the missing date for every tag? 

Can you please paste some dummy data in the post as well as the expected result based on it? This can help us understand the requirement better. 

Best Regards,
Community Support Team _ Jing