Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I am analysing customer conversations. of each conversation I have a unique ID. conversations can have multiple labels. some of these labels can be grouped /evaluated together. Some should all be present before it can be counted. small example (assume that there are many more conversations, on different days with many more label_names):
Conversation_ID | Label_name |
1 | greeting_call |
1 | name_check |
1 | zipcode_check |
2 | greeting_whatsapp |
2 | name_check |
2 | zipcode check |
2 | birthday_check |
I can show a graph, highlighting that 100% of all conversations have a proper greeting (e.g. if I group _call and _whatsapp to a group proper greeting). However for id_check I can't as only name_ zipcode_ and birthday combined are a proper id_check. It still would like to list these different labels into 1 graph. should I somehow create a new column or something (populating it with all label_names and only for id_check and greeting check if they meet requirements)? Any suggestions for me?
@joostvanham , May a new column like
concatenatex(filter(Table, [Conversation_ID] = earlier([Conversation_ID]) ), [Label_name] , ", ")
Can you share expected output
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |