 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
|
|
|
|
|
|
 Rank: Administration
Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 433
|
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.  Ole Dyring |
|
|
|
|
|
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.
|
|
|
|
|
|
 Rank: Advanced Member
Groups: extranet\Forum
Joined: 4/5/2011(UTC)
Posts: 110
|
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. |
|
|
|
|
|
|
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.