I have a form that has a filterable dataset on it with the following fields:
The data can contain several of the same employee name, work week, work code and hours. In other words, you could have 10 lines that look all the same. The data is then filterable, of course.
I'd like to create sort of a dynamic dashboard on the form that shows a pie graph that sums up hours spent by work code, and then by employees. I'd like the graph to change when the filters are applied as well.
I can't even get the graph to show up on the page. I tried putting it in the filter with no luck. I'd love some feedback on how to do this, if even possible. Thanks in advance!