neilprobst

Discussions

Identify percentile within a grouping
Hello all, I have a dataset with 3 columns: Parent Company, Child Company, and Total Sales. I was asked to identify the bottom 10% by rank of the child companies for each parent company and calculate the average total sales at that percentile. This discussion gives some insight on how to start. I used Rank and Window to…
Filter a table with aggregated rows on a dashboard with a filter card
Hello, I have table on a dashboard that is displaying aggregated rows based on on a larger data set. The table has two columns 'parent company' and 'spend', with spend being the sum of all spend at the parent company level. I want to add a range selector filter to the dashboard to filter the rows of the table based on the…