Trend lines in graphs report component
Hi all, Referring to an old post: "Advanced" graphical content in dashboards. In a graph (created using the report component) I would like to add a trend line. Please see the picture below for clar...
Forum Discussion
I guess the "orthodox" way to address this in a Report component is via calculated fields, but there isn't a function for it, you'll have to build it from primitives. If you prefer to do it in VB, you would have to create a DataCell Function in Finance Business Rules, then add a column to the Cube View that uses that function.
However, if you know that you could build your chart with an Excel function in an easier manner, you could instead work with the Spreadsheet component and create your chart there. Spreadsheets can be embedded in Dashboards, and from there into Books.
JackLacava wrote:However, if you know that you could build your chart with an Excel function in an easier manner, you could instead work with the Spreadsheet component and create your chart there. Spreadsheets can be embedded in Dashboards, and from there into Books.
Hi Jack, from there how to plot the regression line? There is no option to do that.
Thanks
You still have to calculate the values, but it should be easier because the included statistical functions (for example LINEST ) are superior to what you can find in Reports' calculated fields.