Line chart mit two dimensions and 'total'

schmidtj — Fri, 21 Jan 2022 11:08:52 GMT

Hi,

i have a line chart with a kpi which calculates a percentage (accumulated):
Sum(x) / Sum(total y)

The chart has 2 dimensions:
- on the x-axis there is a month dimension
- the second dimension is 'Category' and is supposed to show a separated line in the chart accordingly

My problem is the following:
I want the 'total' in my formula only to apply to the first dimension (months).
So the sum of y is supposed to be over all the months.
However i want it not to be over all Categories.

Is there a way how to achieve this?

Re: Line chart mit two dimensions and 'total'

schmidtj — Fri, 21 Jan 2022 12:20:33 GMT

Ok i found the solution:
Sum(total <...> y)

topic Re: Line chart mit two dimensions and 'total' in App Development

Line chart mit two dimensions and 'total'

Re: Line chart mit two dimensions and 'total'