Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello:
I have thermometer chart using the following expression and I would like to make the "Finance*", Implementation, Confidence = {High} segment to be a light green and the third Sum to be Yellow. Is there a way to do that?
As always, thanks in advance for any and all help.
Got it.. It won't doable with QT Tube/Thermometer. Instead, I used 3rd Look and make some width reduce to get exact. But, Work around i got finally like below
Note - If applicable please mark it as helpful and flag correct answer which you satisfy the answer.
It would be better if you provide something? 2nd-green and 3rd-yellow then what about first one?
Hello Anil:
Thanks for the reply.
I understand your intend initial stage only. But, How we can offer without sample. If we can check something then it would be great to you and saves my time. To better, clear i believe you need 2 gradients at a time.
My apologies Anil. I think I get it now.
I would expect some QVW? Anyway, Try a luck
Pick(Match(Num(Sum({$<FB_Phase = {Booked}>}RangeMax([FB_Finance Confirmed 2017 Savings], 0)/1000000) + Sum({$<Phase = {'Finance*', Implementation}, Confidence = {High}>} [Estimated Save]) /1000000
+ Sum({$<Phase = {Concept, Design, Implementation}, Confidence = {Low, Med}>} [Estimated Save]) /1000000 ,'$###0'), '>$0','<$180.6', '>$180.6', '<$195.2', '>$195.2', '<$218.1'), DarkGreen(), DarkGreen(), LightGreen(), LightGreen(), Yellow(), Yellow())
Many thanks Anil, but it’s not my lucky night. I tried your expression and the thermometer disappears. I appreciate you trying without a lot of info. I’ll look into getting some sample data (QVW) tomorrow that I can post which would not compromise anything, and yet, give you enough info to try and find a solution (and I’ll keep trying as well). Thank you again.
You should write this as BG color? Are you?
By BG, I assume you mean RGB. That is the way I want to write it, but I’m not sure how to integrate the colors into the following expression to do so. The first Sum should be dark green. The second Sum should be light green and the third Sum should be yellow.
=Num(Sum({$}RangeMax(, 0)/1000000)
+ Sum({$<Phase = {'Finance*', Implementation}, Confidence = >} ) /1000000
+ Sum({$} ) /1000000 ,'$###0')
Expression seems wrong to me