svetlana Member

@ST_-Superman-_ Thank you so much for including the screen shots, it's a great idea and gets the job done :)

Thank you @GrantSmith! It doesn't look like I have the option to return 3 rows in the filter section though, maybe it's somewhere else?

@mhouston I was just verifying that a few min ago - all identical. I think that it might be some other problem. Just got off a call with TSM and they couldn't figure out what's going on. We will try again tomorrow. Thank you!

Does your card display properly when editing your drill path? Yes Do you have any beast modes on your drill path card that would reference a column which no longer exists? No

Hi Grant, thank you for your reply! I just renamed both columns in both datasets to be the same (country & employee ID), yet when I try to drill down I get this: "An invalid column was specified in your request (the column does not exist on the dataset)" Do you have an idea why it's happening? (I refreshed both pages)

@GrantSmith thank you so much, such a great idea!

@GrantSmith and @MarkSnodgrass Thank you so much!!!

@GrantSmith ah I see what you're saying. The drill path itself shows all-time values, but if I click through the initial card - it does filter it by the date I set! I am happy that this turned out to be a non-issue :) Thanks a lot!!!

@GrantSmith thank you so much! Do you think that there is no other way to go about the category order? I would much rather keep the names as is.

@GrantSmith It won't let me for some reason (on other cards as well)

Mark, thank you SO MUCH! Worked like magic :)

I just tried adding back the columns by selecting "Add Columns" in the group by tile in ETL but I don't really see an option to do that (I can just add aggregated columns). I also tried using a separate tile ("Select Columns") but it only showed the two from the "Group By" tile. Any advice?

Thank you MichelleH! I need this as a variable to use in turnover calculations so I will use your advice to add back the columns :)

First of all, THANK you so much for the quick replies. The good news is that I think it worked! The bad news is that all of the other columns disappeared from the resulting dataset. How can I get them back??

I hope I can explain this well enough... The data is structured in a way that for the last day of each month I have ALL active employees in a form of a row per employee; for example, for Dec' 31st - I have 2690 rows [with employee IDs] which represent the 2690 active employees as of that date. The number will, of course,…

Thank you so much!