Thanks for your reply.
Yes have specific question as follows:
- Replicate graph (page-5 pdf).
- I am stuck when it comes to the core (e.g.: build syntax/formula/measurement) to produce the number (refer screen shot):
I have de-identifed the report (pdf) above, but due to privacy issue I can't upload/shared QSense file in this forum as it's using live datamart data from Datawarehouse.
There's no easy way to explain my problem in written, I will take sometime to create video/screen recording and share the file once it's done. Luckily this forum has function to upload video upload.
Hopefully by sharing real issue & solution visually might benefit other users.
We found out that the issues lies in the datawarehouse (e.g.: datamart) that caused figures is not matched.
Herewith some screen shot of datamart structure for your information (not sure whether its useful).
I also shared screen recording.
I am happy to set-up private meet & greet session and shared recorded session with QSense learning community.
Sometimes internet meeting (e.g.: screen sharing) is much quicker way than screen shots with written description.
Once again thanks for your reply.
Thank you for the video and screenshot.
As far as I can tell, the expression in the stacked bar chart in question has a set analysis statement that's referencing a field name 'RESPONSE_TEXT' that I do not see in the screenshot of the tables. Is 'RESPONSE_TEXT' a field that is present in the data model you sent me a screenshot of and I cannot see it? If not, what field corresponds to the 'Strongly Disagree' to 'Strongly Agree' values?
Also, once you've determined the field that corresponds with the 'Strongly Disagree' - 'Strongly Agree' values, try setting up your graph as such:
I gave each set analysis expression it's own measure. In my example, I wanted to show yearly sales by Salesperson, so I used a set analysis statement for each year and gave it a separate measure. Similarly, you want to use a set analysis expression for the student response and give each it's own measure.
See if this helps. I think there may be some data model issues, as you stated. Again, first find the field that corresponds to the values you are looking for, then generate a separate measure using a set analysis statement for each, similarly to how I did above.