Visualization - Create Bar chart actual vs target
Need help to create this chart in thoughtspot.
We have fruits dimension (Apple, Mango, Orange) and have different target value (Apple=22%, Mango=39% and Orange=77%)
In the chart will display 12 months of actual value of fruits vs the target. If there is multiple year then the bar chart color will different.
Would you need to create three separate formulas; Apple target, Mango target and Orange target? The formula would be similar to this, maybe:
Apple target: if ( fruit = 'Apple' ) then 0.22 else null
Mango target: if ( fruit = 'Mango' ) then 0.39 else null
Orange target: if ( fruit = 'Orange' ) then 0.77 else null
I guess that if you have the chart showing correctly by ordering the x-axis by fruit then date, you should get three separate lines.