Skip to Content
author's profile photo Former Member
Former Member

Triple Bar Chart Question

Hello SCN members,

I am new to design studio and I'm having a blast. I really love how much support there is within the community. I know this is a really rudimentary question; however, I am having a hard time figuring out how you might do a three axis bar chart.

What I want to do:

Second question is if I have all my current dates in 2013-01 type within my Business Objects universe is it possible to convert it somehow to Jan, Feb, Mar, and etc so I can create even a double axis bar chart. Only reason I am asking is because how my chart currently comes out is far from how I want it to look like.

What I currently have:

Again, thank you so much for your help and I look forward to talking with you guys soon. 😊

3axischart.PNG (19.4 kB)
chartdate.PNG (6.0 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Jul 10, 2015 at 04:04 PM

    On the first one, please try the Column Combination and select bars for each of your axis on properties - see below:


    wayne.jpg (64.5 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 10, 2015 at 04:16 PM

    Wayne - on the second question, can this be addressed back in the IDT instead of Design Studio? I am not a universe expert but it is always easier to do things in the back end first, if possible.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 11, 2015 at 03:26 AM

    Hi Wayne,

    To achieve the desired result, you need to model the back end universe accordingly, as Tammy has pointed out. Based on your Design Studio screenshot, my impression is that your universe has just one measure (Gross Trans.) and one dimension (combining year and month in YYYY-MM format). To clarify/confirm this it would be helpful if you shared a screenshot of the Design Studio Query Panel for your universe data source.

    I will describe two approaches just to give you a better understanding of how the back end modelling influences the end result. However, the first approach is the one that will achieve the requirement based on your first screenshot.

    Both approaches apply a chart type of Column and require the single YYYY-MM dimension to be split into two separate dimensions (fields). Also, if you would like to display the months as abbreviated texts such as "Jan", "Feb" etc., you will need to define two fields in your universe one for the month key ("01", "02" etc.) and another for the month text ("Jan", "Feb" etc.). The month key is required so the chart x-axis labels can be sorted in the correct order. It is not possible to convert the current YYYY-MM dimension to text label format (i.e. "Jan", "Feb" etc.) in Design Studio because there is no way to assign these changes to the chart since the data source is assigned directly to the chart.

    Please note that in my examples I have used the dimension Weekday instead of Month for illustrative purposes due to the data available in my system. However, the same principle will apply to a Month dimension.

    Approach 1 - One measure for each year

    Under this approach, the data source is modelled as follows:

    The chart properties are set like this:

    And the result is this (which corresponds to your requirement):

    Approach 2 - One measure only

    Under this approach, the data source is modelled as follows:

    The chart properties are set like this:

    And the result is this:

    Hope that helps,

    Mustafa.


    Chart1_DS.png (110.1 kB)
    Chart1.png (14.9 kB)
    Chart2DS.png (120.2 kB)
    Chart2.png (18.1 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.