If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Trend line in chart report

Started by johny.cbi, 29 Feb 2008 07:50:23 AM

Previous topic - Next topic

johny.cbi

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

RainerF

Hi Johny,

it's a long time ago, but: Have you found a solution?

Regards, Rainer