color lines in line chart

[ali_hijazi]

hello got a line chart displaying the number of defects per release

some defects are detected after the release date and thus will have a release name ending with PR

check attached image

what i want is that v3.1.27 and v3.1.27-PR have the same color and so on

i.e. every release ending with PR needs to have the same color as the same release name without PR

please advise and check the attached image

[m_woolf]

Something like this in the Background Color area:

Color(num(mid(ReleaseName,6,2))-26)

[m_woolf]

or maybe:

Color(num(left(subfield(ReleaseName,'.',2),2))-26)

[#4]

Simple replace in your calculated dimension instead of RELEASE_PHASE  should work.  eg: replace(RELEASE_PHASE,'_PR','')