Julianna_Potter

Discussions

What's the best practice way to remove data from a partitioned dataset?
We have an ETL set up to a partitioned output. Now that we are far enough into 2024 I'm being told that we can reduce the size of this dataset by removing all 2022 data from it. What would be the best way to go about doing this?
Pivot Table for Text instead of Values
I'd like to request an option for a pivot table to contain text instead of values. This way I can have a rank 1-10 as the rows, weeks as the columns and the name as the values and then I can watch how the values shift in rank over the weeks. I.e. week 1, Person A was ranked 10, then they bumped up to rank 5 the next week,…

What's the best practice way to remove data from a partitioned dataset?
We have an ETL set up to a partitioned output. Now that we are far enough into 2024 I'm being told that we can reduce the size of this dataset by removing all 2022 data from it. What would be the best way to go about doing this?
Pivot Table for Text instead of Values
I'd like to request an option for a pivot table to contain text instead of values. This way I can have a rank 1-10 as the rows, weeks as the columns and the name as the values and then I can watch how the values shift in rank over the weeks. I.e. week 1, Person A was ranked 10, then they bumped up to rank 5 the next week,…