growth rate per year

Quentinn — Thu, 12 May 2022 13:46:08 GMT

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!

Re: growth rate per year

Quentinn — Thu, 12 May 2022 13:47:33 GMT

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

Re: growth rate per year

vinieme12 — Fri, 13 May 2022 08:42:08 GMT

pplease post some sample data

topic growth rate per year in App Development

growth rate per year

Re: growth rate per year

Re: growth rate per year