add manual target line

Afidah

Hi,

Now i have stacked bar. How I can add target line month to month and every month is ddifferent target.

ST_Superman

If there is any calculation to it, you could potentially create the target line with a beast mode.  Otherwise you would need to add the target values to your data set and then you could use a bullet, line and grouped, symbol and grouped, etc. chart type to display it.

Afidah

Is the any sample how to write code in beast mode.
Sample:-
Target Set
Jan - 100
Feb - 200
Mar - 300

ST_Superman

Case when `month`=‘Jan’ then 100

when `month`=‘Feb’ then 200

when `month`=‘Mar’ then 300

end

 

however, you should replace ‘Jan’ with whatever your dataset has