Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I basically have a column in my data sheet which has all Dates in the format of (MM/DD/YY) . I need to segregate years such as 2014, 2015, 2016... so on and I need to display related values under these years . How I do extract these dates ? And what chart or expression I should be using in order to do it . I need something like this to represent .
2014 | 2015 | 2016 |
---|---|---|
x values | y values | z values |
Hi,
Assuming you are getting the Date and the Values i.e (XYZ) from same table, you should try below script and expressions.
Script:
Load *,Year(Date) as Year
From xyz;
Now on frontend create a pivot table and add Column as year and Sum("Valuefield") (Name of the field which has the value) as expression.
Regards,
Kaushik Solanki
Hello kaushik,
Thanks a lot . I got it
Regards,
Ravi