Graphs based off formulas

[_]

I have a report with several formulas in the Report Footer (example of one
below). I have been reading about graphs and I see that you can run graphs
based off of tables and/or queries. However, I want the graph to be based
off the results of the formula (below) in the report. Any suggestions on how
this would work (if it can)? Thanks!

=(Sum(IIf([Status]="win" And
[Region]="mountain",1,0)))/(Sum(Abs([Region]="mountain")))

 

[Duane Hookom]

Are you intending to graph only one value?

 

[_]

I have 4 formulas built in the report that I want to graph. Thanks.

Are you intending to graph only one value?

--
Duane Hookom
MS Access MVP
--

I have a report with several formulas in the Report Footer (example of one
below). I have been reading about graphs and I see that you can run
graphs
based off of tables and/or queries. However, I want the graph to be based
off the results of the formula (below) in the report. Any suggestions on
how
this would work (if it can)? Thanks!

=(Sum(IIf([Status]="win" And
[Region]="mountain",1,0)))/(Sum(Abs([Region]="mountain")))

 

[Duane Hookom]

And... I am expected to understand your 4 formulas and how they might be
displayed in a graph?

How about making an effort to provide fairly complete details on the data
you want to graph?

--
Duane Hookom
MS Access MVP
--

I have 4 formulas built in the report that I want to graph. Thanks.

Are you intending to graph only one value?

--
Duane Hookom
MS Access MVP
--

I have a report with several formulas in the Report Footer (example of
one
below). I have been reading about graphs and I see that you can run
graphs
based off of tables and/or queries. However, I want the graph to be
based
off the results of the formula (below) in the report. Any suggestions
on
how
this would work (if it can)? Thanks!

=(Sum(IIf([Status]="win" And
[Region]="mountain",1,0)))/(Sum(Abs([Region]="mountain")))

 

[_]

I was just curious how to get it to read the data. I'll start with the basic
graph I am trying to get and from there I probably can figure out the others
I'll need. Here in detail is what I want:

The reports pulls in and sorts by region and then sorts by wins, losses, and
in progress within each region. Then I have formulas (within the report)
that calculate the total # of wins, losses, etc. for each region.

First Graph - should have three bars as outlined below:
West - reads the formulas from the report to show all the wins, losses, in
progress for west
Central - reads the formulas from the report to show all the wins, losses,
in progress for central
East - reads the formulas from the report to show all the wins, losses, in
progress
Overall for east

Is this a better example to explain what I am trying to chart? Thanks in
advance!

And... I am expected to understand your 4 formulas and how they might be
displayed in a graph?

How about making an effort to provide fairly complete details on the data
you want to graph?

--
Duane Hookom
MS Access MVP
--

I have 4 formulas built in the report that I want to graph. Thanks.

Are you intending to graph only one value?

--
Duane Hookom
MS Access MVP
--

I have a report with several formulas in the Report Footer (example of
one
below). I have been reading about graphs and I see that you can run
graphs
based off of tables and/or queries. However, I want the graph to be
based
off the results of the formula (below) in the report. Any suggestions
on
how
this would work (if it can)? Thanks!

=(Sum(IIf([Status]="win" And
[Region]="mountain",1,0)))/(Sum(Abs([Region]="mountain")))

 

[Duane Hookom]

You must create a query that calculates wins, losses, etc by region. You can
then graph the query.

--
Duane Hookom
MS Access MVP

I was just curious how to get it to read the data. I'll start with the
basic
graph I am trying to get and from there I probably can figure out the
others
I'll need. Here in detail is what I want:

The reports pulls in and sorts by region and then sorts by wins, losses,
and
in progress within each region. Then I have formulas (within the report)
that calculate the total # of wins, losses, etc. for each region.

First Graph - should have three bars as outlined below:
West - reads the formulas from the report to show all the wins, losses, in
progress for west
Central - reads the formulas from the report to show all the wins, losses,
in progress for central
East - reads the formulas from the report to show all the wins, losses, in
progress
Overall for east

Is this a better example to explain what I am trying to chart? Thanks in
advance!

And... I am expected to understand your 4 formulas and how they might be
displayed in a graph?

How about making an effort to provide fairly complete details on the data
you want to graph?

--
Duane Hookom
MS Access MVP
--

I have 4 formulas built in the report that I want to graph. Thanks.

:

Are you intending to graph only one value?

--
Duane Hookom
MS Access MVP
--

I have a report with several formulas in the Report Footer (example
of
one
below). I have been reading about graphs and I see that you can run
graphs
based off of tables and/or queries. However, I want the graph to be
based
off the results of the formula (below) in the report. Any
suggestions
on
how
this would work (if it can)? Thanks!

=(Sum(IIf([Status]="win" And
[Region]="mountain",1,0)))/(Sum(Abs([Region]="mountain")))

 

[_]

Do you have any suggestions on where to go to read up on more advanced
queries? I know the basics and usually I just create reports with formulas
to calculate results. I have no idea how to begin this type of query or
whether it will have to be multiple queries. Obviously the formulas in my
report don't work when I try the query. Thanks!

You must create a query that calculates wins, losses, etc by region. You can
then graph the query.

--
Duane Hookom
MS Access MVP

I was just curious how to get it to read the data. I'll start with the
basic
graph I am trying to get and from there I probably can figure out the
others
I'll need. Here in detail is what I want:

The reports pulls in and sorts by region and then sorts by wins, losses,
and
in progress within each region. Then I have formulas (within the report)
that calculate the total # of wins, losses, etc. for each region.

First Graph - should have three bars as outlined below:
West - reads the formulas from the report to show all the wins, losses, in
progress for west
Central - reads the formulas from the report to show all the wins, losses,
in progress for central
East - reads the formulas from the report to show all the wins, losses, in
progress
Overall for east

Is this a better example to explain what I am trying to chart? Thanks in
advance!

And... I am expected to understand your 4 formulas and how they might be
displayed in a graph?

How about making an effort to provide fairly complete details on the data
you want to graph?

--
Duane Hookom
MS Access MVP
--

I have 4 formulas built in the report that I want to graph. Thanks.

:

Are you intending to graph only one value?

--
Duane Hookom
MS Access MVP
--

I have a report with several formulas in the Report Footer (example
of
one
below). I have been reading about graphs and I see that you can run
graphs
based off of tables and/or queries. However, I want the graph to be
based
off the results of the formula (below) in the report. Any
suggestions
on
how
this would work (if it can)? Thanks!

=(Sum(IIf([Status]="win" And
[Region]="mountain",1,0)))/(Sum(Abs([Region]="mountain")))

 

[Duane Hookom]

Start with a totals query like this:

SELECT Region, Sum(Abs(Status="win"))/Count(*) as PctWins
FROM tblResults
GROUP BY Region;

You will need to change the table name and possibly add columns as required.
We don't really know what you have for a table structure and what you want
your graph to display.

--
Duane Hookom
MS Access MVP

Do you have any suggestions on where to go to read up on more advanced
queries? I know the basics and usually I just create reports with
formulas
to calculate results. I have no idea how to begin this type of query or
whether it will have to be multiple queries. Obviously the formulas in my
report don't work when I try the query. Thanks!

You must create a query that calculates wins, losses, etc by region. You
can
then graph the query.

--
Duane Hookom
MS Access MVP

I was just curious how to get it to read the data. I'll start with the
basic
graph I am trying to get and from there I probably can figure out the
others
I'll need. Here in detail is what I want:

The reports pulls in and sorts by region and then sorts by wins,
losses,
and
in progress within each region. Then I have formulas (within the
report)
that calculate the total # of wins, losses, etc. for each region.

First Graph - should have three bars as outlined below:
West - reads the formulas from the report to show all the wins, losses,
in
progress for west
Central - reads the formulas from the report to show all the wins,
losses,
in progress for central
East - reads the formulas from the report to show all the wins, losses,
in
progress
Overall for east

Is this a better example to explain what I am trying to chart? Thanks
in
advance!

:

And... I am expected to understand your 4 formulas and how they might
be
displayed in a graph?

How about making an effort to provide fairly complete details on the
data
you want to graph?

--
Duane Hookom
MS Access MVP
--

I have 4 formulas built in the report that I want to graph. Thanks.

:

Are you intending to graph only one value?

--
Duane Hookom
MS Access MVP
--

I have a report with several formulas in the Report Footer
(example
of
one
below). I have been reading about graphs and I see that you can
run
graphs
based off of tables and/or queries. However, I want the graph to
be
based
off the results of the formula (below) in the report. Any
suggestions
on
how
this would work (if it can)? Thanks!

=(Sum(IIf([Status]="win" And
[Region]="mountain",1,0)))/(Sum(Abs([Region]="mountain")))