This feature might be for you if you are building dashboards/reporting for a manufacturing or shift work setting. In manufacturing, you often have several shifts, and it’s a common requirement for ‘smart filtering’ to quickly and easily allow users to select only data from a particular shift on a dashboard. To solve this problem in Dundas BI, we use ‘custom tokens’ to retrieve data for only a specific shift on your dashboard. As the dashboard developer, you make the token once, and all your users can benefit from it.
Here is a walkthrough:
My script from the video:
DateTime dates = new DateTime;
//Get the start of today at 12:00AM DateTime today = DateTime.Today.Date; //Start today at 8am dates = new DateTime(today.Year, today.Month, today.Day, 8, 0, 0); //End today at 4pm dates = new DateTime(today.Year, today.Month, today.Day, 16, 0, 0); //return date range; return dates;
Other great resources for this topic:
****If you’re interested in the Visual Studio Code application that I use for debugging the C# code, this is a great video to help you get set up.