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

Total vs Detail Trend line Graph in Design Studio

Hi DS gurus,

I'm using Design Studio 1.2 version and have a requirement to show/compare a trendline graph of total values w.r.t detail values of different category. Here are the attached my Trendline graph and Data sets.

This is how the requirmenet goes

1) I have a drop down of various categories like Vendor, Equipement, Material (refer dataset attachment)

2) The trendline graph needs to compare total values (of all categories) w.r.t a selected category (value from drop down). refer the graph attachment.

3) I have only one measure in my data set. I want to display that as two different data points in the trendline graph(one for Total and one for the selected category).

When I select a value from the downdown, the total also changes accordingly. I like to keep the total values unchanged when I select a category. Is there any way we can do that in DS ?

It's easy in WebI, where we can create a variable measure for a the selected category and we can use the total and the variable in the graph as two measures.

Please let me know if you have further question.


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Dec 30, 2014 at 05:09 PM

    Hello Saubhagya,

    that should be possible with the setDataSelection option in the script or using the DataSelection option in the properties - depending on what you would like to do.

    here is a script - I don't have Design Studio running right now, so no 100% guarantee.

    Lets say you have a crosstab and a chart and you would select the two rows in the crosstab.

    on the onSelect event for the crosstab you could add something like this:


    ChartSelection = ChartSelection + CROSSTAB.getSelectedMember(<Your item here>).internalKey + "|";

    var FinalSelection = ChartSelection.split("|");


    "<Your item here>": FinalSelection




    Ingo Hilgefort

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member


      In regards with Design studio, you should make it in a single datasource. I am not sure how to do it in Universe level though.

      One more option would be to overlap two charts, but it will be very difficult to do.


      Fazith Ali Z.

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.