topic Re: Straight table - expression column for only one of the dimension values as a comparator in App Development

Straight table - expression column for only one of the dimension values as a comparator

zakpullen — Tue, 03 Oct 2023 09:06:57 GMT

Hi,

I have a some survey data. One column holds organisation levels, including the highest organisation level. For example, 10 departments and the company as a whole. In a straight table I want to show the score per question for each department (or selected department), but also the score for the company as a comparator. When I try to do this, a new row is created for the company scores.

The raw data looks something like this:

I would like a straight table that looks something like this:

Many thanks.

Re: Straight table - expression column for only one of the dimension values as a comparator

justISO — Tue, 03 Oct 2023 10:41:42 GMT

Hi, to get Company score for question, you need to aggregate it. It can be done something like this:

aggr(nodistinct {<Category={'Company'}>} Avg(Score), [Question Number])

Additionally, you can change 'Category' dimension to 'if(Category<>'Company', Category)' and uncheck 'Include null values'. This way you'll see only departments.

Re: Straight table - expression column for only one of the dimension values as a comparator

zakpullen — Tue, 03 Oct 2023 14:43:39 GMT

Excellent. Thank you so much.