Now i have stacked bar. How I can add target line month to month and every month is ddifferent target.
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.
Is the any sample how to write code in beast mode.Sample:-Target SetJan - 100Feb - 200Mar - 300
Case when `month`=‘Jan’ then 100
when `month`=‘Feb’ then 200
when `month`=‘Mar’ then 300
however, you should replace ‘Jan’ with whatever your dataset has