Survey banner
Switching to Dataiku - a new area to help users who are transitioning from other tools and diving into Dataiku! CHECK IT OUT

Core Designer Course| Request for feedback

Level 1
Core Designer Course| Request for feedback


I had a dataset with a column for country, a column with 5 different years x country and a column with some statistics. 

I wanted to: 

1) Rank each country for each year on that statistic 

2) Compute difference between the stat of yeach year compared to the previous year

What I did: 

1) Pivoted the df, so that I had one row per country and five columns for the value of the statistic for each year

2) I added 5 different Sort Recipe to the flow to add 5 columns with the rank of the country for each year (and here it comes the first feedback request, was there a faster way to obtain the rank on different columns?)

3) Added a Prepare Recipe with 4 formulas to compute 4 columns with change on that statistic from an year to the previous one (again, was there a faster way? At the beginning I tried to obtain this using row LagDiff in a Window Recipe before pivoting the data but then I got stuck on the ranking part) and canceled the columns with the stats. 

Thank you, any feedback is appreciated!

0 Kudos
1 Reply
Community Manager
Community Manager

Hi Beatrice, I've moved your post to the General Discussion board since I think you are more likely to find relevant help here.


I hope I helped! Do you Know that if I was Useful to you or Did something Outstanding you can Show your appreciation by giving me a KUDOS?

Looking for more resources to help you use DSS effectively and upskill your knowledge? Check out these great resources: Dataiku Academy | Documentation | Knowledge Base

A reply answered your question? Mark as ‘Accepted Solution’ to help others like you!


Labels (3)
A banner prompting to get Dataiku