Ok I have a cool idea but I don't know if I can pull it off...
I have a chart for a dashboard that displays metrics data in a stack for every day of the current week.
I load all of the days of the week except for the current day using a query into an archive data warehouse table.
I pull the current days data from current tables.
This works well but my goal is to display this data on a dash console in the office and update the chart every 15 seconds.
I only want to update the current day's bar though.... I don't want to refresh the whole control.
if today is Tuesday I want to display Sat, Sun, Mon, Tue values but I want to refresh Tue every 15 seconds and only re-paint the bars for Tuesday.
Is this possible?