2 Replies Latest reply: Jun 9, 2017 1:33 PM by Todd Buss RSS

    set analysis with RGB table

    Todd Buss

      In an expression color code field that chooses a color from a table, I want to pick the color value that corresponds with the latest record.

      I was thinking I need to use set analysis, but don't really need aggregation.  I tried using max, avg, etc with this set:

       

      max({$<ReportDate={"$(=max(ReportDate))"}>}[Multi Bunk Status Color])

       

      I think the problem is that RGB values (strings) can't be aggregated.  Here's what's loaded into [Multi Bunk Status Color]...

       

      [Multi Bunk Status Table]:

      load * Inline

      ["Multi Bunk Status","Multi Bunk Status Color"

      '1VACANT','RGB(153,255,51)'

      '2VACANT','RGB(255,255,51)'

      '4VACANT','RGB(255,0,0)'

      '1FILLED','RGB(76,153,0)'

      '2FILLED','RGB(153,153,0)'

      '4FILLED','rgb(153,0,0)'

      ];

       

      Thanks.