find the age

[bhagi]

Hi all,

pod	Mydate	amount
A	1-Nov-2016	100
A	1-Nov-2017	200
A	1-Nov-2018	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(amount), latest mydate and Age(Latest mydatedate - Now())?

thanks

bhagi

[Chanty4u]

you want this in script or front end?

Use below code in script n then try

Load Prod,

Max(MyDate) as  Newdate,

Sum(Amount) as Value,

Age(today(),max(Mydate)) as Age

From Source

Group by  Prod;

or

in stright table:

avg(today(),dte(max(mydate)))