You can now create your own customizable graphs, based on report data in Workamajig.
This guide will go over the advanced features of creating your own graphs. But it helps if you are already familiar with using Custom reports.
NOTE: You will need the security right "Design Custom Reports" to be able to add/edit graphs.
- To view Dashboards, you need the security right of Run Custom Reports.
- To edit/create graphs, you will need the security right of Edit Custom Reports.
- If you have enabled the dashboards beta and do not see them in your menu. Then be sure to click on Show All Apps in the bottom right of the menu screen.
- Each role in the menu will have its own dashboard. So if you can access the today page of that role, then you can access the dashboard for that role. For example, if you have access to the Today - managers page, then you have access to the Managers Dashboard and Owners Dashboard.
- Each graph's security can be adjusted so only certain security groups will see it.
- The original dashboards for sales, project manager, and billing are still available to use. You will see the new ones next to them called New Sales Dashboard, New PM Dashboard, and New Billing Dashboard. Please provide feedback on the original vs new and what kind of features you are looking to get out of the dashboards.
Create your own
In this example, we will use the time detail data to produce a pie chart of the total hours to date per client.
Click on Edit.
Then click on New to chose a custom report dataset from which to use as the base data for your chart/graph.
When you choose a report, you will be presented with a similar screen, which you can use to design your chart or graph.
Choose settings for the following Graph Type, X Axis, Y Axis, Series, Rollup and Sort By.
At this point, you can click on Refresh Graph to preview the graph.
Click on Filters if you want to add additional controls to what amount or type of data is presented.
Click on Settings to change the name of this graph.
Click on Save Changes.
You will then be taken back to the home screen where you can resize and if you have multiple graphs, you can reorder them.
Press Save once you have the graphs lined up the way you like.
This allows you to compare values for a specific metric.
This is best used with a time-based metric or value that flows.
Simply way to see a comparative value or a metric.
Allows you to see multiple values in a single view. This is good for seeing the totals of specific fields.
X-axis: Values will usually be dates, names/projects, and numbers
Y-axis: Values will usually be numbers/values only
Series: (bar and line graphs only) Adds another layer into the graph, as it can show values within the Line or Bar.
Rollup: selected value for the y-axis will be sum/group/average/etc....
Use a calculated field
The x-axis and y-axis, allow you to create a calculated field. Depending on the axis used, the field will allow you to concatenate field values or perform simple calculations.
X-axis and y-axis
These contain different lists to prevent the report from trying to compare the same data against itself.
This is usually set to sum, but you can choose from other options as needed.
(bar and line graphs only)
Adds another layer into the graph, as it can show values within the line or bar.
(key metrics only)
Allows you to add fields and choose how their operation, typically sum. It can also make a calculated metric, by which you can do math-based computations on the field of the dataset chosen.
If you are familiar with custom reports, then this should make sense as to how these work.
If not, then you can use this section as a way to limit (or specify) the amount of data used to generate the graph.
The big thing to note here is that if Prompt is checked, then you have to enter in search parameters in the graph to filter the results. If Prompt is not checked, then the parameters set here will filter the results automatically.
Before grouping - This section will filter based on the data in the system.
After grouping - This section will filter data based on the results, prior to displaying them.
Graph name - Defaults the report dataset used for the graph, can customize the name shown here.
Legend position - Default is Left, but you can choose from None, Left, Right, Top, or Bottom.
Report description - Adds a description that is shown when you click on the "?" next to the name of the graph.
Tab name - Default is blank, which is home. Graphs with the same tab name will be grouped together. This allows you to have logical groupings of graphs that the end user can switch between.
Maximum item count (pie graph only) - Determines the number of slices shown for the highest values, the remaining lower results are grouped into "Other".
Upper target and lower target (bar and line graph only) - Using these options can set a visual target that you are looking to measure against on your graph.
X-axis label and y-axis Label (bar and line graph only) - Adds a descriptive label below the x and y axis.
Owner - Shows the username for who originally created the graph.
Last modified - Shows the date the graph was last updated.
Visible to - Defaults to all security groups. However, you can limit which groups can see this graph.