Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Can we change the color of Pie chart on the basis of their relative percentage like if a field has a highest percentage should have fix color and so on.
My case is dynamic and highest percentage owner changes on different selection
Thanks
Manish Madan
Try with colormix function:
ex.
=colormix1("field name has value between 0 and 1", RGB(90, 240, 96), RGB(227, 34, 6))
Hi Mario,
I tried but i could not do so.
could you please try to implement,please find the attached .qvw !
try with colormix wizard and see the attached qvw.
could you please share exact condition which you wrote in colormix wizard and give me a brief of it.
look this
Hi Mario,
I might be taking more time of yours,apologies .could you please the exact condition which you wrote in wizard because background color definition is not at all easy to understand and when i tried to back track the original condition is showing nothing and asking for new.
=colormix1("field name has value between 0 and 1(....?.....)", RGB(90, 240, 96), RGB(227, 34, 6)).
Thanks in advance
Hi, Manish
Look here:
Colormix1(Value , ColorZero , ColorOne)
This function returns an RGB color representation from a two color gradient, based on a value between 0 and 1.
If value = 0 the first color is returned.
If value = 1 the second color is returned.
If 0 < value < 1 the appropriate intermediate shading is returned.
Value is a real number between 0 and 1.
So if you have calculated field which values are between 0 and 1 just put it inside, if you don't just use smth like this
sum(smth) / sum( TOTAL smth) = value between 0 and 1
Hope this helps
Andrei