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"