I've added Trend lines to historical sales, but I'd like to add some kind of visual cue indicating and up or down trend. So all I need is a calculated field that can determine that. Is this possible?
Thanks!
I strongly suspect that the problem has to do with how the FIXED LOD, date aggregation, and the granularity of the data interact when the data has a finer granularity than the date aggregation.
For example, in Superstore Sales {FIXED [Order Date] : (aggregation)} can return a very different result from {FIXED [Year of Order Date]) : (aggregation)}. In this view, Year of OD is DATETRUNC('year',[Order Date]) and we can see that the FIXED Order Date is returning a different value for every order date while the FIXED Year is returning one value for each year:
The workaround for this is to first get the date dimension to be at the right level of aggregation and then apply the float, like float(month([Order Date])}.
Jonathan
