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

How to put data table in a graph?

Solved1.12K views7th July 2023graph linux time table
5
Dominique Bodart [DevOps Member]693 21st February 2023 0 Comments

Hi,

I created a table which recover traffic data Uplink / Downlink with a timestamp. Is there a way to put those data in a graph with the timestamp in abscis and the traffic values in Y axes? The table looks like that:

Index [IDX],Time Stamp,Traffic Download (kbps),Traffic Upload (kbps)
1,167694480000,47.615,47.688
2,167694510000,36.680,33.714
3,167694540000,60.289,56.053
4,167694570000,46.562,46.864
5,167694600000,52.484,48.477

And also, the timestamp is in Linux ms format. Is there a way to display it in “dd-mm-yyyy hh:mm:ss” ?

Thank you,

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 7th July 2023

2 Answers

  • Active
  • Voted
  • Newest
  • Oldest
4
Michiel Vanthuyne [SLC] [DevOps Enabler]4.16K Posted 21st February 2023 3 Comments

Hi Dominique, this cannot be done directly.

In your connector you could however add  Traffic Download (kbps) and  Traffic Upload (kbps) non-table parameters, and use the history set functionality in a QAction to process the retrieved data from the table and perform a set on these new parameters with the correct value and time information. That way, if you trend those parameters you will be able to use all trending features available in DataMiner on those parameters.

For more information on the history set functionality, please check How to use history sets on a protocol parameter.

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 7th July 2023
Dominique Bodart [DevOps Member] commented 22nd February 2023

Thank you Michiel,
So what I did, I took the most recent record of my table which is polled every 5 minutes and put it in a standalone paramter. That way it works indeed.
What about the linux time stamp? I can’t fine a data type to convert it in “human readable” format. I wanted to create a sub function in the QAction which recovers the table but I got a message saying that I need to upgrade my C# version. Any suggestion?

Michiel Vanthuyne [SLC] [DevOps Enabler] commented 22nd February 2023

Hi Dominique, something like below code should work. I’ve hardcoded the unixtime and value in the example, you should replace this with the retrieved values. Also check if the retrieved values are in UTC or local time and adjust accordingly.

int value = 123;
long unixTime = 167694480000;
DateTime unixEpoch = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc);
DateTime dt = unixEpoch.AddSeconds(unixTime);
protocol.SetParameter(Parameter.yourParameter, value, dt);

Dominique Bodart [DevOps Member] commented 22nd February 2023

Well noted. I will try in the next version, thank you 🙂

0
Pieter Van Compernolle [SLC] [DevOps Enabler]3.26K Posted 8th March 2023 0 Comments

In case it’s only about presenting the data: In a DataMiner dashboard or Low code app, you can present any data you can access through Queries in a line/pie/donut chart. (Dashboards or low code apps can be embedded in Visio files in case you want to have them embedded in Cube).
So it’s just a matter of creating the correct query in your app/dashboard. You can easily get to your parameter table I assume and then you have to split the data in different columns via column manipulation operators.

Pieter Van Compernolle [SLC] [DevOps Enabler] Answered question 8th March 2023
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