I have a data modell like this:
direction values here: in or out
amount: values here numbers
date: values here ...
I would like to make an accumulated line chart (succeeded) which represents the incomes and expenses, and colored the two line with an expression (not succeeded).
Color and legend / Colors by expression: if(direction='in',lightred(),lightgreen()).
Please help me how can I set up the colors with expression for the lines.
qvf, pic and data are attached.