Sum and age on latest transaction

[mogaka1234]

Customer	Tdate	Value
A	1-Nov-2015	150
A	1-Nov-2016	200
A	1-Nov-2017	100
A	1-Oct-2017	80
B	24-Dec-2012	30011
B	24-Dec-2015	22
B	24-Dec-2014	28
C	16-Sep-2013	34
C	17-Sep-2013	12

How can i create a chart in Sense that has the sum(value), latest Tdate and Age(Latest Tdate - Now())?

Please assist.

[shraddha_g]

Use below code in script n then try

Load Customer,

Max(Tdate) as Latest_Tdate,

Sum(Value) as Value,

Age(today(),max(Tdate)) as Age

From Source

Group by Customer;

[mogaka1234]

I am not able to access the source thus i cant do it from load statement.

[agigliotti]

what chart type you are planning to use ?

[mogaka1234]

Just a table

[antoniotiman]

May be this

[Quy_Nguyen · Accepted solution]

Is this what you need

[agigliotti]

could you please post a screenshot of your expected result?