Difference between revisions of "Graph"

From LiveDC Wiki!
Jump to navigation Jump to search
m (Khackenmiller moved page Create Graph to Graph)
 
(15 intermediate revisions by 3 users not shown)
Line 1: Line 1:
A Graph within LiveDC is used to show historical changes in your data. Fed by specified Data Series, a Graph will provide valuable insight into trends and expectations around what to expect in the case of an outage, disruption, and the future.
+
__TOC__
  
 
==Creating a Graph==
 
==Creating a Graph==
 +
A graph within LiveDC is used to show historical changes in your data. Fed by specified data series, a graph will provide valuable insight into data center trends to help you make informed decisions and be proactive in the case of an outage, disruption, and future requirements.
 +
 +
===Instructions===
 
<ol>
 
<ol>
 
   <li>On the navigation menu (left-hand side) click “Visuals” and then “Graphs” this will open a new tab titled “Graphs”</li>
 
   <li>On the navigation menu (left-hand side) click “Visuals” and then “Graphs” this will open a new tab titled “Graphs”</li>
   <li>Within the Graphs tab, in the upper left-hand corner click the “Create” button. A new window will open up called “Create Graph”</li>
+
   <li>Within the graphs tab (upper left-hand corner) click the “Create” button. A new window will open up called “Create Graph.”</li>
 
     <ol type="a">
 
     <ol type="a">
       <li>Enter the name of the Graph in the “Name” field</li>
+
       <li>Enter the name of the graph in the “Name” field</li>
 
         <ol type="i">
 
         <ol type="i">
 
           <li>Examples: Server Changes, Temperatures (Hot Aisles), UPS Capacity, etc.</li>
 
           <li>Examples: Server Changes, Temperatures (Hot Aisles), UPS Capacity, etc.</li>
 
         </ol>
 
         </ol>
       <li>Enter any additional information about the Graph in the “Details” field</li>
+
       <li>Enter any additional information about the graph in the “Details” field</li>
       <li>Enter a title in the “Title” field that be displayed when the Graph is generated</li>
+
       <li>Enter a title in the “Title” field to be displayed when the graph is generated</li>
       <li>Enter a label for the X-axis in the “Axis Label” field</li>
+
       <li>Enter a label for the X-axis in the “Axis Label” field</li>
 
         <ol type="i">
 
         <ol type="i">
 
           <li>Examples: Temperature (F), kW, Month, etc.</li>
 
           <li>Examples: Temperature (F), kW, Month, etc.</li>
 
         </ol>
 
         </ol>
       <li>Select a size for the Graph in the “Size” drop-down menu</li>
+
       <li>Select a size for the graph in the “Size” drop-down menu</li>
 
         <ol type="i">
 
         <ol type="i">
           <li>Small, Medium, or Large - this will determine the detail and resolution of the graph when displayed</li>
+
           <li>Small, medium, or large - this will determine the detail and resolution of the graph when displayed</li>
 
         </ol>
 
         </ol>
       <li>Define a time period for the Graph to display in the “Time Period” section</li>
+
       <li>Define a time period for the graph to display in the “Time Period” section</li>
 
         <ol type="i">
 
         <ol type="i">
 
           <li>We usually look over the last month or last 3 months (previous quarter)</li>
 
           <li>We usually look over the last month or last 3 months (previous quarter)</li>
 
         </ol>
 
         </ol>
       <li>Add Lines to the Graph by clicking on the star button to create a new “Graph Line” record. In the “Create Graph Line” window enter the following:</li>
+
       <li>Add lines to the graph by clicking on the star button to create a new “Graph Line” record. In the “Create Graph Line” window enter the following:</li>
 
         <ol type="i">
 
         <ol type="i">
           <li>Enter the name of the Line in the “Name” field</li>
+
           <li>Enter the name of the line in the “Name” field</li>
 
             <ol type="A">
 
             <ol type="A">
 
               <li>Examples: Physical Servers, Average Temperature, Historical Power, etc.</li>
 
               <li>Examples: Physical Servers, Average Temperature, Historical Power, etc.</li>
 
             </ol>
 
             </ol>
           <li>Enter a name for the legend of this Line in the “Legend Label” field</li>
+
           <li>Enter a name for the legend of this line in the “Legend Label” field</li>
 
             <ol type="A">
 
             <ol type="A">
 
               <li>Examples: Historical, Max Temp, Physical Servers, etc.</li>
 
               <li>Examples: Historical, Max Temp, Physical Servers, etc.</li>
               <li>This label will appear at the bottom of the graph along with the color of the line it is representing</li>
+
               <li>This label will appear at the bottom of the graph, along with the color of the line it is representing</li>
 
             </ol>
 
             </ol>
           <li>Select a color for the Graph Line in the “Color” section</li>
+
           <li>Select a color for the graph line in the “Color” section</li>
           <li>Select the “Data Series” that will provide the data for the Graph Line in the drop-down menu or create a new “Data Series” record by clicking the star button (See “Creating a Data Series” section for instructions)</li>
+
           <li>Select the “Data Series” that will provide the data for the graph line in the drop-down menu or create a new “Data Series” record by clicking the star button (see [[Create a Data Series#Creating a Data Series|Creating a Data Series]] section for instructions)</li>
 
+
[[File:Graph-Line.png]]
        </ol>
+
           <li>Add a future line to show how the graph line could change in the future by clicking the star button to create a new “Futures” record. In the “Create Graph Line Future” window, enter the following:</li>
 
 
 
 
 
 
 
 
 
 
 
 
           <li>Enter any additional information about the LiveTile in the “Details” field</li>
 
          <li>Enter the title of the LiveTile in the “Title” field</li>
 
 
             <ol type="A">
 
             <ol type="A">
               <li>Examples: Power Summary, Temperature Summary, etc.</li>
+
               <li>Enter the name of the graph line future in the “Name” field</li>
               <li>The title is what is displayed in the image as shown below</li>
+
              <ol type="1">
 +
                <li>Example: 2.5%, 5%, 10%, etc.</li>
 +
              </ol>
 +
              <li>Enter a label for the legend in the “Legend Label” field</li>
 +
              <ol type="1">
 +
                <li>Example: 2.5%, 5%, 10%, etc.</li>  
 +
               </ol>
 +
              <li>Define the period of time the graph will extend into the future in the “Time Period” section</li>
 +
              <ol type="1">
 +
                <li>Example: 24 months</li>
 +
              </ol>
 +
              <li>Enter the “Number Per Period” identifier which outlined how many times you want to provide a value each month as outlined in section 3 above.</li>
 +
              <ol type="1">
 +
                <li>Example: 1 is the standard value here</li>
 +
              </ol>
 +
              <li>Enter a formula for the future graph line in the “Formula” field</li>
 +
              <ol type="1">
 +
                <li>See image below for syntax: prev*1.004166 refers to a 5% growth rate for the year, broken down to the monthly increase</li>  
 +
              </ol>
 +
              <li>Define a color for the future graph line in the “Color” field</li>
 +
              <li>Click “Add”</li>
 +
[[File:Graph-Line-Future.png]]
 
             </ol>
 
             </ol>
           <li>Enter the subtitle of the LiveTile in the “Subtitle” field</li>
+
           <li>Click “Add” on the “Create Graph Line” window</li>
            <ol type="A">
 
              <li>Examples: Room Name</li>
 
              <li>The subtitle is what is displayed below the title</li>
 
            </ol>
 
          <li>Select a Time to Live for the LiveTile in the “Time to Live” drop-down menu or create a new “Time to Live” record by clicking on the star button (See “Creating a Data Series” section for instructions)</li>
 
[[File:COG.png]]
 
          <li>Enter an amount of time before the LiveTile will refresh itself in the “Refresh Time Period” section</li>
 
          <li>We typically set the refresh time to 1 hour as the values within the LiveTile are usually set to a 15 minute refresh time</li>
 
 
         </ol>
 
         </ol>
       <li>Enter the following information under the “Scale” tab</li>
+
       <li>Click “Create” on the “Create Graph” window</li>
 +
      <li>You now have a graph that will continue to update automatically and always be available for a real-time view in LiveDC</li>
 +
    </ol>
 +
</ol>
 +
<br />
 +
 
 +
==Creating a Graph Line==
 +
===Instructions===
 +
<ol>
 +
  <li>Enter the following information In the “Create Graph Line” window </li>
 +
    <ol type="a">
 +
      <li>Enter the name of the Line in the “Name” field</li>
 
         <ol type="i">
 
         <ol type="i">
           <li>Select the maximum amount to define in the LiveTile in the “Scale Max” drop-down menu or create a new “Scale Max” record by clicking the star button (See “Creating a Data Series” section for instructions)</li>
+
           <li>Examples: Physical Servers, Average Temperature, Historical Power, etc.</li>
[[File:COG-Scale-Max.png]]
 
          <li>Select the Number Format for which the maximum amount desired to be displayed, in the “Format Override for Max” drop-down menu or create a new “Format Override for Max” record by clicking the star button (See “Creating a Number Format Template” section for instructions)</li>
 
          <li>Select the built amount to define in the LiveTile in the “Scale Built” drop-down menu or create a new “Scale Built” record by clicking the star button (See “Creating a Data Series” section for instructions)</li>
 
[[File:COG-Scale-Built.png]]
 
          <li>Select the current amount to be shown in the LiveTile in the “Scale Current” drop-down menu or create a new “Scale Current” record by clicking the star button (See “Creating a Data Series” section for instructions)</li>
 
[[File:COG-Scale-Current.png]]
 
          <li>Select the minimum amount to be shown in the LiveTile in the “Scale Min” drop-down menu or create a new “Scale Min” record by clicking the star button (See “Creating a Data Series” section for instructions)</li>
 
[[File:COG-Scale-Min.png]]
 
          <li>Select the Number Format for which the minimum amount desired to be displayed, in the “Format Override for Min” drop-down menu or create a new “Format Override for Min” record by clicking the star button (See “Creating a Number Format Template” section for instructions)</li>
 
 
         </ol>
 
         </ol>
       <li>Enter the following information under the “Notes” tab</li>
+
       <li>Enter a name for the legend of this Line in the “Legend Label” field</li>
 
         <ol type="i">
 
         <ol type="i">
           <li>Add notes to the LiveTile that will be visually displayed in the “Main Notes” section by selecting from the drop down menu and clicking the left-hand facing arrow or create a new “Main Notes” record by clicking the star button (See “Creating a Data Series” section for instructions)</li>
+
           <li>Examples: Historical, Max Temp, Physical Servers, etc.</li>
           <li>Add foot notes to the LiveTile that will be visually displayed in the “Foot Notes” section by selecting from the drop down menu and clicking the left-hand facing arrow or create a new “Foot Notes” record by clicking the star button (See “Creating a Data Series” section for instructions)</li>
+
           <li>This will appear in the bottom of the graph window</li>
 
         </ol>
 
         </ol>
       <li>Enter the following information under the “Values” tab</li>
+
       <li>Select a color for the Graph Line in the “Color” section</li>
 +
      <li>Select the “Data Series” that will provide the data for the Graph Line in the drop-down menu or create a new “Data Series” record by clicking the star button (See [[Create a Data Series#Creating a Data Series|Creating a Data Series]] section for instructions)</li>
 +
      <li>Add a futures line to show how the Graph Line could change in the future by clicking the star button to create a new “Futures” record </li>
 
         <ol type="i">
 
         <ol type="i">
           <li>Add “Highlights” desired to be called-out in the LiveTile by clicking the star button to create a new “Highlights” record. In the “Create LiveTile Highlight” window enter the following information:</li>
+
           <li>Enter the name of the Graph Line Future in the “Name” field</li>
 
             <ol type="A">
 
             <ol type="A">
               <li>Enter a name for the Highlight in the “Name” field</li>
+
               <li>Example: 2.5%</li>
              <ol type="1">
+
            </ol>
                <li>Examples: Ports Avail %, CO2 Year Total, UPS % Used, etc.</li>  
+
          <li>Enter a label for the Legend in the “Legend Label” field</li>
              </ol>
+
            <ol type="A">
              <li>Select a Data Series to use for the “Highlight” from the drop down menu or create a new “Data Series” record by clicking the star button (See “Creating a Data Series” section for instructions)</li>
+
              <li>Example: 2.5%</li>
              <li>Select a “Format Override” to format the numbers in the “Highlight” from the drop down menu or create a new “Format Override” record by clicking the star button (See “Creating a Number Format Template” section for instructions)</li>
+
            </ol>
               <li>Click “Add”</li>
+
          <li>Define the period of time the Graph will extend into the future in the “Time Period” section</li>
[[File:COG-UPS-Avail.png]]
+
          <li>Enter the amount of Future Graph Lines to come from the historical data in the “Number Per Period” field</li>
              </ol>
+
            <ol type="A">
           <li>Add entries to be displayed in the LiveTile in the “Table Entries” section by clicking the star button to create a new “Table Entry” record. In the “Create LiveTile Table Entry” enter the following:</li>
+
               <li>Example: 1 Month</li>
 +
            </ol>
 +
           <li>Enter a formula for the Future Graph Line in the “Formula” field</li>
 
             <ol type="A">
 
             <ol type="A">
               <li>Enter the name of the Table Entry in the “Name” field</li>
+
               <li>Example: prev*1.05</li>
              <ol type="1">
+
            </ol>
                <li>Examples: UPS A Load, Total Load (Tons), Average Cold Aisle, etc</li>  
+
          <li>Define a color for the Future Graph Line in the “Color” field</li>
              </ol>
+
          <li>Click “Add”</li>
              <li>Select a “Data Series” to be used for the “Table Entry” from the drop-down menu or create a new “Data Series” record by clicking the star button (See “Creating a Data Series” section for instructions)</li>
 
              <li>Select a “Format Override” to format the numbers in the Table Entry from the drop down menu or create a new “Format Override” record by clicking the star button (See “Creating a Number Format Template” section for instructions)</li>
 
              <li>Choose a way of comparing previous data with today’s data in the “Delta Comparison” drop-down menu</li>
 
              <li>Click "Add"</li>
 
[[File:COG-Delta.png]]
 
              </ol>
 
 
         </ol>
 
         </ol>
       <li>Click “Create”</li>
+
       <li>Click “Add” on the “Create Graph Line” window</li>
      <li>You now have a LiveTile that will continue to update eon the refresh interval time and be available at anytime for viewing.</li>
 
 
     </ol>
 
     </ol>
 
</ol>
 
</ol>

Latest revision as of 11:13, 30 September 2014

Creating a Graph

A graph within LiveDC is used to show historical changes in your data. Fed by specified data series, a graph will provide valuable insight into data center trends to help you make informed decisions and be proactive in the case of an outage, disruption, and future requirements.

Instructions

  1. On the navigation menu (left-hand side) click “Visuals” and then “Graphs” this will open a new tab titled “Graphs”
  2. Within the graphs tab (upper left-hand corner) click the “Create” button. A new window will open up called “Create Graph.”
    1. Enter the name of the graph in the “Name” field
      1. Examples: Server Changes, Temperatures (Hot Aisles), UPS Capacity, etc.
    2. Enter any additional information about the graph in the “Details” field
    3. Enter a title in the “Title” field to be displayed when the graph is generated
    4. Enter a label for the X-axis in the “Axis Label” field
      1. Examples: Temperature (F), kW, Month, etc.
    5. Select a size for the graph in the “Size” drop-down menu
      1. Small, medium, or large - this will determine the detail and resolution of the graph when displayed
    6. Define a time period for the graph to display in the “Time Period” section
      1. We usually look over the last month or last 3 months (previous quarter)
    7. Add lines to the graph by clicking on the star button to create a new “Graph Line” record. In the “Create Graph Line” window enter the following:
      1. Enter the name of the line in the “Name” field
        1. Examples: Physical Servers, Average Temperature, Historical Power, etc.
      2. Enter a name for the legend of this line in the “Legend Label” field
        1. Examples: Historical, Max Temp, Physical Servers, etc.
        2. This label will appear at the bottom of the graph, along with the color of the line it is representing
      3. Select a color for the graph line in the “Color” section
      4. Select the “Data Series” that will provide the data for the graph line in the drop-down menu or create a new “Data Series” record by clicking the star button (see Creating a Data Series section for instructions)
      5. Graph-Line.png
      6. Add a future line to show how the graph line could change in the future by clicking the star button to create a new “Futures” record. In the “Create Graph Line Future” window, enter the following:
        1. Enter the name of the graph line future in the “Name” field
          1. Example: 2.5%, 5%, 10%, etc.
        2. Enter a label for the legend in the “Legend Label” field
          1. Example: 2.5%, 5%, 10%, etc.
        3. Define the period of time the graph will extend into the future in the “Time Period” section
          1. Example: 24 months
        4. Enter the “Number Per Period” identifier which outlined how many times you want to provide a value each month as outlined in section 3 above.
          1. Example: 1 is the standard value here
        5. Enter a formula for the future graph line in the “Formula” field
          1. See image below for syntax: prev*1.004166 refers to a 5% growth rate for the year, broken down to the monthly increase
        6. Define a color for the future graph line in the “Color” field
        7. Click “Add”
        8. Graph-Line-Future.png
      7. Click “Add” on the “Create Graph Line” window
    8. Click “Create” on the “Create Graph” window
    9. You now have a graph that will continue to update automatically and always be available for a real-time view in LiveDC


Creating a Graph Line

Instructions

  1. Enter the following information In the “Create Graph Line” window
    1. Enter the name of the Line in the “Name” field
      1. Examples: Physical Servers, Average Temperature, Historical Power, etc.
    2. Enter a name for the legend of this Line in the “Legend Label” field
      1. Examples: Historical, Max Temp, Physical Servers, etc.
      2. This will appear in the bottom of the graph window
    3. Select a color for the Graph Line in the “Color” section
    4. Select the “Data Series” that will provide the data for the Graph Line in the drop-down menu or create a new “Data Series” record by clicking the star button (See Creating a Data Series section for instructions)
    5. Add a futures line to show how the Graph Line could change in the future by clicking the star button to create a new “Futures” record
      1. Enter the name of the Graph Line Future in the “Name” field
        1. Example: 2.5%
      2. Enter a label for the Legend in the “Legend Label” field
        1. Example: 2.5%
      3. Define the period of time the Graph will extend into the future in the “Time Period” section
      4. Enter the amount of Future Graph Lines to come from the historical data in the “Number Per Period” field
        1. Example: 1 Month
      5. Enter a formula for the Future Graph Line in the “Formula” field
        1. Example: prev*1.05
      6. Define a color for the Future Graph Line in the “Color” field
      7. Click “Add”
    6. Click “Add” on the “Create Graph Line” window