how to: express values as a percentage 1

[cparisien]

Hi

i'm a newbie. I cant seem to figure out how to express my column values as a percentage in a chart.
IE: I have a bar graph that shows "Availibility" for a web monitor...column values are either a 0 or a 1. The monitor runs every 15 minutes. So for a 24 hour period the monitor runs 96 times.

How do I use the bar chart to express the value "96" as being 100% Available ?

thanks for any help.

 

[hilfy]

Try something like this:

sum({monitor field}) % 96

-D

 

[cparisien]

hey thanks for the info. I'd like to try this...problem is where do I build the formula? Right now I have a report with an embedded sub-report chart. If I right mouse click on the chart and click on "Format Subreport" I see various places that I can build a formula

which is, or where is the correct place for me to try the formula.

thanks

 

[lbass]

Build the formula in the formula editor of the subreport. If you create a formula {@percentavail} like the following, you will be able to display the % sign correctly in the chart:

sum({monitor.availability},{table.qtrhour})/sum({monitor.availability})

//where {monitor.availability is your 0 or 1 field and
//{table.qtrhour} is the fifteen minute period you are grouping on.

Then go into the chart expert->bar->advanced and add {table.qtrhour} as your "on change of" field and add {@percentavail} as the summary field. Then in preview, right click on the chart->chart analyzer->right click->format chart->grid->data axis tab->numbers->category->percent.

This should give you the display you are seeking.

-LB

 

[cparisien]

thanks much lbass.

one last question - i'm using CR 8.0.1.0 - I dont see any options for "Formula Editor" - what i do see if I right mouse click on the chart is a menu option called "Borders and Colors" - when I select this option, I see a window with many various formula editors (ie: top_line_editor, bottom_line_editor). This is what's confusing me....trying to figure out where to build the formula that applied to the whole graph.

any ideas??

 

[lbass]

In the main report, go to insert->formula field->new and enter the formula there. Then it will be available for use when creating the chart. If your layout is different than mine, what you are looking for is the field explorer->formula fields->new.

-LB