March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi,
I am trying to do sum of likert scale category (1, 2, 3, 4, 5) by date drill down. Like when I drill down to month it should just show the cumulative sum of each category by that month total no of responses and so on. But now it is just showing total sum of categories but when drill down to month and day its sum runies. I made new table and grouped it by "Overall learning experience" and applied count rows operation but its not working when Drill down to month and day.
Please guide me how to group likert scale data and find cumulative sum of each category (1, 2, 3, 4, 5) and total responses by each month and days by using DAX or what so ever.
The pictures of the charts are attached below:
Please see my data below.
ID | Start time | Completion time | Name | How was slides sharing quality | How was sound quality | How was the camera quality | Overall learning experience | Any suggestions or issue you are facing? | Campus | Overall motivation | |
1 | 3/22/20 14:37:01 | 3/22/20 14:38:52 | XYZ@XYZ | XYZ | 5 | 5 | 5 | 5 | This is my first time to experience online classes which is very great if I see it as technology perspective. But the trainer's lecture was interesting which makes me engaged to the lecture. I really liked the online classes concept. | XYZ | 5 |
2 | 22/03/2020 14:44 | 22/03/2020 14:44 | XYZ@XYZ | XYZ | 5 | 5 | 5 | 5 | No | XYZ 2 | 3 |
3 | 22/03/2020 14:48 | 22/03/2020 14:49 | XYZ@XYZ | XYZ | 4 | 3 | 3 | 4 | Good working | XYZ 3 | 2 |
Solved! Go to Solution.
@Anonymous thanks for sharing the article. I will follow yr gudelines. Meanwhile I will try to communicate again. I have a data of 479 students who have given their feedback in lickert scale of 1-5. I want to count each of this catagory on each date hierarchy. For example, on May 1 what was the count of students who rated for scale 1, 2 3, 4 and 5. Similarly this will show for each day and I also want their sum. When I try to do that I do not get the actual sum of these counts.
If you still dont get I will try again to rephrase.
Regards.
@Anonymous thanks for sharing. I tried to work with it but still was stuck at some point. Is it possible if i send you teams meeting invation for further calrifications through which we could do screen sharing session...only if its fine to you.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
27 | |
17 | |
16 | |
12 | |
11 |
User | Count |
---|---|
38 | |
29 | |
22 | |
20 | |
18 |