Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)))