topic Re: Hello Guys, I have a question regarding date functions ? in App Development

Hello Guys, I have a question regarding date functions ?

Anonymous — Wed, 11 Oct 2017 14:26:22 GMT

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

Re: Hello Guys, I have a question regarding date functions ?

kaushiknsolanki — Wed, 11 Oct 2017 19:33:11 GMT

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

Re: Hello Guys, I have a question regarding date functions ?

Anonymous — Thu, 12 Oct 2017 12:56:27 GMT

Hello kaushik,

Thanks a lot . I got it

Regards,

Ravi