Workspaces
AGR Dynamics has created a powerful tool, called workspaces, that allows users to create many different types of views of their data with many different types of data series.
The Plans functionality within the AGR Inventory module is built using Workspaces. Below you can see a list of the different plans that have been created within the AGR Inventory module. The Plans tab within the AGR Inventory modules allows you to create your own specific plans with the given data series within your AGR setup.
Within the AGR Planning module, the tabs within the navigation bar link to specific workspaces that have been set up during implementation of the AGR system. Workspaces are made up of views. Some workspaces, like the Sales Plan workspace, only has one view.
Having multiple views in one workspace allows the user the ability to easily flip between information, specifically when users are dealing with a lot of data that intertwine with each other.
The Plans tab within the AGR Inventory module allows the user to create multiple different workspaces with their data series.
Workspace Standard Functionality
The standard functionality within all workspaces, whether it is within the AGR Inventory module or the AGR Planning module, is very similar and can be found below.
Adding/Editing Views
The user can add or edit views within a workspace by clicking on the Views button. This button allows for the creation of various views within the same workspace by selecting which columns and data series to show and hide, and group data by one or several columns.
You can save the view you are looking at to be able to easily see it again, without needing to configure the filters, columns, etc. the same way.
Just as easily, we can edit views by clicking on the pencil within the Views dropdown. A new window will open and there you can see all the default system views that were created within your system during implementation, as well as views you have created, and views other users have created and shared with you. For each individual view, you can also rename, Toggle Visibility, and select different sharing options.
To add or edit data within a view, you must click on the View Settings button within the workspace tool bar, and then click on the Advanced button (rocket ship). Here you can add columns, data series, drill down, actions, and filters to your view. Once you make any changes within the View Settings sidebar, you will need to refresh the page to see the changes occur within your view.
View Settings
In View Settings, you can control column and series visibility, change view filters, and more.
Columns
The list of all columns that are available in the current view. You can toggle the column visibility by clicking the icon. The columns can also be reordered by dragging and dropping. If a description is available, it will appear in a icon when you hover over the column name.
The grid in Workspaces behave differently than the grid in Items and Reports. All columns appear in the grid as grouped data. The first column in the grid will become the top group.
Some columns are not compatible with each other. Each time you add a column, the available columns in the column dropdown are refreshed and removed if not compatible with the added column.
Data Series
The list of all data series that are available in the current view. As with columns, you can hide data series and you and a icon will show up when you hover over their name. You can also reorder the data series. Editable data series will have a green border on the left side. You can control how to data series are grouped with the data series group by drop-down. In the image above the data series are grouped by Month.
Filters
Here you can add and remove view filters. The filters affect both column and data series data.
The view filters affect the data in the grid the same way as the filters in the Filters sidebar. The only difference is that the view filters are saved in the view while the filters in the Filters sidebar are saved in your browser.
Advanced View Settings
You must have user access rights to access this feature.
To open Advanced View Settings, click the icon. Here you get access to much more columns and data series and can edit the Drill-Down filters and Actions.
Columns
Columns settings:
Σ - Aggregation: Use to aggregate the column data.
- Locked: The lock will make users unable to hide the column.
- Visible: The checkbox controls whether the column is visible in the columns list and grid or not. When a column is added but un-checked the data will be loaded without being displayed.
Data Series
- Locked: The lock will make users unable to hide the series.
Drill-Down
The drill-down gives you additional filters in the toolbar. By default, the options in the toolbar drop-downs will be filtered by the previous drill-downs. You can break this chain by clicking the split icon. This ensures the drop-down will contain all options even if they will give you a grid with no data.
The lock icon will remove the close button from the drop-down in the toolbar so that a option is always selected.
Actions
List of all available actions in the current workspace. Selected actions will appear under the Actions dropdown in the toolbar.
Filters
- Locked: The lock will make users unable to hide or change the filter.
Editing Workspaces
There are two types of fields within workspaces: editable and read-only. Read-only fields are white, editable fields are light green. You can enter and change data in editable fields.
Workspaces can be edited on any level after they are created. They can be edited on the monthly level or for each individual month. The user just needs to click on the entry that they would like to change and make the necessary changes.
When a workspace has been edited, a lock symbol will show up, denoting that the system is updating its calculations based on your edits. It is not possible to make other changes to these cells that are locked while the system is updated. The workspace is saved automatically when the data has been edited.
Export to Excel
This button exports the data from your workspace to an excel file. If you apply any filters or grouping to your data, then the resulting data (filtered and/or grouped) will be exported to an excel file, not the original data. It is also possible to copy/paste the cells by selecting the data and then right-clicking.
Workspace Filters
This button allows you to apply filters to your whole workspace in an ad hoc fashion. When you click on the Filter icon, a left sidebar will open labelled “Filters” with the drop-down menu from where you can select the ad hoc columns to filter. These filters will just be applied while you are looking at this plan, and will not be saved within the View Settings. If you want to add Filters to the View of this plan, then you must do so within the right sidebar, under View Settings.
Chart
By clicking on the button with a graph, you can view your workspace in chart format:
Show Totals
The above button adds totals over the columns and over the rows of your workspace, the totals are highlighted by a dark grey color as the example below.
Advanced
If a user has developer access to the views tab, and if the system allows for it, they are able to click on the advanced button (a rocket ship to the right of the View Settings sidebar). This means the user can change the columns, data series, drill-down, actions and filters. Below is a full list of all the standard columns that are available within workspaces.
Basic Info
- Item no
- Item name
- Location
- Primary vendor
Detail
- ABC
- Color
- Item group level 1
- Item group level 2
- Item group level 3
- Item group level 4
- MAPE
- MAPE category
- Responsible
- Size
- Style
Period
- Day
- Month
- Week
Columns
You can always rearrange the columns and the data series by dragging and dropping them within the view setting and arranging them in the way that you would like.
As you can see in the previous image, while two different columns have been selected, the Item Name column has a broken chain icon next to it. This means that this column is hidden. If the chain is not broken this means the column is not hidden and will be included in your workspace.
Data Series
Data series can be organized in several different ways. The user can click on the drop-down menu and choose a different way to organize the data. As seen in the example below, what is chosen there will essentially decide what is on the “x-axis” of the workspace.
Data series can be organized in the following ways in the same ways as the table shown on the previous page, for example Details, Period, and Basic Info.
Actions
Within the view settings, you can choose and run available actions within your view.
Add Drill Down
The last thing that you can do within the View Settings is to add a drill down. When you click on this option, the following drop down appears, giving you many options to view a drill down. The view below shows a workspace being drilled down first by location and then by Item No.
If you add a drill down column that is also present in view filters then the drill down column will be filtered by that filter.
For example, suppose you add Location to view filter and specify for examples 4 Locations in checkboxes. When you then add Location as a drill down, only those 4 locations will be shown in the drilldown.
Filters
If you want to add a filter to this specific view, you can do so here within the View Settings sidebar.