Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Simple average in eazyBI

Jeff Tillett Community Leader Dec 13, 2019

Not sure why, but every time I try to use "eazy" BI versus something like excel, it's WAY harder. :( Feedback from our company is that this product should be called "hardBI" LOL. 

I am trying to just do a simple average of the numbers that show up in eazyBI. Right now I have this: 

And all I want to do is calculate the average of all my out of compliance numbers. In excel, I highlight the numbers and click average. 

On paper, I just add them all and divide by 9. 

In eazyBi, this is like finding the holy grail. Everything wants to use times and ranges and other measures and all this super complicated stuff, and all I need to do is X+Y/2.

I figure if I can get a total, then I can figure out how to average it, but I can only get a total with the "total" button, which I can't use in any calculations. When trying to create a calculated measure to make a total, I can't get anything that works. 

I tried this: 

Aggregate([Measures].[Out of Compliance])

but it just spits out the same number next to each row, and isn't actually aggregating anything, and all the examples I can find in google are way more complicated than grabbing a simple total.  I tried stuff like

Aggregate([Measures].[Out of Compliance].CurrentHierarchy.Members)

however this results in error messages.

Then I run into the problem of getting it to count all of the non-empty rows for the average calculation. When I try 

Count([Measures].[Out of Compliance].CurrentHierarchy.Members)

then I always get "1", even though I can plainly see 9 members.

 

I love the power of eazyBI, but it's so non-intuitive for basic needs, that I'm struggling to understand if I should continue to promote this tool and renew, or let it drop. :( 

2 answers

1 accepted

1 vote
Answer accepted

Hi Jeff,

I am truly sorry to hear about your struggles with eazyBI! I hope we can find the solution for this case and I am happy to assist with any other questions to get over the undeniably steep learning curve of multi-dimensional data model and MDX.

Unfortunately, the image you are referring to in the question does not load (only for me?) 

But for calculating the average of a measure over the values from visible rows there is a great, and this time actually easy, predefined calculation possible - you can click on the measure you are interested in and choose Add calculated > Average (https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports#Createreports-Addstandardcalculationsbasedonaselectedmeasure)

4_2_Add_calculated

Please let me know more details if you are looking to calculate the average of some filtered set!

Lauma / support@eazybi.com

Jeff Tillett Community Leader Jan 08, 2020

Thanks Lauma, I'll add this to my toolbelt for future uses, but I am still having one small issue with this. 

My "measure" that I am averaging is an aggregate of children, where I only want the average of the children. I had ended up manually creating a custom measure to perform the average, which is now helpful is validating this built in average function, and helped me to understand that the built in average tool is giving me the average of both the "total" sum of all children in addition to the children themselves. This is causing the average to appear as ~ double what it truly is. 

I would be most appreciate if you could help me solve for that. 

Issues_-_Engineering_-_legacy_-_eazyBI.png

Jeff,

I'm happy to hear that the standard calculations will be useful for you!

For the follow-up question - the standard average is calculating an avg of all visible rows, including the All Crews and Squads row. You can see the formula that is used when you click on it and choose 'Edit calculated'.

If you would remove the first aggregating row and only have the values from the same level, you would get the average of those eleven rows. 

Let me know if there is anything else I can assist you with!
Lauma / support@eazybi.com

Jeff Tillett Community Leader Jan 10, 2020

So I would still need to continue to manually calculate my average as a custom measure since I can't modify the built in function to only include children in the calculation?

@Jeff Tillett,

Yes, the built-in formula cannot be modified and if you wish to exclude something from the set over which to calculate the average, it needs to be done in a separate calculation.

Nevertheless, you can copy the pre-calculation formula and paste in your new measure calculation and then add filter, case or other modifications.

Lauma / support@eazybi.com

0 votes
edwin vasquez Community Leader Dec 13, 2019

EazyBI is not as easy as the name says it is lol
Wish I could help, but I need more practice myself.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Service Management

JSM June Challenge #2: Share how your business teams became ITSM rockstars

For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...

326 views 9 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you