Forum Discussion
Trend Lines
AnonymousI just realized I was using the wrong column. [Week] is a text column because they wanted this week to literally read "This Week" instead of the date. I should be using a different column called [Week Of] which is the date-formatted column I thought I was using. Oops.
Incidentally, since I got that working I can confirm a couple of other things about trend lines:
1) table relationships aren't necessary. My x-axis is on a disconnected date table, not using standard time intelligence
2) measure complexity does not seem to impact trendline performance. I just added it to a chart with a Lovecraftian horror of a measure involving a double-nested CALCULATE inside a nasty triple-nested SUMX and two contradictory USERELASTIONSHIPs. The trend line popped up instantly. So it's obviously calculating on the result table only (like the thing you get when you hit See Data or Export to CVS). Which is nice.