I have a line chart with two dimensions and one expression.
Say dimension 1 (x-axis) is a timeline and dimension 2 is my product. When selecting three products i get a line chart with 3 lines, one line for each value in 'Product' and a line showing aggregated sales pr. week.
So far so good - but I need to manually change the layers of the lines, since they overlap sometimes and i need a certain product to be on the top layer.
The line layers depend on the sort order of your second dimension, with the first value on the bottom, and the last value on the top. If you need to precisely control which product goes in which layer, you could use a sort expression, but I'd suggest loading your products in the desired order and sorting by load order.
The line layers depend on the sort order of your second dimension, with the first value on the bottom, and the last value on the top. If you need to precisely control which product goes in which layer, you could use a sort expression, but I'd suggest loading your products in the desired order and sorting by load order.
