Write, Bureaucrats, Administrators
4,332
edits
How:Slice & Dice Library Data: Difference between revisions
m
no edit summary
mNo edit summary |
mNo edit summary |
||
| Line 30: | Line 30: | ||
To prepare for subsequent analysis of the data, add related data and calculations to the data and then define aggregations of the data. | To prepare for subsequent analysis of the data, add related data and calculations to the data and then define aggregations of the data. | ||
=== | === Bring related data into the entry === | ||
First, bring the "good hooks for subsequent analysis", mentioned above, into the Orders library to enable them to be used during analysis. | First, bring the "good hooks for subsequent analysis", mentioned above, into the Orders library to enable them to be used during analysis. | ||
| Line 45: | Line 45: | ||
::* Press the '''+Field''' button, choose '''Product.Std price''' from the list | ::* Press the '''+Field''' button, choose '''Product.Std price''' from the list | ||
Then, | === Calculate with related data === | ||
Then, reach into related libraries to calculate with data that would be useful during ad hoc slicing & dicing. Add any calculations within the newly-expanded Orders library that will assist in data analysis. | |||
; Add these fields to Orders: | ; Add these fields to Orders: | ||
| Line 52: | Line 53: | ||
:* '''Order margin''' — '''[[JavaScript field]]''' | :* '''Order margin''' — '''[[JavaScript field]]''' | ||
::* Enter this script (without the double-quotes): "field('Price') - field('Product cost')" | ::* Enter this script (without the double-quotes): "field('Price') - field('Product cost')" | ||
=== Aggregation === | === Aggregation === | ||