1 Reply Latest reply: Sep 16, 2010 7:52 AM by pmielone RSS

    How to make Trend indicator by traffic lights

    pmielone

      I have a dataset that contains "Datestamp", "Unit" and "Value" columns. I need to make a indicator by using traffic lights showing if trend has been down, equal or up during last 2 weeks (14 days). I tried to start by looking help for linest_m but that with no result.

      Any ideas how make this? All help is appreciated.

        • How to make Trend indicator by traffic lights
          pmielone

          After studying the case further I found solution. I made a chart-pivot table where Used Dimension is "Unit". In Expression I made "Trendlight" expression and definition as =linest_m(aggr(sum(Value),Unit,Datestamp),Datestamp) . Then I selected Representation "Traffic Light" where I set the limits. This made the work.