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

formula in Bar graph not coming

Hi

I am not able to show formula in graph as it is not coming in the Available Field List of chart expert.

My req is like, I have the No of TTs and the TTR value for each TT.

According to my req. I have created 2 running total fields Sum of TTRs and Count of TTs.

In graph I have to show the Sum of TTRs / No of TTs. For this I have created the formula. My values are coming fine in report. But this formula I am not getting in chart.

Pls let me know why this is not coming in chart expert.

Pls help.

Thanks

Sunny

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 19, 2008 at 10:16 AM

    Hi Sunny

    Drag the running total fields on to the report and then see if you get the running total fields in available fields of the chart.

    If you have groups in your report, place the running total fields on to the group footer. Insert a subsection for the group footer and insert the chart on this.

    You should be able to get the running total fields in the available fields list of the chart now.

    Hope this helps!!!

    Regards

    Sourashree

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 19, 2008 at 11:06 AM

    Hi Sourashree,

    Thanks for your support.

    But my problem is not for the running total fields. It is coming in the graph.

    Actually I have created to Running Total fileds, one gives the count of TTs and another gives the Sum of TTR.

    Now, I have created formula which calculate Sum/Count. This gives me the exact value which I need to populate in graph. But my problem is I am not getting this formula in the field list.

    Is there any way to display the formula this in the graph?

    Pls suggest..

    Thanks

    Sunny

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Sunny

      Place the formula field on to the report and then try inserting the chart. You should get the formula field in the available fields list of the chart.

      Hope this helps!!!

      Regards

      Sourashree

  • author's profile photo Former Member
    Former Member
    Posted on Sep 19, 2008 at 12:02 PM

    Hi Hi Sourashree,

    I have placed the formula in the Group Footer. Thats why I am getting the correct value but I am not able to see that formula in the graph.

    I am sending you the code written in formula.

    StringVar ActualMTTRvalue;

    StringVar array SplittedMTTRValue;

    StringVar MTTRHrs;

    StringVar MTTRMins;

    NumberVar MTTR := {#SA Sum of TTR for MTTR}/{#SA Count of TTs for MTTR};

    ActualMTTRvalue := toText(MTTR/60);

    SplittedMTTRValue := split(ActualMTTRvalue,".");

    MTTRHrs := SplittedMTTRValue[1];

    MTTRMins := toText(MTTR mod 60);

    SplittedMTTRValue := split(MTTRMins,".");

    if SplittedMTTRValue[1] <> "0" then

    MTTRMins := MTTRHrs + " : " + SplittedMTTRValue[1] + " Min"

    else

    MTTRHrs := MTTRHrs + " Hrs"

    Pls help.

    Thanks,

    Sunny

    Add a comment
    10|10000 characters needed characters exceeded

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.