How can i create a chart in Sense that has the sum(value), latest Tdate and Age(Latest Tdate - Now())?
Use below code in script n then try
Max(Tdate) as Latest_Tdate,
Sum(Value) as Value,
Age(today(),max(Tdate)) as Age
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
could you please post a screenshot of your expected result?
May be this
Is this what you need
Retrieving data ...