Net revenue retention
I am trying to calculate a net rev retention from X month to Y month (typically 1 months prior). This calc would compare revenue from all the accounts that paid us in X month to what those same accounts paid us in subsequent months. In the example below, the sum of the months would only campare accounts A,B, and C since D and E are new logos. the bar chart would only display A,B,C accounts but would show the sum trend for the following months. I need a filter or something that says "If account was invoiced in Jan, only display those on the bar chart" but display all the susequent months not just the Jan data. How would i do this in Beast mode?
CASE WHEN MONTH(`InvoiceDate` ) = 9 THEN 'true' else 'false' END
but this only shows Sep data on the bar chart