Skip to Content
author's profile photo Former Member
Former Member

Comination Graph that had Day Range and MTD calc per day.

Hi,

I am having trouble figuring out how to do a Combination Graph.

For example, the user enters 12/22/04

BW Query has folowing columns:

Date Eff % Eff % MTD Eff %

-


-


-


-


12/1/2004 100% 100%

12/2/2004 99% 99.7%

...

12/22/2004 96% 98.7%

Please note the % have to be calculate for each MTD. That is not a simple average.

That Graph has a Bar for each day and a second axis that is a line for the MTD figure.

Please help

Scott

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 26, 2005 at 08:32 AM

    Hello Scott

    same has other response, use hidden KF. Use also 'cumulated' option if the bex.

    Date hit total % cumulatedhit cumulatedtotal %

    20040101 50 50 100 50 50 100

    20040102 100 90 90 150 140 93

    for the chart it is possible to have the first serie a column, second serie as a line.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      The 'cumulated' as to be used in the key figures used to calculate the %. In the example above, the flag has to be on cumulatedhit and cumulatedtotal. The % is cumulatedhit percentage of cumulatedtotal.

      If you have another question please tell me more about your key figures Eff... so it would be easier to communicate.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.