Skip to Content

Step-by-Step to define a Scorecard with Comparison Chart visualization.

This time, the example can be made offline as I will use the Bring your own Data Source from Mike (included in SCN Design Studio SDK Development Community).

1. We start with data source and empty scorecard:

d1.PNG

d2.PNG

2. After assigning to scorecard and generating initial scorecard.

d3.PNG

3. Initial scorecard is very basic, only the dimension and first measure is displayed.

the goal is to create a visualization which compares year 1960 and 2010.

4. we will insert a column with comparison chart manually

d5.PNG

What is changed?

– add new column

– change template to “Comparison Chart, Delta Bar”

– change Column Size to make it bigger

– set some header text

5. Define the “Actual Value” and “Benchmark Value”

d4.PNG

d7.PNG

6. the effect is…

d11.PNG

7. now, only adjustments in maximum and minimum are required

d12.PNG

8.  and the chart will change

d13.PNG

9. of course, the scale is too small for some values which are bigger than max value.


10. you can also add suffix for value, e.g.

d14.PNG

11. and also remove decimal places

d16.PNG


Example

I have exported the data source to CSV and the example is available here.

applications/SCN_SCORECARD_STEP_1-20160418205436.zip

You can find the scorecard definition together with used data source.

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Alexander Knight

    Hi Karol,

    I am trying to configure the scorecard with a simple comparison bar chart as you have above (Query calls in my data).  However I do not know the max value, and this can change depending on the filters applied.  How can I configure this so that it automatically sets all the lines to the correct Max, like in a normal bar chart?

    Thanks

    Alex

    Capture.PNG

    (0) 

Leave a Reply