Thanks a lot for taking the time to reply
Board noDate C1 C2C3C4C5C6C7C8C9C10C11C12C13C14C15C16C17C18D1D2D3Occurance Occurance WeightatgeEqpRework Index RI=(P/Q)*100Inspected ByOccur without C9 & C14Occur weightagewithout C9 & C14Inspected quantityAssembly contribution to rework indexDiffernece SUMOccuarnce with PWD C9Pwd contribution to reworkOccuarnce with fab C14Fab contribution to reworkSum2SUM3Vendor TargetAssembly DPMOPowder coating DPMOFabrication DPMOTARGET2
| SYBJ969 | 7/8/2021 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 4.00 | 1.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 3.00 | 4.00 | 2.00 | 0.00 | 16.00 | 10.00 | 10.00 | 100.00 | Tamil | 1019.00 | 8.00 | 10.00 | 80.00 | 20.00 | 100.00 | 0.00 | 0.00 | 2.00 | 20.00 | 100.00 | 100.00 | S3 | 70.00 | 26666.67 | 0.00 | 6666.67 | 20000.00 |
| SYCE454 | 7/8/2021 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 0.00 | 0.00 | 1.00 | 3.00 | 2.00 | 0.00 | 3.00 | 2.00 | 2.00 | 0.00 | 0.00 | 5.00 | 0.00 | 0.00 | 19.00 | 16.00 | 19.16 | 83.51 | Tony | 667.00 | 13.00 | 19.16 | 67.85 | 15.66 | 83.51 | 0.00 | 0.00 | 3.00 | 15.66 | 83.51 | 83.51 | Simser | 70.00 | 22616.56 | 0.00 | 5219.21 | 20000.00 |
| SYNJ613 | 7/14/2021 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 | 6.00 | 1.00 | 1.00 | 0.00 | 3.00 | 1.00 | 0.00 | 0.00 | 2.00 | 5.00 | 0.00 | 21.00 | 20.00 | 6.00 | 333.33 | SVB | 651.00 | 16.00 | 6.00 | 266.67 | 66.67 | 333.33 | 4.00 | 66.67 | 0.00 | 0.00 | 333.33 | 333.33 | Neuro | 70.00 | 88888.89 | 22222.22 | 0.00 | 20000.00 |
| SYBJ970 | 7/15/2021 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1.00 | 1.00 | 1.00 | 0.00 | 0.00 | 1.00 | 1.00 | 0.00 | 0.00 | 2.00 | 1.00 | 2.00 | 0.00 | 10.00 | 9.00 | 10.00 | 90.00 | Tamil | 632.00 | 6.00 | 10.00 | 60.00 | 30.00 | 90.00 | 2.00 | 20.00 | 1.00 | 10.00 | 90.00 | 90.00 | S3 | 70.00 | 20000.00 | 6666.67 | 3333.33 | 20000.00 |
This is a sample table.
I have a filter based on the process owner ( which I have done with the code). After filtering is not able to set the table range dynamically.
In Addition after filtering, i have to sum up all the column values before capturing the image.
Summed up the value of 3 columns should be shown in the stacked column chart. The chart should have 3-month data.
Is it possible to do in scripts?
Helpful resources
Power Automate News & Announcements
Keep up to date with current events and community announcements in the Power Automate community.
Community Calls Conversations
A great place where you can stay up to date with community calls and interact with the speakers.
