Forum Discussion
Sort a sum measure based on multiple categories
I have a data set of a bunch of entries of production for different manufacturing equipment (resources). When looking at just the downtime, there are multiple entries for each day (individual entries for every occurance) that are labled by their downtime code (indicating the cause of downtime).
I currently have a measure (Tot_DT = sum(Downtime)) that simply sums the total downtime, and with different visuals I can plot / table the downtime to show all aggreate broken out the different codes / resources.
What I am trying to create is a visual table that lists each resource with the single highest downtime attributer and the downtime value. This would then be drilled down by month/week/day/shift.
I have tried a quickmeasure to calculate the "Max per category" using basevalue (Sum of Downtime) and category DowntimeCode, but in a table visual i still get multiple entries for each resource.
Any help or advice would be much appreciated. Below is a simplified version of the data I'm working with.
| Resource | Downtime code | Downtime |
| A | 1 | 1 |
| B | 2 | 1 |
| A | 1 | 1 |
| A | 3 | 2 |
| C | 1 | 1 |
| B | 2 | 2 |
| C | 3 | 1 |
| A | 3 | 1 |
| A | 1 | 2 |
| C | 2 | 3 |
| B | 1 | 1 |
| C | 1 | 2 |
| B | 3 | 2 |
| C | 1 | 3 |
| A | 2 | 2 |
| B | 3 | 1 |
| A | 1 | 2 |
| B | 2 | 2 |
| C | 1 | 1 |
| A | 3 | 1 |
| B | 3 | 2 |
1 Reply
You may check if the following thread helps.
