Forum Discussion
Creating scoreboard for measures
Hello Anonymous
Please take a look at this video from avisingh
https://www.youtube.com/watch?v=WV5KxZRIzUEHe goes through using a pair of label tables and nested switches to achieve what you are looking for. You would also want to apply some FORMAT in the switches based on if you ar returning a %, count or $.
I forgot to add the date column to the raw data table shared above.
| AppID | ApprovedAmount | FundedAmnt | SubmittedDate |
| 1 | $ 20,000 | $ 20,000 | 1/1/2019 |
| 2 | $ - | $ - | 1/2/2019 |
| 3 | $ - | $ - | 1/3/2019 |
| 4 | $ - | $ - | 1/4/2019 |
| 5 | $ - | $ - | 1/5/2019 |
| 6 | $ - | $ - | 1/6/2019 |
| 7 | $ 40,000 | $ 40,000 | 1/7/2019 |
| 8 | $ 24,000 | $ 24,000 | 1/8/2019 |
| 9 | $ - | $ - | 1/9/2019 |
| 10 | $ - | $ - | 1/10/2019 |
Measures: Applications, Approval Rate and TotalFundedAmount are based on the 'Submitted Date' column.
I would also like to ask jdbuchanan71 parry2k Cmcmahan Zubair_Muhammad Mariusz
if you could give me any suggestions or inputs.
I really need to deliver this to business soon.
Thanks in advance.
- jdbuchanan71
Super User
Hello Anonymous
Please take a look at this video from avisingh
https://www.youtube.com/watch?v=WV5KxZRIzUEHe goes through using a pair of label tables and nested switches to achieve what you are looking for. You would also want to apply some FORMAT in the switches based on if you ar returning a %, count or $.