How Can You Enhance Understanding of Complex Data Using the INTERACTIVE METRICS READER?

Enhance User Understanding of Complex Data Using the INTERACTIVE METRICS READER

INTERACTIVE METRICS READER enables you to generate charts using properly formatted CSV data files within the 3DEXPERIENCE Platform.
It is useful for analyzing your data, and the charts can be easily added to dashboards for comparison. These visualizations make it easier for observers to understand the information being presented.
Before starting to use this app, it is important to understand the key concepts, capabilities and the app’s specific user interface.

User Interface

1- Title
2- Chart Type or INTERACTIVE METRICS READER Status
3- Export, and publish to 3DSwym
4- Drag to Compare
5- Chart or Log Area
6- Credits Area
7- Details and Insights Tabs

Step 1:

If no chart has ever been created, click Configure on the splash screen.
If you have a .CSV or .XLSX file, you can import it using the INTERACTIVE METRICS READER from the 3DDrive, but only aspects stored in the 3DDrive space will be available.
Supported File Format

To work with INTERACTIVE METRICS READER, the first step is to add it to the dashboard for comparison or analysis.
1. CSV
2. XLSX
3. TXT
4. ODS

Step 2:

Either by clicking 'Configure' or by dragging and dropping a file from 3DDrive, the 'Data Type' page will appear. There are three options available to create the chart.

Quantitative Time-series

To import a group of numbers recorded at regular time intervals.
For example:

An assembly line is monitored hourly, weekly or monthly production scale to track how many units are produced.
How many internal or client-driven change requests were submitted and implemented during the design cycle

Quantitative Series

To import a group of words or categories that are linked to a number.
For example:
Shift vs. Defect Rate (%) – (Morning — 2.5%, Afternoon — 3.0%, Night — 4.2%)
Material Type vs. Cost per Kg – (Steel — $2.5/kg, Aluminium — $3.2/kg, Plastic — $1.2/kg, Copper — $5.8/kg)

Qualitative Series

To import a set of non-numerical values like not a measured value.
For example:

Defect ID	Defect Type
001	Surface Scratch
002	Misalignment
003	Cracks
004	Paint Defect
Defect ID is numerical but just acts as an identifier, not a measured value.

So, you can create charts with these three kinds of data using the INTERACTIVE METRICS READER.

Step 3:

After selecting data type there is three option to import your data

1) Cloud

If your file is stored in another cloud space, you can use the ‘Cloud' option. Simply enter the file's share link or URL in the provided URL field. If the file is protected, you will need to enter your login credentials. If the file is public and has editable access, just entering the URL is sufficient. Once imported, a chart will be generated and automatically synced with cloud sources.

2) Paste Data

Click on 'Paste data' and paste the data you have copied into your clipboard. Please make sure to delete the example text first, as it's only there to show the expected format.

3) Dropped file

Select Dropped file option to drag a file from your 3DDrive.

4) File type

If a file type selection option appears, choose the format that matches the file you imported in type1 and type3. This option will only be shown if the wizard is unable to automatically detect the file type.

Step 4:

Select Range Option for Quantitative Time-Series

Update Frequency:
Choose how often you want to update the data:
Select Manually if you want to get the new data from the original file yourself.
Select Automatically every and enter how often INTERACTIVE METRICS READER should check and get new data from original file.
We can set the time period as Hours, Days, Weeks, Months.

Note: If you are a 3DPassport Administrator, automatic updates will not work and will show an error. You can only update the data manually.
Reset data before updating – is check-in
Whenever INTERACTIVE METRICS READER checks the cloud file, it will get any new data and also remove any data that was deleted from the file.
Reset data before updating – is not check-in
Whenever INTERACTIVE METRICS READER checks the cloud file, it will get any new data, but it will not remove any data from its chart—even if that data was deleted from the cloud file.
What do you want to chart?
To chart all columns from your data set using INTERACTIVE METRICS READER, enter * (an asterisk).
If you only want to chart specific columns, enter the column numbers. For example, if column 1 is a date and columns 2, 3, and 4 are data columns, but you only want to chart columns 2 and 3, enter 2,3.
Advanced Option
From the Import Time zone list, choose the time zone that matches the dates in your data set.
Note: The preview will always show the dates in your local time zone.
So, if your local time zone is different from the one you selected, the preview will convert the dates to your local time.
For example, if your data set has the date '01/01/01 00:00:00' and you select 'UTC' as the import time zone while working from Paris (in summer), the preview will show the date as '01/01/01 02h'.
After setup, the widget will display dates based on the time zone you select in the widget settings.
In the Date Column field, enter the number of the column that contains the dates in your data set.
Then, from the Date Format list, select the format used for the dates in your data.
Show Result as
From the Show results as list, select an option to decide how you want the data to be displayed in the Details tab of INTERACTIVE METRICS READER.
Note: This setting does not affect the chart itself. It only appears as information in the Details tab.

Select Range Option for Quantitative Series

The Quantitative Series option works the same way as Quantitative Time-Series, but unlike Quantitative Time-Series, it does not include time-based data.

Select Range Option for Qualitative Series

However, Qualitative Series can only chart one column from your data set.

This option works the same way as Quantitative Series—you need to select the column from your data set that will be charted by INTERACTIVE METRICS READER.

Step 5:

You can customize the appearance of your chart in the Customize Step of the wizard.

1) Optional Customizations:

For each series, click Settings to:

Click the Colour square to change the series colour.

For Qualitative Time-Series, you can select Smooth curve and Linear regression to add statistical curves to the chart.

Based on the Show results as option you selected in step 3 – Select range – you can uncheck Total, Average, Maximum, or Minimum to hide that information from the Details tab.

2) In the Credit section:

In the Name field, enter the name of the data set owner.
In the Source URL field, enter a website link (such as the owner's website or the file’s cloud storage URL).
Once the widget is set up, the name will appear below the chart.
If a URL is provided, the name becomes a clickable link that opens in a new window.

Note: Your 3DEXPERIENCE platform must be connected to the internet if the URL links to an external online resource.

Search This Blog

EGS India | Official Blog