Hi all,
Is there any way I can create a multiple colored line chart based on certain thresholds?
Lets say I want a blue line for most of the time, but when the line chart is >=100, then I want the colour of the line to be red - when the value then goes below 100, I want the line to return to being blue.
Is this possible?
Thanks,
Q
Hi @QSCommUser
You can do something like this. I used dates to show the line change clearly with this sample data, but you can easily use sum({your_field}) > 100.
You chart the regular line, then create as many additional color lines as you need, using calc fields that are NULL when your conditions are not met.
ifelse({Order Date}<'2016-05-01',Profit,null)
Hi @QSCommUser,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post or were you able to find a work around?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you!
Hi @Brett
Thanks for following up. This can be closed.
This response was helpful, but not exactly what i was looking as there was a need to plot three separate values.
What I was hoping for was functionality which allowed me to plot different colours using some conditional formatting - similar to how you would assign icons, colours to a pivot table / table etc.
Regards,
Q
Hi @QSCommUser,
Oh I understand; setting up conditional formatting on lines is currently not an available feature but that would be a nice addition so I’ll mark this as a feature request!
