EazyBI: Count of variables from different reports

[Josh McKay]

Hello,

I'm still new to EazyBI and trying to learn how to create my own calculated members/measures. What I'm trying to accomplish is a count, at the bottom of the table, three columns that would possess a count of the total of the three possible variables for the cells, Safe, At Risk, and N/A. Here's what I have so far:

So, ideally there would be three more rows at the bottom of this table that would show something to the effect of
Safe:      1 | 3 | 4 | 2 | 0
At Risk:   0| 0 | 1 | 2 | 0
N/A:       0 | 0 | 0 | 1 | 0

These numbers are counts of that variable from all of the cells above it. There will be more columns and more rows in the completed table, this is just an example for an easy screenshot.

As an added bonus, if it would be possible, as a separate report, to remove all of the columns but still retain the data, and at the far right have 3 columns to display the count totals from each report, that would also be very much appreciated! But the above concern is my primary one.

Thank you for any advice, and if you need more information, please let me know!

[Gerda Grantiņa]

Hello @Josh McKay 

To achieve what you're looking for, I'd suggest the following approach:

1. Import the relevant fields (e.g. status, risk level) as dimensions in eazyBI.

2. Create a report using these dimensions, with measures to count the issues in each category.

3. Use calculated members or measures to aggregate the counts across different reports/categories.

4. Utilize the "Drill through issues" feature to see the specific issues behind each count.

This approach will allow you to create both the detailed table and the summary counts you described.

To learn more about eazyBI concepts and how to build reports, I highly recommend watching our training videos, especially Episode 3 which covers the basics of measures and dimensions:

See Training videos documentation

These videos will give you a solid foundation for creating the types of reports you need. Let me know if you have any other questions!

Kindly,
Gerda // support@eazybi.com