Graphs

Manage Graphs via Settings

Oliver Zdravkovski avatar
Written by Oliver Zdravkovski
Updated over a week ago

In this help doc


Graph Settings


Templates


Import Graphs - Example

In this example, we will be creating new graphs with the most basic import fields.

  1. Click Settings

  2. Expand your Organization

  3. Click on Graphs

  4. Click Import Graphs

  5. Download Sample CSV file and populate it with the needed values. Not all columns are required. See sample above. All graphs are standard graphs except Bills. The Bills graph is inverted (upside down) graph. Even though Frequency is not specified, it will be set to Weekly as a default setting.

  6. Choose File you want to import

  7. Enter Email address to receive the import results

  8. Click Start Importing

  9. The status of the import will be displayed. Also, here you can see all your previous imports.

Once values are entered, the graphs will look like the image above.

See also:


Import Values - Example

  1. Click Settings

  2. Expand your Organization

  3. Click on Graphs

  4. Click Import Values

  5. Download Sample CSV file and populate it with the needed values.

    NOTE: The Sample CSV file will contain all your graphs. You only need to enter values for the needed graphs. If you leave the fields empty for the other graphs, it won't replace their existing values with zero. See sample above.

  6. Choose File you want to import

  7. Enter Email address to receive the import results

  8. Upload

Once the values are imported, the graphs will look like the image above.


Mass Delete Graphs via Import

It's possible to delete multiple graphs via the Graph Import feature.

All you need is the Graph ID and a column with the heading Delete as shown below.

To obtain a list of Graph IDs, export Graphs via the Data Export.

Remove the Graph IDs for graphs you do not want to delete or use FALSE in the Delete column if are updating other graphs via the same import.

See also:


View Previous Imports

  1. Click Settings

  2. Expand your Organization

  3. Click on Graphs

  4. Click Import Graphs

  5. Click View Previous Imports

  6. All previous imports will be displayed


Duplicate Graphs


Find a Graph

To find a specific graph or graphs:

  1. Click Settings

  2. Expand your Organization

  3. Click on Graphs

  4. If you have more than one Team Chart, you can select the desired one. It will automatically update the results.

  5. You can select a specific Team from the Team Chart. To update the results, click the Filter button.

  6. You can select one or more Graph Groups. To update the results, click the Filter button.

  7. You can select the Type of graph: Daily, Weekly, Monthly, Quarterly, Yearly, etc. You can select a single or multiple options in this filter.

  8. Select Active, Hidden, Archived or Deleted. You can select a single or multiple options in this filter.

  9. You can search by a keyword. To update the results, click the Filter button.

  10. It will list all desired graphs.

    NOTE: If you have more than 100 graphs, it will list 20 at a time. This is to avoid unnecessary load on your web browser every time you open the Graphs settings.


Open a Graph

  1. Click Settings

  2. Expand your Organization

  3. Click on Graphs

  4. Click Open on the desired graph


Edit a Graph

  1. Click Settings

  2. Expand your Organization

  3. Click on Graphs

  4. Click Edit on the desired graph

  5. Click Copy to make a copy of the graph. The values will not be copied.

  6. Click Convert to change the default graph type frequency. If it's a weekly graph, you can convert it to Daily, Monthly, Quarterly or Yearly graph. See TIPS & TRICKS: Converting Graph Frequency for more info.

  7. You can Archive the graph in case it's not in use at the moment but will be used in future.

  8. You can Delete the graph if it's not needed.

    NOTE: You can restore deleted graphs within 90 days.

  9. You can choose a different Organization if you want to move the graph there.

  10. You can change the Name of the graph

  11. You can add a Description for the graph

  12. If the graph doesn't have any values, you can change the default Graph Type frequency. If it has values, you would need to use the Convert function in step 6.

  13. You can change the default View Frequency of the graph - Weekly, Monthly, Quarterly or Yearly

  14. Hidden will not display the graph in the Search menu. See TIPS & TRICKS: The Hidden Graph Feature.

  15. You can add the graph in Graph Groups

  16. Missing Entries deals with missing values. It can either show the gap, display "0" or hide the missing value.

  17. Show line for incomplete period will show a line even though the period has not ended. For example, if it's a weekly graph, the line will be visible for the present week even though the week has not ended.

  18. Days to collect data is useful when daily graphs are used. It will collect data on all or specific days. There are two options: Organization's default data collection days and Custom data collection days.
    NOTE: When Organization's default data collection days option is selected, it will use the global setting for Data collection days. See step 6 in Editing Graph Settings for more info.
    When Custom data collection days option is selected, you can select the desired days. For example, if Saturday and Sunday are excluded, they won't appear on the graph. See image above.

  19. Allowed overdue days refers to the number of days that a value can be left blank before it is considered overdue.

  20. You can Invert Graph. This means the lower values are better.

  21. You can show or hide values on a graph

  22. Show incomplete values indicator displays an asterisk if a graph has a missing value

  23. Show average line displays a line which calculates the average of all values. See Always Show The Average Line for more info.

  24. Show cumulative line displays the cumulative total of a graph

  25. How should values be aggregated determines how values are displayed at lower frequencies. For example, it can display all values in the period, the average of all values, the minimum / maximum value within the period, the first or last reported value of the period.

  26. You can add Decimal Places for the values

  27. You can set a Minimum / Maximum Value for the graph. If there is a value outside of this scope, the scope will be ignored.

  28. Restrict chart to minimum and maximum values means that if there is a value outside of the scope, it will not be visible on the graph.

  29. Viability Value is the minimum value that is needed for the business to survive and to continue to expand. This will add a horizontal dashed line on the graph, representing your target value. See Using the Viability Line for more info.

  30. You can use a Unit Symbol, if needed.

  31. You can add a Quota and Quota line color. A Quota is the daily or weekly amount you need to meet in order to achieve the target. See TIPS & TRICKS: Quotas & Targets for more info.

  32. You can specify Targets and Target line color. A target is what you want to achieve by a certain date. For example, $200,000 in sales by the end of the month.

  33. Custom Attributes - This is primarily a way to add additional metadata to a graph. For example, you might have your own internal ID number for each graph. You can add a custom attribute named "Internal ID" and give it a value. Then any time in the future you can go back to the Custom Attributes section to see what it's set to. This is often implemented when using our API v4. If you have no custom attributes, leave this blank. If you have not created any Custom Attributes as in the image above, see Custom Attribute Fields.

  34. To assign the graph to a member, select the desired Responsible Member.

    NOTE: If the member is moved to a different position or removed from the Organization, all of the member's graphs will need to be reassigned to another member.

  35. To assign the graph to a position, select the desired Responsible Position.

    NOTE: If a member is moved to a different position or removed from the Organization, all of the member's graphs will remain assigned to the position and there is no need to reassign the graphs to the new member.

  36. Select the graph permissions you would like to assign to the member or position

  37. Permissions lets you assign group permissions aside from the permissions that the member has. This is useful if other members needs to have access to the graph.

  38. Save Changes


Archive a Graph

  1. Click Settings

  2. Expand your Organization

  3. Click on Graphs

  4. Click on Archive


Delete a Graph

  1. Click Settings

  2. Expand your Organization

  3. Click on Graphs

  4. Click on Delete

    NOTE: You can restore a graph if deleted within 90 days


Archive or Delete Graphs in Bulk

Archive or Delete specific graphs

  1. Click Settings

  2. Expand your Organization

  3. Click on Graphs

  4. Select the desired graphs or click the checkbox next to the Name column to select all listed graphs

  5. Click Archive or Delete

Delete all archived graphs

Before you remove your archived graphs, ensure that you don't have calculated graphs that are using any archived graph. If that's the case and the archived graph is removed, the calculated graph will lose these values.

The whole purpose of archived graphs is to preserve the values in case they are needed for future or if they are in use in a calculated graph. Once the graphs are removed, the data will not be available after 90 days.

If you are sure that you want to remove the archived graphs, follow these steps:

  1. Click Settings

  2. Expand your Organization

  3. Click on Graphs

  4. Select Archived

  5. Select All

  6. Click Delete


Restore a Graph

Restore an Individual Graph

  1. Click Settings

  2. Expand your Organization

  3. Click on Graphs

  4. Select Archived or Deleted or both

  5. Click Filter

  6. It will open all Archived or Deleted graphs. Click Unarchive or Restore on the desired graph.

Restore Archived Graphs in Bulk

  1. Click Settings

  2. Expand your Organization

  3. Click on Graphs

  4. Select Archived

  5. Click Filter

  6. It will open all Archived graphs. You can see the Status as "Archived". Select the desired graphs or Select All.

  7. Click Unarchive

Restore Deleted Graphs in Bulk

  1. Click Settings

  2. Expand your Organization

  3. Click on Graphs

  4. Select Deleted

  5. Click Filter

  6. It will open all Deleted graphs. Select the desired graphs or Select All.

  7. Click Restore Deleted


Assign a Responsible Member for Multiple Graphs in Bulk

  1. Click Settings

  2. Expand your Organization

  3. Click on Graphs

  4. Select the desired graphs

  5. Select a responsible member

  6. You can also assign the graphs to the member's position

  7. Assign Member


Show who archived a Graph

  1. Click Settings

  2. Expand your Organization

  3. Click on Graphs

  4. Select Archived

  5. Click Filter

  6. Click Open on the archived graph

  7. Click the 3-dot menu

  8. Click Graph Info

  9. It will display the member name


Did this answer your question?