Forum Discussion
How to filter xAPI data (JSON)
Hello,
I am wondering how I can filter xAPI data that is in JSON format. An xAPI statement contains an actor, verb and object. See here: https://xapi.com/statements-101/
There are optional fields like "Results" that can be used to store how a user/learner answered a question. Below is a link to a xlsx file with example data. I want to be able to add multiple filters to see how users/learners answered.
Example:
How many learners answered "A" for question #2 that answered "B" for question #3. The issue when filtering is that learner response for all questions, in this case, questions #2 and #3 are all in the same column. I have worked around this by summarizing tables to get the actor and response then filter the summarized table to only see the results for question #3. This allows me to use slicers, but is very inefficient. We want to be able to filter on all of the data. Is there a better way to achieve this? How have others solved this challenge when working with JSON data?
Thanks in advance for all of the help!
-Matt
3 Replies
Hi, mpereiraTFF ,
You can check if these related post can is useful to you.
https://extended.traxlrs.com/docs/2.0/extended-api
https://docs.learninglocker.net/http-xapi-statements/
https://help.openstreetmap.org/questions/39026/json-from-a-xapi-query
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Thanks for sharing those links. However, they don't solve my problem. I don't have any issues getting the data into PowerBI, the issue I am having is filtering data because, all of the data is in the same column in powerbi. I want to be able to create reports that allows users with limited PowerBI knowledge to filter the data on all of the possible responses. I can filter using DAX, but I want users who are not familiar with DAX the ease of filtering data.
I am currently building additional tables for every result i want to filter on, which is time consuming. Ideally, there would be a function that could see all of the results and labels that go with the results, that I could use to filter against.
Thanks again,
-Matt
Hi, mpereiraTFF ,
Perhaps you can use RLS to filter each user at the row level.
https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls
https://www.biconnector.com/blog/power-bi-steps-to-setup-rls-row-level-security-static-and-dynamic/
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
