Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Is this what you need
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;
I am not able to access the source thus i cant do it from load statement.
what chart type you are planning to use ?
Just a table
May be this
Is this what you need
could you please post a screenshot of your expected result?