Skip to content
DataMiner DoJo

More results...

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Search in posts
Search in pages
Search in posts
Search in pages
Log in
Menu
  • Updates & Insights
  • Questions
  • Learning
    • E-learning Courses
    • Empower Replay: Limited Edition
    • Tutorials
    • Open Classroom Training
    • Certification
      • DataMiner Fundamentals
      • DataMiner Configurator
      • DataMiner Automation
      • Scripts & Connectors Developer: HTTP Basics
      • Scripts & Connectors Developer: SNMP Basics
      • Visual Overview – Level 1
      • Verify a certificate
    • Video Library
    • Books We Like
    • >> Go to DataMiner Docs
  • Expert Center
    • Solutions & Use Cases
      • Solutions
      • Use Case Library
    • Markets & Industries
      • Media production
      • Government & defense
      • Content distribution
      • Service providers
      • Partners
      • OSS/BSS
    • Agile
      • Agile Webspace
      • Everything Agile
        • The Agile Manifesto
        • Best Practices
        • Retro Recipes
      • Methodologies
        • The Scrum Framework
        • Kanban
        • Extreme Programming
      • Roles
        • The Product Owner
        • The Agile Coach
        • The Quality & UX Coach (QX)
    • DataMiner DevOps Professional Program
      • About the DevOps Program
      • DataMiner DevOps Support
  • Downloads
  • More
    • DataMiner Releases & Updates
    • Feature Suggestions
    • Climb the leaderboard!
    • Swag Shop
    • Contact
    • Global Feedback Survey
  • PARTNERS
    • All Partners
    • Technology Partners
    • Strategic Partner Program
    • Deal Registration
  • >> Go to dataminer.services

Dashboard for SLA bar chart

Solved786 views22nd April 2024
1
Stefan Schedletzky [DevOps Enabler]2.06K 2nd April 2024 0 Comments

Hi Dojo,

I’m trying to create a dashboard for a single service, but this service is linked on different destinations. For each destination we have a service.

Current bar chart generated with query:

As you can see we have the same week for different services. Is it possible to make a bar chart like this:

This is the current data table:

How could I group the weeks and have than two columns for each service availability (history)?
Is this however possible to do?

Automation script:

Stefan Schedletzky [DevOps Enabler] Selected answer as best 22nd April 2024

1 Answer

  • Active
  • Voted
  • Newest
  • Oldest
2
Ronald Gerard [SLC] [DevOps Advocate]1.74K Posted 2nd April 2024 5 Comments

Hi Stefan,

In order to get a bar chart like that, the availability of each service will have to be put into a separate column.
There is no trivial solution to do this yet, but it’s definitely achievable.

The data you currently have can be converted like this:

  1. Create and append a Custom Operator the query that does the following:
    1. Add a new column where you can put the availability of “Service 2”
    2. Read the values from the “Service Name” column
    3. If the value is “Service 2”
      1. copy the value from the original column to your new availability column
      2. clear the value from the original column
  2. Aggregate the data in your query:
    1. Take the maximum of the original availability column
    2. Take the maximum of the new availability column
    3. Group by the “Tracking Period” (i.e. column that will contain the label)

In the bar chart settings, you should now be able to select both availability columns to show up as separate bars on the chart.

I’ve put together a quick mock example of the process:

Let us know if you have any more concerns or need additional help.
We hope to offer more straightforward solutions for use cases like this soon!

Stefan Schedletzky [DevOps Enabler] Selected answer as best 22nd April 2024
Stefan Schedletzky [DevOps Enabler] commented 3rd April 2024

Hi Ronald,

many thanks for your detailed answer. I have created now my first GQI Custom Operator. I have published it via VS and I can see it as an automation script in Dataminer. But I don’t see it as an operator in queries. What step I have missed here to see the operator in the Dashboard?

Ronald Gerard [SLC] [DevOps Advocate] commented 3rd April 2024

Hi Stefan, there could be a few reasons for that.

First of all, depending on which DataMiner version you have, you might need to enable the soft launch option (see link in the answer).

Secondly, on the automation script, did you check the Advanced > “Compile as library with name” option?

Note: You can also configure this in VS by adding the following in the tag in the automation script XML:
true
MyLibraryName

Let me know if any of these steps solved your issue.
If not we’ll have to dig a little deeper.

Stefan Schedletzky [DevOps Enabler] commented 8th April 2024

Hi Ronald,
I have checked it and compile as library is set. On my question I added a screenshot. Maybe the name is the problem?

Our DMA version is: DataMiner (10.3.0.0-13999-CU12)

Ronald Gerard [SLC] [DevOps Advocate] commented 8th April 2024

The name looks fine, and the DataMiner version too.
Do you get any errors or warnings when you click the “Validate” link below the C# code block in your automation script?

If it compiled correctly, you should also be able to find the library file in folder C:\Skyline DataMiner\Scripts\Libraries, named: your-script-name.your-library-name.date.R.dll

Stefan Schedletzky [DevOps Enabler] commented 22nd April 2024

Hi Ronald,

thanks for your help! I got it working like you described it!
Best regards,
Stefan

Please login to be able to comment or post an answer.

My DevOps rank

DevOps Members get more insights on their profile page.

My user earnings

0 Dojo credits

Spend your credits in our swag shop.

0 Reputation points

Boost your reputation, climb the leaderboard.

Promo banner DataMiner DevOps Professiona Program
DataMiner Integration Studio (DIS)
Empower Katas
Privacy Policy • Terms & Conditions • Contact

© 2025 Skyline Communications. All rights reserved.

DOJO Q&A widget

Can't find what you need?

? Explore the Q&A DataMiner Docs