CR Charts

[Cyked]

I'm trying to add charts to some reports. The data being worked with is in our change tool and I am grouping by change "type").

Right now the report is for a single team and the changes they submitted for a single month. I'm looking at changes that were a certain "type" (e.g. informational, standard, emergency, etc...) and if they were successful. I have group summaries for each group (again I'm grouping by "type" of change.

So for example there were a total of 10 emergency changes for the month. Say 8 were successful, 1 was unsuccessful, and one was canceled. Since canceled changes are never done I don't want to count them. So I want my percentage of successful changes to be 8 out of 9, not 8 out of 10.

I have a running total of changes that were NOT canceled that reset "on change of group". This will give me the total number of changes for each "type" group that are anything but canceled. I also have a running total of changes that are successful.

Now that I have those totals setup I want to say give me the percentage of successful changes.....
{#number of success changes} % {#number of changes that were not canceled}

This gives me the correct percentage. But when I go into chart expert and look at the data tab to set "Show Values" to my formula which finds the correct % it isn't in the list. I can use my summary % from the group footer but that will give a percentage of ALL changes, not all changes minus canceled.

Why does my formula no show in the list of fields to be used in the chart?

 

[lbass]

Why not eliminate the canceled records in your selection formula?

-LB

 

[Cyked]

Is the select query statement? Ideally I want to not do that found total count of changes. I think I have an idea though. Is it not showing up because instead of the output being 80% it's 80.00?

 

[lbass]

Ideally I want to not do that found total count of changes.

What does this mean?

-LB

 

[Cyked]

lol, sorry. It means I can't type.

If I leave in canceled changes I can show all changes they opened. Though really they may only want to see changes they actually implemented. I'll take it out for now.

I still need to know why my {@success_rate} formula doesn't show as an available field in chart expert. This is really the issue I have. Not if I count canceled changes or not.

 

[lbass]

I think it is because you are using running totals in the calculation. Would you get the same results for each type if you used conditional formulas like this?

if {table.result} = "Successful" then 1

if {table.result} <> "Cancelled" then 1

If so, you could write a formula like this:

sum({@successful},{table.group})%sum({@notcancelled},{table.group})

I think this would be available to chart on (didn't test though).

-LB

 

[Cyked]

It does show up. I had to screw around for a bit getting it to display the correct data.

Thanks!