Trend line in chart report
for trend line we have the report expression in cognos support (pdf)
((total(minimum([X]*[Y] for [X]) for report)-total(minimum(1 for [X]) for report)*
average(minimum([X] for [X]) for report)*average(total([Y] for [X]) for report))*[X]
+ (average(total([Y] for [X]) for report)*total(minimum([X]*[X] for [X]) for report)
-average(minimum([X] for [X]) for report)*total(minimum([X]*[Y] for [X]) for report)
))/(total(minimum([X]*[X] for [X]) for report)-total(minimum(1 for [X]) for report)
*average( minimum([X] for [X]) for report )*average( minimum([X] for [X]) for report ))
that is working for some chart reports
my question is I have measure sales amount and on X-Axis I've Year
while trying with the above expression the sales amount is showing wrong
please share your ideas about trend line for the graph
Thanks
Hi Johny,
it's a long time ago, but: Have you found a solution?
Regards, Rainer