2 Replies Latest reply: Jul 19, 2016 4:39 PM by Gary Palush RSS

    Need help with coloring expression for line graph

    Gary Palush

      I have a line graph with two dimensions X Axis - (Date), Line - (Business) and an expression the Y-Axis is (Count of Widgets).

       

      I use set analysis in the expression so that no matter what Business or Date is selected the chart shows all values.

       

      Expression (Named: Number of Widgets):

      =sum({<Business=,Date=>}Count_of_Widgets)

       

      Date has three values

      1/1/2016, 2/1/2016,3/1/2016

       

      Business has three values for each Date,

      R, G, B

       

       

      DateBusinessCount of Widgets
      1/1/2016R1
      1/1/2016B2
      1/1/2016G3
      2/1/2016R4
      2/1/2016B5
      2/1/2016G6
      3/1/2016R7
      3/1/2016B8
      3/1/2016B9

       

       

      When coloring the Expression, I have a different color for every business (R= Red, B=Blue,, G=Green) using the RGB logic The expression I use is:

      IF(Business='R', RGB(255,0,0)

      IF(Business='G',RGB(0,255,0)

      IF(Business='B',RGB(0,0,255)

      RGB(230,230,230)))

       

      I want to be able to keep the coloring even if there is a selection on the Date field. But as of right now with the selection of a date, the other dates are shown as grey. Please note the image below does not match exactly the example above, it is a more complex version but the concept holds true..

       

      Capture.JPG

       

      Any help would be greatly appreciated. And as an FYI, I only have a personal edition so I cannot open other people's QVWs.