Analytics

 

If you are used to Pivot in Excel, then you will find this very similar.

In this article we will explain how to:

• Organizing data
  • Create favorite
  • Select data
  • Save setting
• Visualize your data
• Export
• Average values
• Formatting values
• Conditional formatting of values
• Create new Calculations
• Share a favorite
• Receive a shared favorite

Organizing data

Create favorite

First of all, you need to select the data you want to appear in your favorite.

1. Click on the star to create a favorite.
2. Name the favorite
3. Select the seasons you want to compare style data.
4. Click ok.

Style data will appear by default divided by season/category.

You can change this by selecting data as described below.

Select data

You can change columns and rows by clicking the "Fields" button.

• Use the search field to find the option you want to include
• Drag and drop it to either:
  • report filter (used for filtering data)
  • rows / columns
  • value (either count or sum of value)

Save setting

Each time you make changes, then a green save button will appear in the favorite tab.

Make sure to click save, if you want to keep your changes for next time.

Visualize your data

You can present data in different charts.

• Select a chart and choose the chart you want to have

Export

You can export both the grid and the charts in different formats.

Average values

In this module, you can also get the average values presented.

This is for example useful when looking at margins.

• Go to fields and search for a numeric option (for example Mark up)
• Drag it to Values
• Change from "Sum" to "Average"

Formatting values

In case too many digits appear, you can select "Format" and define the number of digits you want to appear.

Conditional formatting of values

Let's say you want to highlight values above or below a certain amount, then you can use Conditional formatting.

In this case, I want to highlight Mark Up values less than 3.

Create new Calculations

For all the numeric fields in Delogue PLM you can create Calculations.

In this example, I want to calculate an expected turnover by multiplying Expected Quantity and Wholesale Price.

Share a favorite

When you have set up the perfect Analytics report you might want to share it with others so they have access to the same setup.

You can easily share a saved favorite with your colleagues.

Simply select the favorite you want to share then click on the "Share Report" button

Now you will get a pop-up where you can select the users you want to share your favorite with.

Receive a shared favorite

When you receive a Share Analytics favorite it will be added to all your other favorites.

You can decide what to do with it. You can choose to edit it, rename it or delete it.