Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Emanuele Ruggiero]

Hi guys, I would like to pick your brain on the following doubt I am having. To provide more background and to make it more fun, I invented this simplified use case: in my hometown we like trick or treat so much that we run it for the entire year, kids can always visit a house and receive treats. There are only a few rules which must be obeyed:

1. Each house cannot give more than 800 treats a year
2. Each kid cannot receive more than 10 treats in a single visit and
3. Each kid cannot receive more than 20 treats per month

I was asked to build a dashboard so that, at the end of the year, we can look back and identify if all houses and all kids followed the rules. I came up with the attached pbix but I am not yet convinced, in particular: I believe rule #1 is well covered by the bar chart by house on the left; I used a scatter plot for rule #2 but if multiple kids are in the same spot this is not visible; the right hand side bar chart by month is to address rule #3, however the user should first select a kid in the scatter plot.

Overall I am not satisfied by this design hence my question: which visuals would you have used to tackle this? do you have any further recommendation?

Many thanks in advance!

??

——————————
Emanuele Ruggiero
——————————

[Calen Butler]

This is a pretty cool concept. If you have the addresses of the houses that participate, you could add a map where you have # Treats by House_ID. You could have the bubble sizer represent the number of treats given out and even have it change colors when they hit the 800 treat limit. I personally like the scatter plot for rule 2. I agree there is a lot of overlap, but it’s a great way to look at three variables spread over a large number of kids. ?

——————————
Calen Butler
Director of FP&A
Garner Foods
Winston-Salem NC
——————————
——————————————-