Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have unique requirement in creating a summarized table that should be shown as a matrix or table view based on the selections used in the filters. I have explained the scenario in the below screenshot as what the output should look. Kindly provide the suggestion, feedback and solution to the problem.
Regards,
Mohanraj
Hi @Mohanraj87
Can you please post a sample data that isn't an image?
Proud to be a Super User!
Attached the same data as requested. @danextian
Project | ProjectID | Category | Divison Name | Revision | Attribute | Value |
P1 | 234 | Wall | Structure | R1 | Description | Concreate |
P1 | 234 | Wall | Structure | R2 | Description | Wood |
P1 | 234 | Wall | Structure | R3 | Description | Wood |
P1 | 234 | Beam | Structure | R1 | Tag | B123 |
P1 | 234 | Beam | Structure | R2 | Tag | B124 |
P3 | 344 | Roof | Design | R1 | Supplier | Jimm |
P3 | 344 | Roof | Design | R2 | Supplier | Jimm |
P3 | 344 | Roof | Design | R3 | Supplier | Harry |
P2 | 500 | Wall | Structure | R1 | Description | Concreate |
P2 | 500 | Wall | Structure | R2 | Description | Wood |
P2 | 500 | Wall | Structure | R3 | Description | Wood |
Hi @Mohanraj87
I am trying to wrap my head around your use case but I'm having a hard time doing so.
Please correct my understanding. For 234:
Proud to be a Super User!
Hi @danextian,
1. If in both the filters the values are seleted as same like "R1" in Version 1 and "R1" in version 2, then the counts will be 0 as there is no change. If "R2" in Version 1 and "R1" in version 2 & vise versa is seleted then the elements which has difference should be counted.
2. Same condition as I have explained above between the the version 1 and version 2 selection it should check how many attributed got changed and should be counted.
Hope this helps.
Why would you include the revision column in the output? And, rather than stating "Modified" I would list the actual before and after values.
Yes. I agree with you @lbendlin that "Revision" column is not required. But, the "Modified" value is the business requirement. But, your logic is correct. Let me know if there is way to build the summary table.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |