total in staright table

[#1]

Hi i have the below data

id        identiy     date                 time                  

1.         1          Jan 1, 2016      0.02201673        

2.         3         Jan 1, 2016       0.01105705        

3.         27       Jan 1, 2016      0.02656042          

4.         1         Jan 1, 2016      0.26666667        

5.       175       Jan 1, 2016      0.51282051         

6.       144       Jan 1, 2016      10                       

and my output should be like this

date	new_column
Jan 1, 2016	459.234

the new_column formula is   for every row it should calculate  (identiy * time* 0.3 )

and sum up every row  to get the  new_column  output

Regards

[antoniotiman]

Hi John,

may be

Temp:

LOAD * From Table;

Left Join
Load date,Sum(identity*time*0.3) as new_column
Resident Temp
Group By date;

or

Load date,Sum(identity*time*0.3) as new_column

Resident Temp

Group By date;

Drop Table Temp;

Regards,

Antonio

[#3]

Hi Antonio, can we do it in set analysis, i'm worried if some of the filters wont work if i do a calcul;ation in the back end.

[antoniotiman · Accepted solution]

Script

Load * from Table;

Chart:

Dimension : Date

Expression : Sum(identity*time*0.3)

[#5]

Thank you so much Antonio