how to calculate % 1 to 30 days and 31 to 60 days and so on

[#1]

Hi Friends,

i have a Query , need to Calculate rate of interest for 1- 30 days

and 31 to 60 days

and 61 -180 days and

181 to 360 days

360+ days .

need to calculate on  my column name is tot_cust  Expression column.

appreciated you if elaborated  in detail manor it is urgent. i am waiting for your replay.

Regards,

Siva.

[varshavig12]

Can you provide us with sample data ?

[jonathandienst]

If you would like detailed and specific help, then you need to supply a small representative sample qvw. It need not contain any sensitive information (scramble or exclude fields), but it must contain the structure and some sample data to work with.

Preparing examples for Upload - Reduction and Data Scrambling

[Anil_Babu_Samineni]

If you have date field, Then you may convert like below

Date Format is DD-MM-YYYY

Load *, Date(Date, 'DD/MM/YYYY') as Date, Year(Date) as Year Inline [

Date, tot_cust

01-01-1889, 1

........

07-11-2016, 10

];

Then Create Funnel Chert Object Like Below to show the Buckets / Interaction Match

Dimension is

If(Day(Date) >= '1' and Day(Date) <= '30', Dual(1, '1 - 30 Days'),

If(Day(Date) >= '31' and Day(Date) <= '60', Dual(2, '31 - 60 Days'),

If(Day(Date) >= '61' and Day(Date) <= '180', Dual(3, '61 - 180 Days'),

If(Day(Date) >= '181' and Day(Date) <= '360', Dual(4, '181 to 360 Days'),

If(Day(Date) >= '360', Dual(5, '360+ Days'))))))

Then Use This Expression

Sum({<Year = {"$(=Max(Year))"}, Day, >} TOTAL <

If(Day(Date) >= '1' and Day(Date) <= '30', Dual(1, '1 - 30 Days'),

If(Day(Date) >= '31' and Day(Date) <= '60', Dual(2, '31 - 60 Days'),

If(Day(Date) >= '61' and Day(Date) <= '180', Dual(3, '61 - 180 Days'),

If(Day(Date) >= '181' and Day(Date) <= '360', Dual(4, '181 to 360 Days'),

If(Day(Date) >= '360', Dual(5, '360+ Days'))))))

> tot_cust)

Or Else, You would read Jonathan Link. How to Upload Sample with scramble Data.

[Anonymous]

Hi Siva,

Create one dimension in your script level as following

If(Day(Date) >= '1' and Day(Date) <= '30', Dual(1, '1 - 30 Days'),

If(Day(Date) >= '31' and Day(Date) <= '60', Dual(2, '31 - 60 Days'),

If(Day(Date) >= '61' and Day(Date) <= '180', Dual(3, '61 - 180 Days'),

If(Day(Date) >= '181' and Day(Date) <= '360', Dual(4, '181 to 360 Days'),

If(Day(Date) >= '360', Dual(5, '360+ Days')))))) as Days Interval

and now use this dimension in your pivot table and in expression put sum(tot_cust) for your desired outcome.

Thanks,