Problems in the creation of a graph

[AnaFlor]

Hello,

I'm having some problems in creating a graph. The problems are:

- I have two metrics in a line graph. The attributes that I have is the month and the state.
I want that for metric 1 I can see the value for each state and the total for each month of all states. For metric 2 I just want to see for each month the total of all the states.
For each line of the graph I want it to have a different simbol and color (e.g. line 1 red with circles and line 2 yellow and with stars).

Can you help me solving this?

Thanks

 

[nlim]

as someone posted before, help us help you. Tell us
- what is on the x-axis of graph
- what is on the y-axis of graph
- definition of metrics 1 and 2.

We will assume that your report has month and state on it.

 

[AnaFlor]

in my x axis I have the month
in my y axis I have the value of metric 1 and 2 (metric 1 is the expected value and metric 2 the real value).

I want a line for each state for metric 2 and just one line with the total for all the states in metric 1.

In each line I want a different symbol

Can you help me?

 

[entaroadun]

Try setting up metric 1 to not group by state. That way, metric 1 returns the same value, the total of all states, in each state.

Then, if you plot the two metrics, the lines for each of the states for metric 1 should overlap and cancel each other out.

Give it a shot. In any case, take some time to experiment and learn the fundamentals of the graphing engine.

 

[AnaFlor]

But I don't want the total of all states in each state.

I just one a line with the totals.

In metric 2 I want one line for each state and a line with the total

 

[AnaFlor]

For example I want to appear the following:

Jan 04 Feb 04 Mar 04
Total 3 4 3
Metric 1 State1 1 2 2
State 2 2 2 1

Metric 2 Total 3 4 1


How can I say that I only want to see the values for the states for metric 1?

Thanks

 

[entaroadun]

Per my suggestion above, change the dimensionality on metric 2 so it looks like this:

                     Jan 04   Feb 04   Mar 04
Metric 1   State 1        1        2        2
           State 2        2        2        1
Metric 2   State 1        3        4        1
           State 2        3        4        1

See how metric 2 has the total for all states listed within each state? This way, when you graph metric 2, the lines for State 1 and State 2 will overlap, creating the illusion of 1 line.

Many ways to skin a cat... Play...

 

[AnaFlor]

I'm sorry but I didn't understand very well.

Can you explain me a little more please?
Thanks

 

[entaroadun]

Which part should I explain? Is it the method for getting Metric 2 to generate the values in my example above? Or the method for graphing the values after you get them calculated?

 

[AnaFlor]

both please, if you don't mind

sorry