Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear,
I have a hugh data of models sold with serial number and I'm looking to know how many sold with similar number
As-Is | Requried | |||
Model | Serial Number | Model | Count of Serial Number (Sold) | |
M1 | 1234 | M1 | 23 | |
M1 | 1235 | M2 | 6 | |
M1 | 1236 | M3 | 3 | |
M1 | 1237 | |||
M1 | 1238 | |||
M1 | 1239 | |||
M1 | 1240 | |||
M1 | 1241 | |||
M1 | 1242 | |||
M1 | 1243 | |||
M1 | 1244 | |||
M1 | 1245 | |||
M1 | 1246 | |||
M1 | 1247 | |||
M1 | 1248 | |||
M1 | 1249 | |||
M1 | 1250 | |||
M1 | 1251 | |||
M1 | 1252 | |||
M1 | 1253 | |||
M1 | 1254 | |||
M1 | 1255 | |||
M1 | 1256 | |||
M2 | 123 | |||
M2 | 123 | |||
M2 | 123 | |||
M2 | 123 | |||
M2 | 123 | |||
M2 | 123 | |||
M3 | 123456 | |||
M3 | 123456 | |||
M3 | 123456 |
Solved! Go to Solution.
Hi @santu1021
As per the sample dataset shared and the output required, you could get it by simply using any visual or a table visual:
Just select the option of count after selecting the Model field twice:
Cheers!
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂
https://www.vivran.in/
Connect on LinkedIn
Thank You !!!
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |