mrc logo mrc logo
  • m-Power m-Power
    What is m-Power?
    Overview Demos Build Process Case Studies Specs Pricing Trial
    m-Power Resources
    Overview How-To Videos Webinars & Podcasts White Papers Fact Sheets
  • Solutions Solutions
    What does m-Power build?
    Overview Database Front-Ends Reporting CRM Systems Business Intelligence Dashboards Inventory Management Mobile Apps ERP Enhancements Modernization Spreadsheets to the web MS Access to the web B2B/Web Portals Scheduling Embedded Analytics Web Forms Workflow Data Exploration Budgeting & Forecasting APIs and Web Services Db2 Web Query Alternative
    Solutions by Industry
    Overview Manufacturing Government Foodservice Software Vendors Logistics & Supply Chain Software Consultants Healthcare
  • Services Services
    Development Services Training Mentoring
  • About About
    Overview Partners Press Releases Careers Events Contact Blog
  • Support Support
    Support Home FAQ Documentation Customer Portal Enhancements Updates Roadmap Techblog
Try m-Power

m-Power Manual

Browse:

  • Home
  • Graphs
  • Creating a Line Graph with a Static “Goal Line”
Back to Manual

Creating Line Graphs with a Static "Goal Line"

 

Often times when creating a Line Graph, you will have a need to create a "Goal Line" (or Reference Line) that will serve as a constant horizontal line to track if you have met a certain goal. Setting this up with a Report with Graph is very straightforward. In the following example, I am going to print a set of users Credit Limit, and compare that with a static "Target" goal.

Below, you can see I plan on graphing the Credit Limit Field (CRLIM).

However, I need to create a target goal; this can easily be done with a calculation. I will set my calculation to $15,000.

As you can see, I have simply set a calculation equal to 15000.

After I build my application, I must go into m-Painter. The first thing I will do is remove the calculation column. Since this will only be used in the graph logic, it does not need to be present in my output table. Simply right-click on the column, and select "Delete Column".

Next, I will need to modify the Graph Properties. To do this, right-click on the graph, and select "Graph Properties".

The first thing that we will need to do is select the "Multiple Line" graph on the "Line" tab.

Then, select the "Credit Limit in Dollars" and "Credit Limit Target" fields on the "Fields" tab.

Next, on the "Levels" tab, we need to change the level to the "Detail Level", not the "Grand Total Level". This is necessary because we need to have data for each individual customer, not just the grand total.

Before we finish, we need to make one more slight change. Click the "Options" tab and then select the "Chart and Plot" section. Set the "Show X Axis Item Values?" value to "No".

This change will clean up the graph quite a bit, as it will not try to write the value for each customer on the line, making the graph illegible.

Click "OK".

Click the "Save" icon, and then run your application.

Your output should look something like this:

Created: April 11, 2008 | Modified: June 12, 2017

Search


Browse By Category

Build Process (13)
Starting with m-Power (8)
Retrievals (10)
Reports (15)
Summaries (4)
Maintainers (17)
Graphs (8)
m-Power Data Explorer (4)
General (24)
Calculations (5)
Utilities (9)
m-Power Administration (23)
Security (11)
Freemarker (6)
m-Painter (29)
Form Validation (5)
External Objects & UDFs (12)
Deprecated Documentation (23)
Bootstrap Templates (7)

Popular Tags

Java Getting Started SQL Dropdowns Build Process Bootstrap Templates Parameters Graph Properties External Objects Popular DB2 Database Record Selections Advanced Reports Maintainers Prompt Screens m-Painter Production Security App Properties Bar Graphs Form Validation Dates Summaries Compiling Tomcat Data Dictionary Email RPG Administration Graphs Freemarker Maintainer Calculations mrc-Productivity Series Video Retrieval Retrievals Excel Application Properties Admin Graphing Performance Report

See all tags »

michaels, ross & cole, ltd. (mrc)

Privacy Policy Cookie Policy Cookie Settings Notice at Collection Do Not Sell or Share My Personal Information

mrc (US)

2001 Midwest Road
Suite 310
Oak Brook, IL 60523
630-916-0662

mrc (UK)

Mortlake Business Centre
20 Mortlake High Street
London, SW14 8JN
+44-20-335-59566


© 2024 mrc. All rights reserved.