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

Author Topic: Trend line in chart report  (Read 5639 times)

johny.cbi

  • Guest
Trend line in chart report
« on: 29 Feb 2008 07:50:23 am »
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

Offline RainerF

  • Associate
  • **
  • Join Date: May 2020
  • Posts: 2
  • Forum Citizenship: +0/-0
Re: Trend line in chart report
« Reply #1 on: 17 Feb 2023 04:36:47 am »
Hi Johny,

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

Regards, Rainer