Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
Is there a solution for the following? I'd like to represent the growth rate in a line chart, with 2 dimensions:
one being "year" and one being "campus.name". In the syntax below, the above function is referencing the dimension "campus.name" instead of year, and I can't change the sorting. You can see it in the graph: there's only 3 campus names, because it uses one for reference, but this isn't right
(count({<Doctor={Y},[ExaminationType.Abbrev]={B}>} SubsampleID)/Above(count(total <[Subsample.CreatedDateTime.autoCalendar.Year], [Campus.Name]> {<Doctor={Y},[ExaminationType.Abbrev]={B}>} SubsampleID)) - 1) * 100
does anyone have a solution/answer?
I noticed in a bar chart this is possible