Good morning!I'm trying to get a custom visualization made for PowerBI to visualize SQL Server Agent jobs. I can provide the SQL data in whatever format necessary (including the PowerBI Query results in table form for testing), and take care of the DAX required for measures.It would basically be a Gantt chart, but with recurring activities, several options for colorization, shading, grouping and visibility. X Axis would be a timeline, zoomable all the way from 9 days (week plus a day on each side) into probably a minute increment. Y axis would have a horizontal Bar for each group of data, starting with the Server, drilling into the Job Category, finally drilling to the Job Name. Each data point would be based on a starttime and expected duration for that specific job. So a job that runs every 5 minutes, for 10s would look like Start: 8am Duration 10s ; Start: 8:05am Duration 10s etc... Those would be represented on the timeline as a single bar, with colored space while running, and no color when not running. At the bottom, it would have a bar showing the timing overlap for jobs at that level of drill, letting you know where you can deconflict. It might also take into account history of the job, showing success/failure and actual duration (color code for long running jobs) - depending on how hard it is to add.From what I've read, Custom Visualizations are programmed in node.js - which I know nothing about. I'm a database guy. Is anyone willing to collaborate on an open-source, free visualization for the PowerBI and SQL community? Mods if this is the wrong place, please let me know where I could post this. Thanks!
Submitted November 15, 2017 at 05:42PM by ISUJinX
No comments:
Post a Comment