I was wondering if someone could point me in the right direction. I have a dashboard that our office staff uses to schedule appointments. We limit how many appointments that we schedule based on the day of the week.
Currently on Wednesday and Thursdays we only schedule10 appointments and Friday we schedule 25. Currently I have a gauge indicator just set to 25 as a maximum but I would like to see if there was a way to dynamically change the max value for the indicator based of the day of the week?
Hi @durus5995,
If you can publish a CSV containing the day-to-max-appointments data as a feature layer, we can then use that information in an Arcade expression to dynamically configure the gauge. The expression might look similar to this:
var dayName = Text(Date($feature.AppointmentDate), 'dddd');
var dayLimits = FeatureSetByName($map, 'AppointmentLimits'); /*layer with the data table*/
var todayLimit = First(Filter(dayLimits, "Day = @dayName"));
return todayLimit.MaxAppointments;
If you can provide more details about the maximum number of appointments allowed for each day, we can refine this further.
Let me know if you have any questions!