Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have combo chart in my dashboard that contains columns and line
The dimension is date and the measures are number of jobs and utilization.
I want to paint the column (utilization measure) in red when job defined as Error (completion status field) , in any other cases I want to paint the column in blue.
But I want to paint the line in yellow at any time ( not based on completion status) .
So I wrote the below script, but it paints both of the measure indications :
if([Completion Status] = 'ERROR',rgb(237,140,154) ,rgb(150,194,237))
There is any way to do it ?
Thanks
Hi,
Can you share sample data.
Regards,
Kaushik Solanki
You can create the same scenario with sample data and share.
Regards,
Kaushik Solanki
Hi
The data is:
Machine ID | Date | Utilization | Status | Batch Numebr |
A | 8/7/2017 | 55.9% | SUCCESS | 33176589 |
A | 8/7/2017 | 0.4% | SUCCESS | 33176581 |
A | 8/7/2017 | 0.4% | SUCCESS | 33176605 |
A | 8/8/2017 | 100.0% | SUCCESS | 33176589 |
A | 8/9/2017 | 46.1% | ERROR | 33162548 |
A | 8/9/2017 | 42.7% | SUCCESS | 33176589 |
A | 8/10/2017 | 83.2% | ERROR | 33162548 |
A | 8/11/2017 | 64.9% | SUCCESS | 33177816 |
A | 8/11/2017 | 25.3% | ERROR | 33162548 |
A | 8/12/2017 | 100.0% | SUCCESS | 33177816 |
A | 8/13/2017 | 33.9% | SUCCESS | 33177816 |
A | 8/13/2017 | 31.2% | SUCCESS | 33151192 |
A | 8/14/2017 | 98.9% | SUCCESS | 33151192 |
A | 8/15/2017 | 67.2% | SUCCESS | 33148007 |
Thanks
Can you share screenshot of your current chart.
Also let us know what expression you have used for both the measures.
Regards,
Kaushik Solanki
My measure expression is OK and no problem found in the expression.
My question is how can I change the line color? You can see the line color change accordingly to the bar color.
The color expression that I created mentioned in my first post.
I guess you can't have different color by expression for both measures.
HI,
You should create the line expression as master measure and then assign the color of your choice to it.
Regards,
Kaushik Solanki