Is there a best way when using Last Period. To do one of 2 things 1. Show rows in a table that existed a period ago but not now 2. Show rows that are new in the current time For instance Filter to Today and Last Period was 30 Days Ago Today Deal Row 1: A Row 2: B Row 3: D 30 Days Ago Row1: B Row2: C What I want is a table that has New Deals Row Deal Row1: A Row2: D And One that has Lost Deals Lost Deals Row1: C

Hi Doug, you can compare the periods directly in Analytical Designer - As highlighted in my screenshot below. Or you can set this same logic directly in the metrics and the following documentation will help you with that: https://www.gooddata.com/docs/cloud/create-metrics/maql/time/functions-for-referring-to-past-time-periods/ https://help.gooddata.com/classic/en/dashboards-and-insights/maql-analytical-query-language/maql-use-cases-and-tutorials/time-over-time-comparison-in-reports/

@Michael Ullock Yes I know how to do that part but is there a trick to get the exact rows I need. Thats the tricky part. I don't really want the difference i want the rows that are different (aka existed in one time period and not the other). I tried to be as clear as possible in my example

Hi Doug, in this case I think the best approach here would be add this logic into 2 separate metrics - You would specify the New Deal and Lost Deal logic into the Time over Time Comparison metrics mentioned in the previous documentation I provided - As I am not sure what your data is like and how you’re specifying this, I would suggest you review the IF / CASE WHEN calculated metrics documentation and build your metrics accordingly: https://www.gooddata.com/docs/cloud/create-metrics/maql/conditionals/case/ https://www.gooddata.com/docs/cloud/create-metrics/maql/conditionals/if-then-else/

Hey @Michael Ullock I gave the logic in the original post. Its most exactly that. I do know the information you sent already