topic Re: coloring lines in chart in App Development

coloring lines in chart

jtay — Sat, 16 Nov 2024 09:38:14 GMT

I have a chart that shows a count by month with overlapping years.

I've been asked to specify the line color by year.

2015 = blue

2016 = yellow

2017 = red

I've been trying to color by dimension and by expression but I'm missing something.

This color by expression gives me yellow for all lines:

if(Year(Date)='2015'

,blue()

,if(Year(Date)='2016'

,yellow()

,red()

)

If I don't try and specify anything, and color by dimension using =Year(Date) then this is what the chart looks like.

I could use a little help. thanks.

Vasiliy_Beshentsev — Wed, 14 Jun 2017 11:42:27 GMT

Can you please provide soma part of your app, so then i will help you.

jtay — Thu, 15 Jun 2017 14:00:19 GMT

I had this just about right... my problem was with taking a derivative of a field in the if statement.

I added Year(Date) as ydate to the load script and got this working correctly.

if(ydate='2015' ,blue(),

if(ydate='2016' ,'#f0e68c','#ff0000'))

Vasiliy_Beshentsev — Thu, 15 Jun 2017 14:19:33 GMT

Well good. Mark some post as helpful if you got yuor solution.