on 12-16-2015 10:10 AM
I am trying to use the new Scorecard in DS 1.6 with a UNX source.
I have 2 columns, 'Desk' and 'Count', for example:
Desk | Count |
---|---|
A | 5 |
B | 6 |
C | 9 |
D | 3 |
E | 7 |
I want to conditionally format the count column with:
Green is <4
Amber is 4 to 7
Red is >7
But I am not sure how to accomplish this.
I see the Cell Background section and I select to Bind it and se Binding Type as 'Conditional Format Value' but from there I am lost.
Anyone got any ideas?
Thank you
Nick
Hi Nick,
Scorecard is not introducing any calculation engine for such checks, the conditional binding can be used for direct match between venues for example if you have a value to you can match it to some image path. For any kind of calculations you need to make it on your data source, you can use for this analysis office for specification of conditional formatting or you can use bex exceptions.
hope this helps you.
karol
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nicholas,
the "conditional binding" in scorecard does not support it, but the "conditional formatting" do support calculations. on BW source you can make it in BEx Query (BEx exception) and in case of UNX currently you need to make it in Analysis Office and use smart copy of the data source to DS. In the roadmap of DS there is also support of the conditional formatting in DS designer, but not yet available in 1.6.
Karol
Nick:
Did you see Karol's answer here? Scorecard Object in Design Studio 1.6 issue wit... | SCN
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nick - thank you for the screen shot
The left red arrow - you should click the drop down - that should help select the binding for the cell - the tool tip says "Open cell selection dialog"
The values 1-9 are the typical conditional formatting conditions - to be honest, I haven't tried it with the scorecard component, but I would imagine they are similar as follows:
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.