Conditional expressions in charts

[#1]

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