We are trying to explore TREND statistical function on a client dataset. We have Invoice_Date as a field in the database using which "Year Start Date" is calculated using Date Hierarchy and Date Part Formatter. Invoice_Amount is another field available from the source. Data is available for 5 consecutive years from 2010 to 2014. We want to project (predict) for 3 additional periods 2015 to 2017 using Trend (double exponential smoothing) function.
Using Ski Team dataset, we are able to generate a similar report using Year dimension and Invoiced Amount. Output is showing up correctly. However the same step doesn't seem to be working with our dataset (on SQL Server) and additional years with projected values are not getting added to the report output. Are there any date field pre-requisites? Please suggest how to go about.
Very sorry for the delays in looking at your Forum Post.
What version and build of Yellowfin were you trying the Trend function through?
Hope to hear from you soon,
I am using the latest version/build.