growth rate per year

[Quentinn]

Hi everyone,

These are my variables:

- conditions/ set expression: Doctor = 'N' AND [ExaminationType.Abbrev] = 'B' 

- count (subsampleid)

- dimension: [CreatedDateTime.autoCalendar.Year]

- second dimension: campus.name

My goal is to formulate a syntax which does the following:

Give me a growth rate (% evolution positive or negative compared to the previous year) of the count of subsampleid per campus (second dimension) compared to count of subsampleid of that campus of the previous year. 

So for example: campus SV: 2019: count 100k, 2020 count 90k, growth rate -10%

Thanks in advance!

[Quentinn]

so essentially the picture below but in growth rate/evolution is % per campus

[vinieme12]

pplease post some sample data