Weighted avarage used for satisfaction rating

Questions & Answers
1

Hi.
I’m creating a chart of avarage satisfaction for a project. The problem is that the majority of tickets are without rating. I wanted to ask how to create a weighted avarage of tickets from hierarchy levels 1 to 5 while excluding the level (none).

Here is the current version without the avarage:

image
image1531×570 21.6 KB

2

Hi, @Sebastian.Rataj

I’m sorry for not answering sooner.

Please switch to the Table view and remove the unwanted entries by deleting them.

The simplest solution would be to import “Client Satisfaction” (that is my rating field name; please substitute with your own) into eazyBI as a dimension, use a tuple to count all the issues, then multiply by each weight, and divide it by entries that have ratings.

Let’s first define a new calculated member - call it “Raiting” in the “Client Satisfaction” dimension, that will get only the issues with rating. I’m using Aggregate() and Except().

Aggregate(
  Except(
    [Client Satisfaction].[Client Satisfaction].Members,
    {[Client Satisfaction].[(none)]}
  )
)

Then create a new calculated measure with the formula:

(([Measures].[Issues created],
[Client Satisfaction].[1])*1
+
([Measures].[Issues created],
[Client Satisfaction].[2])*2
+
([Measures].[Issues created],
[Client Satisfaction].[3])*3
+
([Measures].[Issues created],
[Client Satisfaction].[4])*4
+
([Measures].[Issues created],
[Client Satisfaction].[5])*5)
/
([Measures].[Issues created],
[Client Satisfaction].[Rating])

Kindly,
Ilze