Skip to Content
avatar image
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 comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    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 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.