Skip to main content
All CollectionsBusiness Analytics
Creating Custom Business Analytics
Creating Custom Business Analytics
A
Written by Ashok P
Updated over a week ago

You can create your own custom Business Analytics (BA) from scratch or you can clone existing BA to modify them.

Keep in mind that any edits to our default BA are only temporary and will not be saved. So if you find yourself constantly modifying the stock BA, you will want to create your own with all of your preferences.

You can open the Business Analytics Explorer via Start > Reports > Business Analytics.

start menu.jpg

When you click the New button you will then choose from Chart or List and then choose an entity, e.g. Project, Purchase Orders, etc.

new button.jpg

Chart BA

new chart ba.jpg

The entity chosen will dictate what grouping options display. You can choose as many groupings as you want for your BA and then set one of them to be the default selection.

groups.jpg

You can choose one or two data sets for the BA.

Shown below are the options for the Project entity, this list will vary based on the entity.

data set fields.jpg

Most of the fields are self-explanatory but here is an explanation of a few. Projected Total Price and Projected Profit are multiplied by the Probability Percentage of the Project Status.

probability.jpg

Once you choose a field, you then choose an operator and can also change the color of the data set when creating a Column or Bar chart.

operator.jpg

The Filter tab is a query that you can build to suit your needs.

Shown below are the default clauses for a Project BA.

chart filter.jpg

List BA

A list-type BA has three tabs to allow you to create the output desired.

On the Fields tab, there is a list of available fields. You can use the arrows to choose which field you want and then use the up/down arrows to put the fields in the order you want.

list fields.jpg

On the Sorting tab, you can then choose your preferred sorting of the list.

list sorting.jpg

Just as with chart-type BA, the Filter tab is a query that you can build to suit your needs. Shown below are the default clauses for a Project BA.

list filter.jpg
Did this answer your question?