8 Replies Latest reply on Aug 7, 2018 2:14 PM by Jaya Sinnathamby

# LOD For Survey Question using Likert Scale

A very common question in surveys is level of satisfaction type question with a response scale of 1-5.

I want to show the Average Score for a question, aggregated at a higher level side by side with the detail score, but I'm unable to come up with the right LOD calculation.

So I want to go from here showing the Average Score for each city:

 Avg Score MD Baltimore 2017 3.0 2018 3.0 Bowie 2017 1.5 2018 3.7 Towson 2017 2.5 2018 4.0 VA Alexandria 2017 3.5 2018 2.7 Arlington 2017 4.0 2018 3.0 Richmond 2017 2.0 2018 3.3

to here showing the Avg Score by State as well as Year in the same chart.

Thanks, Jaya

Ver 2018.1

• ###### 1. Re: LOD For Survey Question using Likert Scale

Hi Jaya,

Check my solution using separate LODs for each calc. Workbook attached.

Thanks,

Seth

• ###### 2. Re: LOD For Survey Question using Likert Scale

Hi Jaya,

and

Thanks,

Mavis

• ###### 3. Re: LOD For Survey Question using Likert Scale

That was fast!

Do you mind explaining why use SUM?

I created the same LOD calcl, but in mind it should be ATTR and I just couldn't get past that. I still can't!

• ###### 4. Re: LOD For Survey Question using Likert Scale

Thanks guys - you posted similar solutions within 2 minutes of each other.

Still wrapping my mind around LOD.

Jaya

• ###### 5. Re: LOD For Survey Question using Likert Scale

Jaya,

The FIXED calculation is going to "fix" the calculation after the colon (:) to the dimension that is defined before the colon.

In this example, the Year Score calculation reads as follows.

{ FIXED [Year]: AVG([Score])}

The calculation is computed only at the defined level, regardless of what else is included in the view.

The SUM() function is used because AVG is defined in the LOD calc itself.

Hope this helps,

Seth

• ###### 6. Re: LOD For Survey Question using Likert Scale

Are you saying the SUM function is more a syntactic requirement rather than doing anything?

OK – I just tried it with MIN, MAX and AVG and got the same answer.

A bit confusing, but I will live with it.

jaya

• ###### 7. Re: LOD For Survey Question using Likert Scale

Jaya,

Because the dimension we are using to FIX the calculation is defined in the view, the SUM() function does serve as more of a syntactic requirement in this case.

If [Year] were not in the view, the SUM() function would no longer fit the requirement.

Seth

• ###### 8. Re: LOD For Survey Question using Likert Scale

Seth,

Thank you – much appreciated.

Jaya