sarad agarwal
New Member
- Joined
- Mar 14, 2016
- Messages
- 20
Hi,
I am Trying to create a weekly moving dashboard for ranked values. I have a clue of how can i get the top three ranked validations from a list , but i am not able to link these validations to change with my week.
Source Table:
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Target Table:
<colgroup><col><col span="7"></colgroup><tbody>
</tbody>
The source table will keep adding the weekly values and all the validations that occurred for that week . I want a moving dashboard which gives me data for last 4 weeks from the source table but i want only top three validations based on their count. How can i link the weeks to change dynamically ?
I am Trying to create a weekly moving dashboard for ranked values. I have a clue of how can i get the top three ranked validations from a list , but i am not able to link these validations to change with my week.
Source Table:
Week 6 | Week 7 | Week 8 | |||
Active inactive listing | 0 | Active inactive listing | 1 | Active inactive listing | 1 |
Create listing | 4 | Create listing | 30 | Create listing | 10 |
Create variation relationship | 1 | Create variation relationship | 2 | Create variation relationship | 5 |
Modify existing listing | 5 | Modify existing listing | 3 | Modify existing listing | 0 |
Modify variation relationship | 1 | Modify variation relationship | 0 | Modify variation relationship | 0 |
Unsuppress existing listing | 1 | Unsuppress existing listing | 1 | Unsuppress existing listing | 0 |
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Target Table:
Week 9 | Week 10 | Week 11 | Week 12 | ||||
Top Three Validation | Count | Top Three Validation | Count | Top Three Validation | Count | Top Three Validation | Count |
Modify existing listing | 81 | 1 | 1 | 1 | |||
Create listing | 40 | 2 | 2 | 2 | |||
Unsuppress existing listing | 0 | 3 | 3 | 3 |
<colgroup><col><col span="7"></colgroup><tbody>
</tbody>
The source table will keep adding the weekly values and all the validations that occurred for that week . I want a moving dashboard which gives me data for last 4 weeks from the source table but i want only top three validations based on their count. How can i link the weeks to change dynamically ?