I have installed the latest Design Studio 1.2 and was excited to see quite a lot of additions being made in this minor release. However i am facing an issue with Column-Combination Dual axis chart. Please share some insight into how i can resolve this.
I am displaying the below 4 measures in my Column-Combination dual axis chart. Below are my data ranges
1.Sales Actual year : Values range between 100k and 150k
2.Sales Previous year : Values range between 100k and 150k
3.Target Sales : Values range between 100k and 150k
4.% of Sales : Values range between 40% and 50%.
But the Column Combination Dual axis chart doesn't give me an option to make "% of sales" as second axis and the other 3 Sales measures as my first axis. it also does not give me an option to make my first 2 measures as columns and next two measures as lines. I want my Sales Actual Year and Sales Previous Year to be columns(first axis), Target Sales to be a line (first axis) and % of Sales to be a line( second axis).
Can someone help me with this? Thanks. Please let me know in case you need any further information