
Re: Barchart  show measure of measure as (100%) bar And determin Color.
Bill Markham Sep 20, 2017 6:53 AM (in response to Daniel Sørensen)If I am understanding you correctly maybe something like this
Measure 1 :
 1  ( sum(numberEG) / ( sum(numberEG) + Sum(numberEG30Day) ) )
Measure 2 :
 1  ( Sum(numberEG30Day) / ( sum(numberEG) + Sum(numberEG30Day) ) )

Re: Barchart  show measure of measure as (100%) bar And determin Color.
Daniel Sørensen Sep 20, 2017 7:27 AM (in response to Bill Markham )Hi
That looked like that did the job...
I do not know why it suddently changed to 100% from the formular you used.
But nevertherless it worked.
Do you also know how to.
I would like if sum(numberEG) is color #0A2864 and Sum(numberEG30Day) is color #E63F0C

Re: Barchart  show measure of measure as (100%) bar And determin Color.
pradosh thakur Sep 20, 2017 7:43 AM (in response to Daniel Sørensen)set the back ground color of the expression by clicking expression> back ground color then set the color u want to for the expression .. in your case you need to set the color for measure 1 and measure 2.

Re: Barchart  show measure of measure as (100%) bar And determin Color.
Daniel Sørensen Sep 20, 2017 12:24 PM (in response to pradosh thakur)Pretty new at this, so correct me if I am wrong...
I converter my hex to arbg color.
ColorMix1((1+Sign(2*(sum(numberEG)  sum(numberLMC)RangeMin (top(total sum(numberEG)  sum(numberLMC),1,NoOfRows(total))))/(RangeMax (top(total sum(numberEG)  sum(numberLMC),1,NoOfRows(total)))RangeMin (top(total sum(numberEG)  sum(numberLMC),1,NoOfRows(total))))1)*Sqrt(Fabs((2*(sum(numberEG)  sum(numberLMC)RangeMin (top(total sum(numberEG)  sum(numberLMC),1,NoOfRows(total))))/(RangeMax (top(total sum(numberEG)  sum(numberLMC),1,NoOfRows(total)))RangeMin (top(total sum(numberEG)  sum(numberLMC),1,NoOfRows(total))))1))))/2,ARGB(240, 140, 109, 1),argb(34,34,34,1))
And this was this was the result..
Would it be sossible so that the

