{"type":"doc","content":[{"type":"paragraph","content":[{"text":"Chrono reports are the static reports with the data, organized in columns and in rows. These reports are used to create static report tables to match business standard templates. Chrono reports allow the user to create tables with a mix of data (digger tonnes, crusher grades, truck hours, drill meters), and to visualize the data in charts. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":65.0},"content":[{"type":"media","attrs":{"width":2201,"id":"552aadd6-9ead-4fe1-a89e-45c3166dcc83","collection":"contentId-29432165","type":"file","height":1067}},{"type":"caption","content":[{"text":"Sample Chrono Summary report","type":"text","marks":[{"type":"em"}]}]}]},{"type":"paragraph","content":[{"text":"The Chrono Reports workspace consist of four main tabs with different functionality, the toolbar, and Errors List. Detailed description of these reporting components see below.","type":"text"}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{"_parentId":{"value":"29432165"},"exclude":{"value":"Contents"}},"macroMetadata":{"macroId":{"value":"b5f818f9-e9f2-40e6-a24d-2766f1ea4ecc"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"487da526-d13a-4091-ae5c-0e6542bb9225"}},{"type":"heading","attrs":{"level":4},"content":[{"text":"Add New Chrono","type":"text"}]},{"type":"paragraph","content":[{"text":"To create this type of report select \"Chrono\" from ","type":"text"},{"text":"Add Report","type":"text","marks":[{"type":"strong"}]},{"text":" button dropdown.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":647,"id":"016cc6cf-27a3-4b86-954e-fca3d0975d79","collection":"contentId-29432165","type":"file","height":624}},{"type":"caption","content":[{"text":" Schedule > Reporting > Add Report button>“Chrono” option","type":"text","marks":[{"type":"em"}]}]}]},{"type":"paragraph","content":[{"text":"A New Chrono report will appear in the list of reports. Left click on it and rename as desired.","type":"text"}]},{"type":"paragraph","content":[{"text":"By default, an empty report will be displayed with the ","type":"text"},{"text":"Table Setup","type":"text","marks":[{"type":"strong"}]},{"text":" and ","type":"text"},{"text":"Charts Setup","type":"text","marks":[{"type":"strong"}]},{"text":" tabs available. Populating data into them correctly will unlock the ","type":"text"},{"text":"Table ","type":"text","marks":[{"type":"strong"}]},{"text":"and ","type":"text"},{"text":"Charts ","type":"text","marks":[{"type":"strong"}]},{"text":"tabs.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":784,"id":"ce88ca25-212b-4fd6-86d6-eb0dbe25df92","collection":"contentId-29432165","type":"file","height":73}},{"type":"caption","content":[{"text":"Available and locked tabs of a new Chrono report","type":"text","marks":[{"type":"em"}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Table Setup tab","type":"text"}]},{"type":"paragraph","content":[{"text":"The ","type":"text"},{"text":"Table Setup","type":"text","marks":[{"type":"strong"}]},{"text":" tab is used to create the table structure and data rows. Open it to edit the newly created report.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":65.0},"content":[{"type":"media","attrs":{"width":2417,"id":"04781d22-ca96-46f6-82ff-747455debbdf","collection":"contentId-29432165","type":"file","height":1067}},{"type":"caption","content":[{"text":"Lookup of “mining.dryTonnes” field in the Mining Data Source, filtered to Source.Top equals “Reserves”","type":"text","marks":[{"type":"em"}]}]}]},{"type":"paragraph","content":[{"text":"Report rows can be added, removed, indented, moved up/down, copied, cut, pasted using the top toolbar. ","type":"text"},{"type":"hardBreak"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":471,"id":"00256c0c-7f2a-4205-8251-676a22585178","collection":"contentId-29432165","type":"file","height":153}},{"type":"caption","content":[{"text":"Top toolbar buttons","type":"text","marks":[{"type":"em"}]}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"When creating repetitive reports (i.e. Pit1, Pit2, Pit3, ...), start by creating a table template. Once complete, highlight the rows and select the ","type":"text"},{"text":"Copy ","type":"text","marks":[{"type":"strong"}]},{"text":"icon. Paste the copied rows and use the ","type":"text"},{"text":"Find and Replace","type":"text","marks":[{"type":"strong"}]},{"text":" function to update the references. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Use","type":"text"},{"text":" Change Time Settings","type":"text","marks":[{"type":"strong"}]},{"text":" button to set reporting intervals and start/end periods. You may choose to report by \"Scheduling Periods\", \"Number and Name\", \"Calendar Years\", \"Financial Years\", \"Calendar Quarters\" etc. For the Start and End periods you may select certain periods dates or schedule start/end to display in your report.","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":444,"id":"771aa64c-b682-4309-941c-d3c96e2895c7","collection":"contentId-29432165","type":"file","height":279}},{"type":"caption","content":[{"text":"Change Time Settings button and reporting intervals menu","type":"text","marks":[{"type":"em"}]}]}]},{"type":"paragraph","content":[{"text":"Set the values in each column to match your data set. Description of the columns see in the table below.","type":"text","marks":[{"type":"strong"}]}]},{"type":"table","attrs":{"layout":"default","localId":"9e8b66ea-e57b-44bb-8c43-101ef65cf277"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[95.0]},"content":[{"type":"paragraph","content":[{"text":"Column","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[665.0]},"content":[{"type":"paragraph","content":[{"text":"Function","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[95.0]},"content":[{"type":"paragraph","content":[{"text":"Type","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[665.0]},"content":[{"type":"paragraph","content":[{"text":"Set row type to “Title”, “Row” or “Iter”. ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Title fields act like folders. Their only function is to contain child rows. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Row fields look up a value from some data source.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Iter(ative) fields can be used to loop over a list of items, and return the value for each item. ","type":"text"}]}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[95.0]},"content":[{"type":"paragraph","content":[{"text":"Name","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[665.0]},"content":[{"type":"paragraph","content":[{"text":"An alphanumeric identifier used to create a unique lookup for the row, which can later be referenced in graph series and calculated fields. It is also used as a lookup code for formulas and charts.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[95.0]},"content":[{"type":"paragraph","content":[{"text":"Caption","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[665.0]},"content":[{"type":"paragraph","content":[{"text":"The display name of the row in the output table. ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[95.0]},"content":[{"type":"paragraph","content":[{"text":"Indent","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[665.0]},"content":[{"type":"paragraph","content":[{"text":"Creates nested table fields. Indentation of child rows under title rows.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[95.0]},"content":[{"type":"paragraph","content":[{"text":"Hide","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[665.0]},"content":[{"type":"paragraph","content":[{"text":"Optionally hide a field from the output table.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[95.0]},"content":[{"type":"paragraph","content":[{"text":"Units","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[665.0]},"content":[{"type":"paragraph","content":[{"text":"Optionally specify units (meters, bcm, tonnes). ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[95.0]},"content":[{"type":"paragraph","content":[{"text":"Format","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[665.0]},"content":[{"type":"paragraph","content":[{"text":"Excel-style number formatting. ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[95.0]},"content":[{"type":"paragraph","content":[{"text":"Initial","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[665.0]},"content":[{"type":"paragraph","content":[{"text":"Optionally set the opening value for cumulative sums of this field. ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[95.0]},"content":[{"type":"paragraph","content":[{"text":"Data Source","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[665.0]},"content":[{"type":"paragraph","content":[{"text":"Choose a data source from a list or create a calculated field.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[95.0]},"content":[{"type":"paragraph","content":[{"text":"Item","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[665.0]},"content":[{"type":"paragraph","content":[{"text":"The ","type":"text"},{"text":"Item","type":"text","marks":[{"type":"strong"}]},{"text":" column requires a ","type":"text"},{"text":"Data Source","type":"text","marks":[{"type":"strong"}]},{"text":" to be specified.","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Use the Mining data source for mining movements.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Use the Closing.Stockpiles data source for ROM stocks.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Use the Calendar data source for trucking calculations.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Use the Agent data source for reporting delays.","type":"text"}]}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[95.0]},"content":[{"type":"paragraph","content":[{"text":"Filter 1 Field","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[665.0]},"content":[{"type":"paragraph","content":[{"text":"Filter field for filtering results.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[95.0]},"content":[{"type":"paragraph","content":[{"text":"Filter 1 Value","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[665.0]},"content":[{"type":"paragraph","content":[{"text":"Filter value to apply to the filter field. ","type":"text"}]}]}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Red circle on the left of the ","type":"text"},{"text":"Type","type":"text","marks":[{"type":"strong"}]},{"text":" column indicates that you have made some mistakes filling up a table or there are some unresolved issues. Check the","type":"text"},{"text":" Error List","type":"text","marks":[{"type":"strong"}]},{"text":" below to get a description and fix all the errors listed.","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":50.0},"content":[{"type":"media","attrs":{"width":1133,"id":"d19bc9a9-48f7-4a75-aaad-18f2438c7697","collection":"contentId-29432165","type":"file","height":956}},{"type":"caption","content":[{"text":"Example of table errors and their description in the Error List panel","type":"text","marks":[{"type":"em"}]}]}]},{"type":"paragraph","content":[{"text":"Other toolbar buttons:","type":"text","marks":[{"type":"strong"}]}]},{"type":"table","attrs":{"layout":"default","localId":"d975714b-29d0-458b-82d5-1b88e60daa58"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[134.0]},"content":[{"type":"paragraph","content":[{"text":"Button","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[94.0]},"content":[{"type":"paragraph","content":[{"text":"Icon","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[532.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[134.0]},"content":[{"type":"paragraph","content":[{"text":"Find and Replace","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[94.0]},"content":[{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":32,"id":"485376ac-47d9-41ab-ac81-2567c23b8c8a","collection":"contentId-29432165","type":"file","height":29}}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[532.0]},"content":[{"type":"paragraph","content":[{"text":"+ H. Use this icon to quickly update a range of selected cells when editing or updating reports","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[134.0]},"content":[{"type":"paragraph","content":[{"text":"Convert to Static Report","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[94.0]},"content":[{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":32,"id":"a200f6ed-875d-49da-8b0a-f04e3f24e872","collection":"contentId-29432165","type":"file","height":29}}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[532.0]},"content":[{"type":"paragraph","content":[{"text":"Convert your report to static. Note that if your report currently has errors, they must be resolved before the report can be converted to a static one. See the ","type":"text"},{"text":"Errors","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text"},{"text":"list","type":"text","marks":[{"type":"strong"}]},{"text":" below.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[134.0]},"content":[{"type":"paragraph","content":[{"text":"Manage Custom Lists","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[94.0]},"content":[{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":32,"id":"0a534f9f-100f-46d1-94c0-d4e01e5eb8d1","collection":"contentId-29432165","type":"file","height":29}}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[532.0]},"content":[{"type":"paragraph","content":[{"text":"Opens ","type":"text"},{"text":"Custom Lists","type":"text","marks":[{"type":"strong"}]},{"text":" dialog where you may add, remove, move up/down, save and import custom lists, as well as add, remove, move up/down, sort, copy, paste and clear custom items.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":869,"id":"2663b509-ba54-4107-b86a-a854bf0d3763","collection":"contentId-29432165","type":"file","height":275}}]},{"type":"paragraph"}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[134.0]},"content":[{"type":"paragraph","content":[{"text":"Formatting","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[94.0]},"content":[{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":213,"id":"f90f0d63-ea62-41da-bb36-7892618ea1dc","collection":"contentId-29432165","type":"file","height":212}}]},{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[532.0]},"content":[{"type":"paragraph","content":[{"text":"Use this button to:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"configure Pivot Grid Appearance (font, size, style, color, background color for captions and samples),","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"clear formats,","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"paste or copy formats,","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"perform period formatting (font, size, style, color, background color for period captions and period names),","type":"text"}]}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[134.0]},"content":[{"type":"paragraph","content":[{"text":"Usage Hints","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[94.0]},"content":[{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":47,"id":"52da556c-4d6b-47ee-892b-e813155764a6","collection":"contentId-29432165","type":"file","height":29}}]},{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[532.0]},"content":[{"type":"paragraph","content":[{"text":"Applicable hotkeys you may use when working with a report.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":492,"id":"fdbe8345-e974-4a25-a937-dc8f7e7fcf19","collection":"contentId-29432165","type":"file","height":364}}]}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Table tab","type":"text"}]},{"type":"paragraph","content":[{"text":"Once you resolve all the issues listed in the ","type":"text"},{"text":"Error List","type":"text","marks":[{"type":"strong"}]},{"text":" the ","type":"text"},{"text":"Table","type":"text","marks":[{"type":"strong"}]},{"text":" tab becomes available. Open it to see the final report. ","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":65.0},"content":[{"type":"media","attrs":{"width":1476,"id":"cf2eb7c5-3d36-4212-a8a8-ef7a7c2fdb93","collection":"contentId-29432165","type":"file","height":900}},{"type":"caption","content":[{"text":" Table tab example","type":"text","marks":[{"type":"em"}]}]}]},{"type":"table","attrs":{"layout":"default","localId":"4d23fa45-a847-4e8a-aca1-c1fcc09e6400"},"content":[{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[269.0]},"content":[{"type":"paragraph","content":[{"text":"Right click on any field header to set or reset a color","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[491.0]},"content":[{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":347,"id":"b6875e3f-d865-406f-b211-02a81a429f26","collection":"contentId-29432165","type":"file","height":89}}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[269.0]},"content":[{"type":"paragraph","content":[{"text":"Right click on any field row to copy its full name","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[491.0]},"content":[{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":537,"id":"33810ddf-2970-4bb8-b136-a49318e5bb6d","collection":"contentId-29432165","type":"file","height":111}}]}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Charts Setup tab","type":"text"}]},{"type":"paragraph","content":[{"text":"Before setting up chrono report tables:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select the ","type":"text"},{"text":"Charts Setup","type":"text","marks":[{"type":"strong"}]},{"text":" tab.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Add a new chart.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Rename the chart to \"Sources\".","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In the ","type":"text"},{"text":"Primary Axis","type":"text","marks":[{"type":"strong"}]},{"text":" panel,","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"change the caption to \"Tonnes\",","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"change the Format to \"0.0%\".","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In the ","type":"text"},{"text":"Series","type":"text","marks":[{"type":"strong"}]},{"text":" panel,","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Add four series.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Name the series “P101“, “P102“, “P201“ and “P301“,","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Set the fields to \"mov.expit.pits.P101\", \"mov.expit.pits.P102\", “mov.expit.pits.P201“ and \"mov.expit.pits.P301\".","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select from the ","type":"text"},{"text":"Series Type","type":"text","marks":[{"type":"strong"}]},{"text":" column \"StackedBar\". You may select different types for each series to display in the ","type":"text"},{"text":"Charts","type":"text","marks":[{"type":"strong"}]},{"text":" tab.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select colours for each bar.","type":"text"}]}]}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":65.0},"content":[{"type":"media","attrs":{"width":1476,"id":"75ea1e32-f77f-442f-b8e5-2c95d7b71f3a","collection":"contentId-29432165","type":"file","height":900}},{"type":"caption","content":[{"text":" Charts Setup tab example","type":"text","marks":[{"type":"em"}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Charts tab","type":"text"}]},{"type":"paragraph","content":[{"text":"Review all data you populated in the previous tab by opening the ","type":"text"},{"text":"Charts","type":"text","marks":[{"type":"strong"}]},{"text":" tab.","type":"text"}]},{"type":"paragraph","content":[{"text":"Note, that this tab is only available if no errors remaining in the ","type":"text"},{"text":"Chart Setup","type":"text","marks":[{"type":"strong"}]},{"text":" tab.","type":"text"}]},{"type":"paragraph","content":[{"text":"You may always come back to the ","type":"text"},{"text":"Charts Setup","type":"text","marks":[{"type":"strong"}]},{"text":" tab to change","type":"text"},{"text":" Series Type","type":"text","marks":[{"type":"strong"}]},{"text":" to display in charts.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":65.0},"content":[{"type":"media","attrs":{"width":1476,"id":"4de8e2f3-d20e-44c3-b396-20954449bff0","collection":"contentId-29432165","type":"file","height":900}},{"type":"caption","content":[{"text":"Charts tab example overview","type":"text","marks":[{"type":"em"}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Setup tips","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"item&data"},"_parentId":{"value":"29432165"}},"macroMetadata":{"macroId":{"value":"f19e4fd3c9874b7031808ffc53bd274b"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"7e5761ec-eb88-4954-b92e-d5ec4fb5119b"}},{"text":"Relationship between Item and Data Source fields","type":"text"}]},{"type":"paragraph","content":[{"text":"The ","type":"text"},{"text":"Item","type":"text","marks":[{"type":"strong"}]},{"text":" column requires a ","type":"text"},{"text":"Data Source","type":"text","marks":[{"type":"strong"}]},{"text":" to be specified. ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Use the “Mining” data source for mining movements.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Use the “Closing.Stockpiles” data source for ROM stocks. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Use the “Calendar” data source for trucking calculations. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Use the “Agent” data source for reporting delays. ","type":"text"}]}]}]},{"type":"table","attrs":{"layout":"default","localId":"9d640271-afd5-42ec-a442-229263bd7cbf"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[200.0]},"content":[{"type":"paragraph","content":[{"text":"Data Source","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[560.0]},"content":[{"type":"paragraph","content":[{"text":"Item","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[200.0]},"content":[{"type":"paragraph","content":[{"text":"Duration","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[560.0]},"content":[{"type":"paragraph","content":[{"text":"Minutes, Hours, Days, and Weeks duration of each report column","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[200.0]},"content":[{"type":"paragraph","content":[{"text":"Calendar","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[560.0]},"content":[{"type":"paragraph","content":[{"text":"Calendar fields","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[200.0]},"content":[{"type":"paragraph","content":[{"text":"NonSpatialGuidance","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[560.0]},"content":[{"type":"paragraph","content":[{"text":"Non-Spatial Guidance fields","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[200.0]},"content":[{"type":"paragraph","content":[{"text":"Calculated","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[560.0]},"content":[{"type":"paragraph","content":[{"text":"Custom calculation","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[200.0]},"content":[{"type":"paragraph","content":[{"text":"CustomLists","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[560.0]},"content":[{"type":"paragraph","content":[{"text":"Custom list of items","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[200.0]},"content":[{"type":"paragraph","content":[{"text":"Agents","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[560.0]},"content":[{"type":"paragraph","content":[{"text":"Agent time and rate fields","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[200.0]},"content":[{"type":"paragraph","content":[{"text":"StockpileStates","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[560.0]},"content":[{"type":"paragraph","content":[{"text":"Stockpile States","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[200.0]},"content":[{"type":"paragraph","content":[{"text":"ProductionDrilling","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[560.0]},"content":[{"type":"paragraph","content":[{"text":"Drilling fields","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[200.0]},"content":[{"type":"paragraph","content":[{"text":"ProductionCharging","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[560.0]},"content":[{"type":"paragraph","content":[{"text":"Charging fields","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[200.0]},"content":[{"type":"paragraph","content":[{"text":"Mining","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[560.0]},"content":[{"type":"paragraph","content":[{"text":"Mining fields","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[200.0]},"content":[{"type":"paragraph","content":[{"text":"Opening.Stockpiles / Closing.Stockpiles","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[560.0]},"content":[{"type":"paragraph","content":[{"text":"Opening and closing stockpile inventory","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[200.0]},"content":[{"type":"paragraph","content":[{"text":"Opening.Pits. / Closing.Pits.","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[560.0]},"content":[{"type":"paragraph","content":[{"text":"Opening and closing inventory (such as tonnes remaining in bench)","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[200.0]},"content":[{"type":"paragraph","content":[{"text":"Stocks.Opening. / Stocks.Closing.","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[560.0]},"content":[{"type":"paragraph","content":[{"text":"Opening and closing inventory","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Calculated fields","type":"text"}]},{"type":"paragraph","content":[{"text":"Calculated fields use a formula to create the calculated values.","type":"text"}]},{"type":"table","attrs":{"layout":"default","localId":"05e67608-6dc0-4729-b077-5cdec43a4dd1"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":2,"rowspan":1,"colwidth":[191.0,569.0]},"content":[{"type":"paragraph","content":[{"text":"Chrono report formulas","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[191.0]},"content":[{"type":"paragraph","content":[{"text":"V(“field”)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[569.0]},"content":[{"type":"paragraph","content":[{"text":"Looks up the row with the name “field” and returns the value. ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[191.0]},"content":[{"type":"paragraph","content":[{"text":"V(“field”) * 10 / 3","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[569.0]},"content":[{"type":"paragraph","content":[{"text":"Looks up the row with the name “field”, multiples the value by 10, and divides by 3. ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[191.0]},"content":[{"type":"paragraph","content":[{"text":"S(“title.*”)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[569.0]},"content":[{"type":"paragraph","content":[{"text":"Looks up all children of the row named “title”, and returns the sum. ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[191.0]},"content":[{"type":"paragraph","content":[{"text":"CV(“field”)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[569.0]},"content":[{"type":"paragraph","content":[{"text":"Returns the cumulative value of the row named “field”. The initial value is set in the “Initial” column of the “field” row. ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[191.0]},"content":[{"type":"paragraph","content":[{"text":"SD(1, V(“field”))","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[569.0]},"content":[{"type":"paragraph","content":[{"text":"Returns 1 divided by the value in the row named “field”. If the denominator is zero, it returns zero. ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[191.0]},"content":[{"type":"paragraph","content":[{"text":"Math.Round(V(“field”))","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[569.0]},"content":[{"type":"paragraph","content":[{"text":"Return the row named “field”, rounded to the nearest integer.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[191.0]},"content":[{"type":"paragraph","content":[{"text":"Math.Ceiling(V(“field”))","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[569.0]},"content":[{"type":"paragraph","content":[{"text":"Return the row named “field”, rounded up.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[191.0]},"content":[{"type":"paragraph","content":[{"text":"Math.Floor(V(“field”))","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[569.0]},"content":[{"type":"paragraph","content":[{"text":"Return the row named “field”, rounded down.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[191.0]},"content":[{"type":"paragraph","content":[{"text":"Math.Log(V(“field”))","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[569.0]},"content":[{"type":"paragraph","content":[{"text":"Returns the natural logarithm of the row named “field”. ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[191.0]},"content":[{"type":"paragraph","content":[{"text":"V(\"myValue\") > 0 ? 1 : 0","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[569.0]},"content":[{"type":"paragraph","content":[{"text":"If \"myValue\" is greater than zero, return one, otherwise return zero.","type":"text"}]}]}]}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"If the formula has been ","type":"text"},{"text":"incorrect ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff5630"}}]},{"text":"previously, and you make a change to correct it, it won't turn black straight away. Switching to the ","type":"text"},{"text":"Chart Setup","type":"text","marks":[{"type":"strong"}]},{"text":" tab and then switching back will resolve this.","type":"text"}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Creating a chrono table example (Digger Tracker)","type":"text"}]},{"type":"paragraph","content":[{"text":"This section details how to make a simple digger utilization table.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Table Setup","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Add a new Chrono report.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Rename the report to “Digger Tracker”.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select the ","type":"text"},{"text":"Table Setup","type":"text","marks":[{"type":"strong"}]},{"text":" tab. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Press the ","type":"text"},{"text":"Manage Custom Lists","type":"text","marks":[{"type":"strong"}]},{"text":" icon to create a new list.","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In the Custom Lists dialog, create a new list called “Diggers”.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Add each digger name to the list. ","type":"text"}]}]}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":1048,"id":"271460a4-b182-4679-8f6c-a906c821e4c1","collection":"contentId-29432165","type":"file","height":437}}]},{"type":"paragraph"},{"type":"paragraph","content":[{"text":"6. Populate the setup as shown in the table below.","type":"text"}]},{"type":"table","attrs":{"layout":"default","localId":"9eb793ed-10fe-4ee3-9071-c16c1b053674"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[55.0]},"content":[{"type":"paragraph","content":[{"text":"Row","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"Type","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[157.0]},"content":[{"type":"paragraph","content":[{"text":"Name","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[68.0]},"content":[{"type":"paragraph","content":[{"text":"Caption","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"Indent","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"Data Source","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[130.0]},"content":[{"type":"paragraph","content":[{"text":"Item","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"Filter 1 Field","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"Filter 1 Value","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"Filter 2 Field","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"Filter 2 Value","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[55.0]},"content":[{"type":"paragraph","content":[{"text":"1","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"Title","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[157.0]},"content":[{"type":"paragraph","content":[{"text":"Diggers","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[68.0]},"content":[{"type":"paragraph","content":[{"text":"Diggers","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"0","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[130.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph"}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[55.0]},"content":[{"type":"paragraph","content":[{"text":"2","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"Iterator","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[157.0]},"content":[{"type":"paragraph","content":[{"text":"Diggers.","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[68.0]},"content":[{"type":"paragraph","content":[{"text":"","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"1","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"CustomLists","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[130.0]},"content":[{"type":"paragraph","content":[{"text":"Diggers","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph"}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[55.0]},"content":[{"type":"paragraph","content":[{"text":"3","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"Row","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[157.0]},"content":[{"type":"paragraph","content":[{"text":"Diggers..hrs","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[68.0]},"content":[{"type":"paragraph","content":[{"text":"Active Hrs","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"2","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"Agents","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[130.0]},"content":[{"type":"paragraph","content":[{"text":"Time.AgentWorkingCalendarHours","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"Agent.Name","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph"}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[55.0]},"content":[{"type":"paragraph","content":[{"text":"4","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"Row","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[157.0]},"content":[{"type":"paragraph","content":[{"text":"Diggers..idle","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[68.0]},"content":[{"type":"paragraph","content":[{"text":"Idle Hrs","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"2","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"Agents","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[130.0]},"content":[{"type":"paragraph","content":[{"text":"Time.EngineOnHours","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"Agent.Name","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"Agent.Delay","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"Do Nothing","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[55.0]},"content":[{"type":"paragraph","content":[{"text":"5","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"Row","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[157.0]},"content":[{"type":"paragraph","content":[{"text":"Diggers..delay","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[68.0]},"content":[{"type":"paragraph","content":[{"text":"Delay Hrs","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"2","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"Agents","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[130.0]},"content":[{"type":"paragraph","content":[{"text":"Time.AgentWorkingCalendarHours","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"Agent.Name","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"Agent.Delay","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"!Do Nothing","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[55.0]},"content":[{"type":"paragraph","content":[{"text":"6","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"Title","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[157.0]},"content":[{"type":"paragraph","content":[{"text":"Diggers..delays","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[68.0]},"content":[{"type":"paragraph","content":[{"text":"Inactive Hrs","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"2","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"Calculated","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[130.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph"}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[55.0]},"content":[{"type":"paragraph","content":[{"text":"7","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"Iterator","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[157.0]},"content":[{"type":"paragraph","content":[{"text":"Diggers..delays.","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[68.0]},"content":[{"type":"paragraph","content":[{"text":"","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"3","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"Agents","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[130.0]},"content":[{"type":"paragraph","content":[{"text":"Agent.Delay","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph"}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[55.0]},"content":[{"type":"paragraph","content":[{"text":"8","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"Row","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[157.0]},"content":[{"type":"paragraph","content":[{"text":"Diggers..delays..delay","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[68.0]},"content":[{"type":"paragraph","content":[{"text":"Delay Hrs","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"4","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"Agents","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[130.0]},"content":[{"type":"paragraph","content":[{"text":"Time.UnavailableHours","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"Agent.Name","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph","content":[{"text":"","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph"}]},{"type":"tableCell","attrs":{"colspan":1,"background":"#ffffff","rowspan":1,"colwidth":[50.0]},"content":[{"type":"paragraph"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":2035,"id":"227b5e93-e16e-4602-aa0d-f4b3616bbd94","collection":"contentId-29432165","type":"file","height":631}},{"type":"caption","content":[{"text":"Digger Tracker Setup","type":"text","marks":[{"type":"em"}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Table","type":"text"}]},{"type":"paragraph","content":[{"text":"If all the fields are filled out correctly and there are no errors in the ","type":"text"},{"text":"Errors List","type":"text","marks":[{"type":"strong"}]},{"text":" panel, the ","type":"text"},{"text":"Table ","type":"text","marks":[{"type":"strong"}]},{"text":"tab will be active and the table in it will look like shown below:","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":65.0},"content":[{"type":"media","attrs":{"width":1392,"id":"4f287b0b-5574-459b-b2c5-c886278d6c3c","collection":"contentId-29432165","type":"file","height":1036}},{"type":"caption","content":[{"text":"Digger tracker table","type":"text","marks":[{"type":"em"}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Chart Setup","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open the ","type":"text"},{"text":"Chart Setup","type":"text","marks":[{"type":"strong"}]},{"text":" tab.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Add a new chart.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Rename the chart to “EX001”. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In the ","type":"text"},{"text":"Primary Axis","type":"text","marks":[{"type":"strong"}]},{"text":" panel, change the caption to “Hours” and the format to “0.0%”.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In the ","type":"text"},{"text":"Series ","type":"text","marks":[{"type":"strong"}]},{"text":"panel, add three series and name them “Active”, “Delayed”, “Idle”. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Set the fields to “Diggers.EX001.ProdHrs”, “Diggers.EX001.Delay” and “Diggers.EX001.Idle”. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Set the ","type":"text"},{"text":"Series Types","type":"text","marks":[{"type":"strong"}]},{"text":" to “FullStackedBar”.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select colours for each bar. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Repeat for each digger.","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"center","width":65.0},"content":[{"type":"media","attrs":{"width":1543,"id":"bb12d6a6-3915-4544-afaf-152b6893e40b","collection":"contentId-29432165","type":"file","height":941}},{"type":"caption","content":[{"text":"Data setup in the Charts Setup tab","type":"text","marks":[{"type":"em"}]}]}]},{"type":"paragraph"},{"type":"heading","attrs":{"level":3},"content":[{"text":"Chart","type":"text"}]},{"type":"paragraph","content":[{"text":"If no mistakes were made during the charts setup, you can open the ","type":"text"},{"text":"Charts ","type":"text","marks":[{"type":"strong"}]},{"text":"tab and view the results.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"width":1383,"id":"0b9bcddd-b1dd-47e3-badb-e36369a58bbd","collection":"contentId-29432165","type":"file","height":1040}},{"type":"caption","content":[{"text":"Charts overview in the Charts tab","type":"text","marks":[{"type":"em"}]}]}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"You can change the charts view in the ","type":"text"},{"text":"Charts ","type":"text","marks":[{"type":"strong"}]},{"text":"tab by simply dragging the headers to the desired positions.","type":"text"}]}]}],"version":1}

Browser not supported