mstorne Member

I tried to make a new dataset but output shows ammount of next year into last year field instead of last year amount. Confused! 

I already have made this one, but we would like to have one bar for each year and one line showing % change between current and previous year. That's why I am trying to find a solution for this. Thank you very much for your help, Marko.

I am trying to get Premium of every single row where Type is certain year. Of course, let me send you example. Thank you, Marko.

Good morning Valiant, I am trying to implement the code you sent me into my function. First I made this: CASE WHEN `Type` = 'Current' THEN YEAR(CURDATE()) WHEN `Type` = 'Previous_Yr' THEN YEAR(DATE_ADD(CURDATE(), INTERVAL - 1 YEAR)) WHEN `Type` = '2_Yrs_Ago' THEN YEAR(DATE_ADD(CURDATE(), INTERVAL - 2 YEAR)) WHEN `Type` =…

I am having the same problem. I couldn't find solution. I want to show one line with the percent change for each year. Thank you in advance! 

Hi everybody, thank you for your help. I finally get it done. I tried to join Converted dataset (ValiantSpur gave me an advice) with Zips2Fips through ETL, which didn't work. I tried Blend, and it worked. I don't know what is the problem with ETL, anyways, I got what I needed. Thank you, Marko.

Here is my outpu. Thank you.

Unfortunately doesn't work!

I don't know why I am not able to convert AcctZipCode to WholeNumber. 

I already tried to convert string from my ODBC to whole number but I keep receiving an error "Failed to convert data 94563 to type integer for column AcctZipCode". Thank you for your help.

I am matching ZIP_STRING field since I can't use ZIP, it says they are different data types. Here is a screenshot. Thank you.

Thank you very much, this was exactly what I was looking for!

Hi Scott, Thank you for your response. I understand what are you talking, but I don't know how to make it out. I used REPLACE before but changing the value of the column. Could you please help mi how to write the functoin to change the column name from `sales` to `drill_sales`? Thank you in advance.