I'm working on a beast of a report. Basically it takes a list of orders and then it assigns a reason based off the attributes that are pulled from all over the place. I put everything in a Straight table and calculated the "Detail" column with an expression. Now I would like to be able to chart those reasons listed in the "Detail" column and I have no idea if its possible. I'd like to be able to count how many orders have each reason assigned. Any ideas??
this is a very simplified version of the report:
The Detail is set by a formula that looks like "if(attribute1=red and attribute 2 = 3 then detail = Reason 1 else if….Reason 2…."