By using this website, you agree to our Terms of Use (click here)
Hello
I have a dashboard with a set of parameters (Start and End date) to allow the user to select different time periods for the data displayed.
Imagine a simple dataset of a TimeCard:
- 10/10/2021, User A, Internal Project X, 5 hrs
- 11/10/2021, User A, External Project Y, 6 hrs
- 10/10/2021, User B, External Project Y, 7.6 hrs
I would like a simple KPI of utilisation of staff time Internal hours worked vs external hours worked = External / Total Hours over the time period specified. It is a simple expression but I cannot create a specific GI as the dates are user selected on the Dashboard. It would be possible if the Dashboard parameters link to GI parameters, however this is also not possible as dashboard parameters link only to the filter. The filter means the GI needs to return raw data and cannot be grouped in the way it could be with GI parameters instead.
Ideally the KPI widget would permit an expression to display the percentage rather than specifying a specific field.
Has anyone encountered this before?
I can't think of a way to do this off the top of my head. Maybe submit a feature request for the ability to pass a Dashboard Parameter to a Generic Inquiry Parameter since it sounds like you tried that (I haven't) and it didn't work?
@timrodman There appears to be no way to link the dashboard parameters to GI parameters. If there was it would be ideal. Thanks for your response though.