Forum Discussion

RyanGilreath's avatar
RyanGilreath
Regular Visitor
3 years ago

Customer Voice - Matrix Question relating back to Parent question

Hello,

 

I've successfully linked my Customer Voice survey responses to PowerBI and have had a generally easy time of displaying simple "Ranking" style questions, as well as NPS and Choice.

The Matrix Choice questions however, have me stumped.

 

Where I am at right now is that there are two IDs in the "msfp_question" entity, 1 for the Parent Question and 1 for the Matrix options. What is the best way to relate these two so that I can display a table or matrix where the rows represent the individual respondents and the columns represent the Matrix question (parent and child). I have two of these in a survey and i'd like to use one visualization to represent them both.

 

Thanks in advance for any help!

Need Help

2 Replies

  • LukeGoble's avatar
    LukeGoble
    New Member
    3 years ago

    I'm having a similar issue. I have related the appropriate tables in Power BI, but for matrix type questions, the "Questiontext" values are null, making it impossible to pivot by question text.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    You can use msfp_sourceparentquestionidentifier from MatrixChoice row (child) to link with msfp_sourcequestionidentifier from MatrixChoiceGroup (parent) to connect child with parent question. They are both from msfp_question entity.