en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Mads Sheye  
#1 Posted : Monday, March 24, 2014 2:34:39 PM(UTC)
Mads Sheye
Rank: Advanced Member

Groups: extranet\Forum
Joined: 10/29/2013(UTC)
Posts: 11

Hi,

If my measure contain text and not numbers, which type of measure should I take to illustrate this?

M
Ole  
#2 Posted : Monday, March 24, 2014 2:58:43 PM(UTC)
Ole
Rank: Administration

Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 320

Then it is not a measure. :-) Measures must be based on numerical data types. You should probably create it as a dimension instead. The "Table" object type, as opposed to the "cross table" object type, in the TARGIT client allows you to display data without including a measure..

BR /Ole
I work as an employee with TARGIT A/S. Any statement made by me in this forum represents my own opinion and state of mind, and is not necessarily related to or representative of TARGIT A/S.

UserPostedImage Ole Dyring
Mads Sheye  
#3 Posted : Monday, March 24, 2014 3:12:54 PM(UTC)
Mads Sheye
Rank: Advanced Member

Groups: extranet\Forum
Joined: 10/29/2013(UTC)
Posts: 11

Ok. It is a part of a survey. This section of the text contains socalled "fritekst" where people can write their own thoughts whereas the rest of the survey is mutiple choice. You still believe this is the correct way. It needs to be linked with the additional Q.
Niels Thomsen  
#4 Posted : Tuesday, March 25, 2014 3:19:07 PM(UTC)
Niels Thomsen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/5/2011(UTC)
Posts: 103

Hi Mads

The multiple choice part of the answers could be represented by count measures.
One way to reflect a survey in a dimensional model could be to make a number of dimensions and measures:

Dim_Q1
Dim_Answer1
Measure_Answer1

Dim_Q2
Dim_Answer2
Measure_Answer2

The measures would be count-measures counting the spread of the corresponding Dim_Answer.
This would enable you to build objects in TARGIT - one per Q&A - and use the drilldown feature in TARGIT to investigate in depth the obtained survey material.

The freetext answers should be dimensions - such as Dim_FreeAnswer - and would in TARGIT only be meaningful in tables with no measures assigned.

Hope it makes sense.
Hope it makes sense.

Best Regards
Niels Thomsen

https://dk.linkedin.com/in/ncthomsen


Users browsing this topic
Anonymous
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error