Have you ever needed to remove duplicate rows in a data set? Well me neither, but an unnamed PM asked me to do it one night long ago and I am finally getting to publishing how. The Setup I have some survey data (totally fake) and in the data there are duplicate rows with oneContinue reading “Remove Duplicates in a Data Set”
Category Archives: Functions
Show the Latest Data
Sometimes you need to just show the latest data. This is often the case for metrics like inventory or some percentages where adding things up just does not make sense. Most analytic tools like Oracle Analytics allows authors to pick from various aggregation methods as a solution, but when building a project you don’t alwaysContinue reading “Show the Latest Data”