I don't have words to explain my gratitude for the planning and effort you guys put into Horizon Analytics. As one of your people said, Horizon Analytics is still a new born; hence, we all will contribute to add more meaningful functionalities which will make the app even more attractive.
I can see as per this idea you have enabled the Goal and Variance feature on the KPI Widgets. I feel the issue here is that the goal can only be set as a "Static Value”. Please correct me if I am wrong.
I really think that the system must allow the admins to dynamically set the Goal value. Allowing the admins to map a field to the Goal field of KPI widgets will enable the admins to make use of the KPI widget in wide range of reports/dashboards.