Hi
i have got stuck on a chart were i want to build a pie chart that aslo can be used for drilldown analysis. data is from a production process.
ID ( is a uniq product individual)
ProcessStep what part of the production the temperature measurement have been done.
i need a piechart based on a specific Processstep ( ie 2), there the pie´s should be represented on temperature intervalls [A=0-35, B=36-70,C=71-200]
on this dashboard i also have a table that should list som details about the individuals that is included if you click on A for instance.
there for i can not use a simple count distinct.
could any one advise?
| ID | ProcessStep | Temperature |
|---|
| 10555 | 2 | 80 |
| 10555 | 3 | 54 |
| 10666 | 2 | 65 |
| 10666 | 3 | 35 |
| 10654 | 3 | 70 |
| | |
