Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I need help for this project in power bi and I have started with it.
I have a table associate to a database (with a lot of information).
This table generates a line for each case entered into a system, so it is repeated in multiple occasions. (I enclose the example).
What I need to do is create a way to indicate how many times a person makes the mistake.
But in the database it would look like this:
I should also consider that errors are associated with people and dates.
Could you help with this?
I appreciate any help that you can give me
Regards,
Solved! Go to Solution.
Hi @Ljimenez14,
If I understand you correctly, please modify the calculated table as below:
Table 2 =
var error1 = SELECTCOLUMNS('Table',"name",'Table'[Name],"date",'Table'[Case Date],"error",'Table'[Error 1],"quantity",'Table'[Quantity 1])
var error2 = SELECTCOLUMNS('Table',"name",'Table'[Name],"date",'Table'[Case Date],"error",'Table'[Error 2],"quantity",'Table'[Quantity 2])
var error3 = SELECTCOLUMNS('Table',"name",'Table'[Name],"date",'Table'[Case Date],"error",'Table'[Error 3],"quantity",'Table'[Quantity 3])
var error4 = SELECTCOLUMNS('Table',"name",'Table'[Name],"date",'Table'[Case Date],"error",'Table'[Error 4],"quantity",'Table'[Quantity 4])
var error5 = SELECTCOLUMNS('Table',"name",'Table'[Name],"date",'Table'[Case Date],"error",'Table'[Error 5],"quantity",'Table'[Quantity 5])
return
UNION(error1,error2,error3,error4,error5)
Result would be shown as below:
BTW, Pbix as attached. Hopefully works for you.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Ljimenez14 ,
Please check following steps as below:
1. Create calculated table:
Table 2 =
var title1 = SELECTCOLUMNS('Table',"title",'Table'[title1],"quantity",'Table'[quantity1])
var title2 = SELECTCOLUMNS('Table',"title",'Table'[title2],"quantity",'Table'[quantity2])
var title3 = SELECTCOLUMNS('Table',"title",'Table'[title3],"quantity",'Table'[quantity3])
return
UNION(title1,title2,title3)
2. Create table visual:
3. Result would be shown as below:
BTW, Pbix as attached. Hopefully works for you.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your previous answer. I have an idea right now.
But what happen if I need add other columns. For example one with dates and other with names?
The idea is to be able to visualize (by month) how many mistakes a person made. Is it possible?
I already have the table with these columns.
Which are the next steps to add new columns?
Thanks in advance!
Hi @Ljimenez14 ,
What are the relationships between user, date and error? Are they in the same table or different tables?
Please share some sample data to me if you don't have any Confidential Information.
Best Reagrd,
jay
I will share with you a real example.
Id | Name | Location | Case Date | type_item | score | title1_name | theme1_title1 | Error 1 | Quantity 1 | Theme 1 | Error 2 | Quantity 2 | Error 3 | Quantity 3 | Error 4 | Quantity 4 | Error 5 | Quantity 5 |
79199 | Agent 1 | Manila | 10/1/2019 18:48 | Regular | 60 | SERVICE DELIVERY | Opening | Error 1 | 0 | Process Knowledge | Error 2 | 1 | Error 3 | 1 | Error 4 | 1 | Error 5 | 0 |
87636 | Agent 2 | Manila | 10/15/2019 20:11 | Regular | 70 | SERVICE DELIVERY | Opening | Error 1 | 0 | Process Knowledge | Error 2 | 1 | Error 3 | 0 | Error 4 | 0 | Error 5 | 0 |
88310 | Agent 3 | Manila | 10/16/2019 17:37 | Regular | 60 | SERVICE DELIVERY | Opening | Error 1 | 0 | Process Knowledge | Error 2 | 1 | Error 3 | 0 | Error 4 | 0 | Error 5 | 0 |
91047 | Agent 3 | Manila | 10/21/2019 19:43 | Regular | 0 | SERVICE DELIVERY | Opening | Error 1 | 0 | Process Knowledge | Error 2 | 1 | Error 3 | 0 | Error 4 | 0 | Error 5 | 1 |
93431 | Agent 4 | Manila | 10/24/2019 18:17 | Regular | 100 | SERVICE DELIVERY | Opening | Error 1 | 0 | Process Knowledge | Error 2 | 1 | Error 3 | 0 | Error 4 | 1 | Error 5 | 0 |
95674 | Agent 5 | Manila | 10/29/2019 14:10 | Regular | 50 | SERVICE DELIVERY | Opening | Error 1 | 0 | Process Knowledge | Error 2 | 0 | Error 3 | 1 | Error 4 | 0 | Error 5 | 0 |
80609 | Agent 6 | Manila | 10/3/2019 23:11 | Regular | 60 | SERVICE DELIVERY | Opening | Error 1 | 1 | Process Knowledge | Error 2 | 1 | Error 3 | 0 | Error 4 | 0 | Error 5 | 0 |
89793 | Agent 2 | Manila | 10/18/2019 19:41 | Regular | 100 | SERVICE DELIVERY | Opening | Error 1 | 1 | Process Knowledge | Error 2 | 1 | Error 3 | 0 | Error 4 | 0 | Error 5 | 0 |
91739 | Agent 3 | Manila | 10/22/2019 17:28 | Regular | 80 | SERVICE DELIVERY | Opening | Error 1 | 1 | Process Knowledge | Error 2 | 1 | Error 3 | 0 | Error 4 | 1 | Error 5 | 0 |
81073 | Agent 4 | Manila | 10/4/2019 17:53 | Regular | 20 | SERVICE DELIVERY | Opening | Error 1 | 0 | Process Knowledge | Error 2 | 1 | Error 3 | 0 | Error 4 | 0 | Error 5 | 0 |
79685 | Agent 6 | Manila | 10/2/2019 18:40 | Regular | 60 | SERVICE DELIVERY | Opening | Error 1 | 1 | Process Knowledge | Error 2 | 1 | Error 3 | 1 | Error 4 | 0 | Error 5 | 0 |
86155 | Agent 1 | Manila | 10/12/2019 19:48 | Regular | 10 | SERVICE DELIVERY | Opening | Error 1 | 1 | Process Knowledge | Error 2 | 0 | Error 3 | 0 | Error 4 | 0 | Error 5 | 1 |
87099 | Agent 1 | Las Vegas | 10/15/2019 2:37 | Regular | 100 | SERVICE DELIVERY | Opening | Error 1 | 1 | Process Knowledge | Error 2 | 0 | Error 3 | 0 | Error 4 | 1 | Error 5 | 0 |
89893 | Agent 6 | Manila | 10/18/2019 22:21 | Regular | 20 | SERVICE DELIVERY | Opening | Error 1 | 1 | Process Knowledge | Error 2 | 0 | Error 3 | 0 | Error 4 | 0 | Error 5 | 0 |
88961 | Agent 5 | Manila | 10/17/2019 17:50 | Regular | 0 | SERVICE DELIVERY | Opening | Error 1 | 1 | Process Knowledge | Error 2 | 0 | Error 3 | 1 | Error 4 | 0 | Error 5 | 0 |
I have all the information in the same table. I need count how many errors have the agent 1, 2, 3 and which error is the most common error.
For example:
Agent 1 : 5 errors
Agent 2: 4 Erros
And
Error 1: 5 times
Error 2: 7 times.
Please let me know if you need more information
regards,
Hi @Ljimenez14,
If I understand you correctly, please modify the calculated table as below:
Table 2 =
var error1 = SELECTCOLUMNS('Table',"name",'Table'[Name],"date",'Table'[Case Date],"error",'Table'[Error 1],"quantity",'Table'[Quantity 1])
var error2 = SELECTCOLUMNS('Table',"name",'Table'[Name],"date",'Table'[Case Date],"error",'Table'[Error 2],"quantity",'Table'[Quantity 2])
var error3 = SELECTCOLUMNS('Table',"name",'Table'[Name],"date",'Table'[Case Date],"error",'Table'[Error 3],"quantity",'Table'[Quantity 3])
var error4 = SELECTCOLUMNS('Table',"name",'Table'[Name],"date",'Table'[Case Date],"error",'Table'[Error 4],"quantity",'Table'[Quantity 4])
var error5 = SELECTCOLUMNS('Table',"name",'Table'[Name],"date",'Table'[Case Date],"error",'Table'[Error 5],"quantity",'Table'[Quantity 5])
return
UNION(error1,error2,error3,error4,error5)
Result would be shown as below:
BTW, Pbix as attached. Hopefully works for you.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |