Charting On Running Totals

[Adam_Alsop]

Does anyone know of a work-around to be able to create a chart based on a Running Total? (ex True/False condition counts)

Thanks!

[Former Member · Accepted solution]

Could you please explain your situation in more detail? What are the characteristics of the chart you are looking for?

Carl

[Adam_Alsop · Accepted solution]

I have a Detail line conditional Running Total that compares two fields to return a True/False value - I would like to be able to do a Pie Chart for the True/False totals, and also do a Bar Chart for the totals by Group (which is by a Date field).

[Former Member · Accepted solution]

I can't say I'm a charting expert, but I think you can do this with two formula fields (basic syntax):

' {@TrueFalse}:
if <condition> then
  formula = "true"
else
  formula = "false"
end if

' {@TFCount}:
if {@TrueFalse} = "true" then
  formula = 1
else
  formula = 0
end if

Then build your graphs over these two fields. In the Show Values pane, put Sum of {@TFCount}. In the On Change Of pane, put {@TrueFalse} (and your group field for the bar chart).

HTH,

Carl