cancel
Showing results for 
Search instead for 
Did you mean: 

Charting On Running Totals

adam_alsop2
Participant
0 Kudos

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!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Carl

adam_alsop2
Participant
0 Kudos

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
0 Kudos

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

Answers (0)