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?