Difference between revisions of "Adding a dimension to a variable"

 
 
(9 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
1. Drag an index node, drop it a few inches on top of ‘car type’ index node. Type ‘Year’
+
[[Category: Variables]]
  
−
<br>
+
*Drag and drop another index node in the diagram
−
[[Image:Diagram Car cost1.1.jpg]]
+
*Type <code>Year</code> for the index title
  
−
2. Click on the key icon. Select ‘Description’ from the attribute popup menu.
+
:[[Image:Diagram Car cost1.1.jpg]]
  
−
<br>
+
*Open the attribute pane and select ‘Description’ from the [[attribute dropdown menu]].
−
[[Image:Car cost Description.jpg]]
 
  
−
3. Type ‘Year of ownership’, press alt+enter. Select ‘Definition’ from the popup menu.
+
:[[Image:Car cost Description.jpg]]
  
−
<br>
+
*Type <code>Year of ownership</code>
−
[[Image:Car cost Definition.jpg]]
+
*Press ''Alt+Enter''.
 +
*Select ‘Definition’ from the popup menu.
  
−
4. Select ‘List’ from the expr popup menu. First cell is entered as 1, press Enter key twice to have 3 cells with appropriate nos.
+
:[[Image:Car cost Definition.jpg]]
  
−
<br>
+
*Select ‘List’ from the [[expr]] popup menu.
−
[[Image:List Year.jpg]]
+
*First cell is entered as 1, press ''Enter'' key twice to have 3 cells with appropriate nos.
  
−
5. Select ‘Maintenance cost’.
+
:[[Image:List Year.jpg]]
  
−
<br>
+
*Select <code>Maintenance cost</code>.
−
[[Image:Diagram Car cost1.2.jpg]]
 
  
−
6. Click on the ‘Edit table’ button. Edit table window should come up. Click on the ‘index’ icon.
+
:[[Image:Diagram Car cost1.2.jpg]]
  
−
<br>
+
*Click on the ‘Edit table’ button that shows on the attribute pane.
−
[[Image:Edit table Maintenance cost.jpg]]
+
*Click on the ‘indexes’ icon to bring up Indexes window
  
−
7. Select ‘Year’ in the index lists. Click arrow >>, then press ‘ok’.
+
:[[Image:Edit table Maintenance cost.jpg]]
  
−
<br>
+
*Click <code>Year</code> from the index lists and click the <code>>></code> icon to add the index.
−
[[Image:Indexes Year.jpg]]
+
*Press '''OK''' button.
  
−
8. Click on the 2nd column change units to ‘1500’ press arrow down key, type ‘2600’. Click on the 3rd column, enter ‘1700’ press arrow down key, enter ‘3000’.  Click the check button.
+
'''Expected: Edit table of <code>Maintenance cost</code> is now indexed by <code>Year</code> for the columns and <code>Car type</code> for rows '''
  
−
<br>
+
:[[Image:Indexes Year.jpg]]
−
[[Image:Edit table Maintenance cost1.1.jpg]]
+
 
 +
*Click on column 2 row header small car
 +
*Change cell value from '1200' to ‘1500’
 +
*Press arrow down key, change this cell value from '2400' to ‘2.6K’ { to check the number formatting is recognized}.
 +
*Click on column 3 row header small ca
 +
*Change the cell value from '1200' to '1.7e+3' {Same number format issue}
 +
*Press arrow down key
 +
*Change the cell value from '2400' to '300000%'
 +
*Click the check button.
 +
*''Ctrl+r'' to bring up result table of <code>Maintenance cost</code>
 +
 
 +
'''Expected: Result of <code>Maintenance cost</code> show the new changes on its cell values'''
 +
:[[Image:Edit table Maintenance cost1.1.jpg]]
 +
 
 +
 
 +
==See Also==
 +
* [[Creating Arrays (Tables)]]

Latest revision as of 05:02, 24 November 2023


  • Drag and drop another index node in the diagram
  • Type Year for the index title
Diagram Car cost1.1.jpg
Car cost Description.jpg
  • Type Year of ownership
  • Press Alt+Enter.
  • Select ‘Definition’ from the popup menu.
Car cost Definition.jpg
  • Select ‘List’ from the expr popup menu.
  • First cell is entered as 1, press Enter key twice to have 3 cells with appropriate nos.
List Year.jpg
  • Select Maintenance cost.
Diagram Car cost1.2.jpg
  • Click on the ‘Edit table’ button that shows on the attribute pane.
  • Click on the ‘indexes’ icon to bring up Indexes window
Edit table Maintenance cost.jpg
  • Click Year from the index lists and click the >> icon to add the index.
  • Press OK button.

Expected: Edit table of Maintenance cost is now indexed by Year for the columns and Car type for rows

Indexes Year.jpg
  • Click on column 2 row header small car
  • Change cell value from '1200' to ‘1500’
  • Press arrow down key, change this cell value from '2400' to ‘2.6K’ { to check the number formatting is recognized}.
  • Click on column 3 row header small ca
  • Change the cell value from '1200' to '1.7e+3' {Same number format issue}
  • Press arrow down key
  • Change the cell value from '2400' to '300000%'
  • Click the check button.
  • Ctrl+r to bring up result table of Maintenance cost

Expected: Result of Maintenance cost show the new changes on its cell values

Edit table Maintenance cost1.1.jpg


See Also

Comments


You are not allowed to post comments.