displaying data per team

[badriaymen]

I have an sql server query wich counts the number of total quantity produced in an industrial company , i saved this query in dashboard , the problem is that we have three teams : the first team works from - 6am to 14pm ,the second from 14pm to 22pm , and the theard from 22pm to 6am,
i want to display the quantity in real time and the count retart dynamically every begin of team,

[somesoni2]

Please share some sample data, highlight available fields and corresponding expected output. This would help us understand your requirement better and provide a solution (if it's feasible within current features of Splunk).