Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two table Table 1: List of Questions (Skill 1, Skill 2 etc) and Choice of 4 Answers (No Knowledge, Basic, Proficient, Expert)
Table 2: A table of just the 4 Answers (No Knowledge, Basic, Proficient, Expert) for LookUp.
I want to create a simple chart with the Level aon the X-Axis (No Knowledge, Basic, Proficient, Expert) and the count by each Question (Skill 1, 2 etc) . Should be easy to do but I can't get the results despite trying many things including how the table are joined etc.
thanks ! Ketan
Of course- here is the chart done in excel after some calculations.
Hi,
Modify your script as below
[Table 1]:
LOAD
[Skill 1] as level,
'Skill_1' as Skill
FROM [lib://AttachedFiles/Sample_Community.xlsx]
(ooxml, embedded labels, table is [Table 1]);
Concatenate
LOAD
[Skills 2] as level,
'Skill_2' as Skill
FROM [lib://AttachedFiles/Sample_Community.xlsx]
(ooxml, embedded labels, table is [Table 1]);
[Table 2]:
LOAD
[Level] as level
FROM [lib://AttachedFiles/Sample_Community.xlsx]
(ooxml, embedded labels, table is [Table 2]);
Then In front end use bar chart
take
Dimension : level
Measure :
1: Count({<Skill={'Skill_1'}>}Skill)
2: Count({<Skill={'Skill_2'}>}Skill)
Regards,
Prashant Sangle
hi
i would have used this method
using the cross table function of table 1
[Table 1]:
CrossTable(Skill,Level,1)
LOAD rowno() as ID ,
[Skill 1],
[Skills 2]
FROM [lib://AttachedFiles/Sample_Community.xlsx]
(ooxml, embedded labels, table is [Table 1]);
then you'll be able to create your chart
Level as 1st dimension
Skill as 2nd dimension
count(ID) as your expression