Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I have the following graph:
Each point represent a business case.
What I need is, in the same graph, show if each case is either Won or Lost while at the same time seeing which Sales Region it is from, is that posible? Would be better disposicion of the points stay the same.
I thought of doing something like triangles are Won and Squares are Lost, something like this (did this image in Paint):
Do you think it's feasible? Or if there's some other way?
I'm attaching some mock info to mirror this in order to see how my data loos like.
Thanks!
Accepted Solutions
One "hacky" way to solve for the square vs triangle is to use ASCII replacements for Won and Lost as seen below (and also in the QVW attached to original reply.).
If he changes the symbol for Region to a dot and changes Won to a triangle and Lost to a Square, you get the below. I also applied red/green color logic as an additional visualization call out and added a Text in Chart key for the additional symbols... but who knows how that will react on an access point deployment.
Hi,
like this? how u wanted to show that legent ? (mean u need to show sales region instead of status?)
Dimension:
Case#
[Sales Region]
Measure:
Won
sum({$<[Case Status]={"Won"}>} [Final Price])
Lost
sum({$<[Case Status]={"Lost"}>} [Final Price])
