Guidance on Aggregating Data from Multiple Custom Fields in eazyBI Report

Questions & Answers
1

Hello

I am now working on a report where I need to aggregate data from multiple custom fields into a single view. I aim to combine data from the following custom fields:

Custom Field A: This field captures the “Issue Priority” for each task, ranging from “High” to “Low” based on its importance and urgency.

Custom Field B: This field records the “Time Spent” by each team member on a particular task, measured in hours.

Custom Field C: This field contains the “Issue Status” indicating the current stage of completion for each task, such as “To Do,” “In Progress,” or “Done.”

Combining insights from these custom fields will provide a comprehensive view of task management and resource utilization within our project. However, I’m facing challenges in consolidating this information effectively within eazyBI.

After reviewing the eazyBI documentation and exploring various options within the tool, I’m still unclear on how to proceed with this aggregation. I understand the importance of accurate data representation and want to ensure that the report effectively captures the information from these custom fields.

Could someone please provide guidance on how to achieve this in eazyBI?

Thank you in advance for your assistance and support!

Best regards,
boblewis

4

Hi @boblewis

Thanks for the details, and apologies for the late reply! This thread missed our workflow.

Combining several dimension members starts by importing each of these custom fields into eazyBI:
For Custom fields A and C, you can import them as dimensions and, if the Custom Field B is a numeric value, you can import it as a measure.

Then, when creating a report, you can define a new measure in the Measures dimension with a formula like this:

(
  [Measures].[Time Spent],
  [Priority].[High],
  [Status].[Done]
)

This is called a tuple and is the fastest way for the report engine to return the results of multiple dimension selections.

​Let me know if you have any additional questions on this!
​Best regards,
​Nauris