Archives of the TeradataForum

Message Posted: Tue, 17 May 2016 @ 19:04:32 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Got a approach

To get below mentioned calculation part

     Month Count Calculation((cur_count-prev_count)/prev_count*100)

     Jan 10 Null
     Feb 20 100
     Mar 15 -25
     Apr 25 66.7
     Jun 28 12
     July 33 17.8

I suppose we could use, some thing similar to below mentioned formula

     ((count-Max(count) over (order by Month rows between 1 preceding and 1
     preceding))/Max(count) over (order by Month rows between 1 preceding and 1
     preceding))*100

Posting if it can be of use to any one out there. Any way our Modelling team has suggested to do such metric calculation in Qlick view.

Thank you,

Shravan kumar. M
IBM Inc.

	<Prev	Next>		<<First	<Prev	Next>	Last>>