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.
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.