Report Development Approach

Christian Maldonado · 2025-04-17T13:42:10+00:00

There was an error rendering this rich post.

Hi,

I have a requirement to count all employees reporting to the managers and it can be direct count and total reporting count. For example, I have a data like this and we want to display the 2 calculated measures by employees:

In Power BI there is a function PATH() to handle the requirement.

How do we do this in BIRST Viz/dashboard?

Find more posts tagged with

Accepted answers

All comments

Diane McElhiney

One option is the use of STAT ( https://docs.infor.com/birst/2025.x/en-us/birstolh/default.html?helpcontent=birstug_bqlref/rfs1718720580559.html&hl=stat )

STAT (COUNT, 1,[employee_id], SELECT [manager_id] FROM [ALL] WHERE [employee_id] =%0)

You don't mention whether one or both IDs are defined as attributes, measures, or both. Whether these columns are in the same object (hierarchy or measure).

Christian Maldonado

Hi @Diane McElhiney
The employee_id is defined as both, and the manager_id is a measure.
And the grain of the fact is employee_id, and employee_id is mapped to [Employee Details] dimension.
We can adjust the model to handle the requirement.

How do we adjust the STAT() when we have the details like this and to derive the measures like "Direct Report Count" and "Total Report Count"?

Diane McElhiney

As you stated, 'derived column', you will be creating 2 report expressions, which then are two columns in the Visualizer.