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
  • Blog
  • Questions
  • Learning
    • Courses
    • Certification
      • DataMiner Operator
      • DataMiner Administrator
      • DataMiner Automation
      • Scripts & Connectors Developer: HTTP Basics
      • Scripts & Connectors Developer: SNMP Basics
      • Visual Overview – Level 1
    • Video Library
    • Books We Like
    • Third-party Courses
    • DevOps Enablement Services
    • Quizzes
  • RESOURCES
  • 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)
  • Expert Hubs
    • DataMiner DevOps Professional Program
    • DataMiner
      • DataMiner Releases & Updates
      • System Architecture
      • Integration Studio
      • Visual Overview
      • Security
    • Technologies
      • CI/CD
      • Converged Interconnect Networks
      • DOCSIS 3.1 / DAA
      • Elasticsearch
      • Kubernetes
      • Telemetry / Flow Monitoring
      • PTP
      • SDN / ST2110 / NMOS
    • Business
      • Software Business models
      • Perpetual Use or Usage-based Services
  • Discover
    • Markets
      • Media production
      • Government & defense
      • Content distribution
      • Service providers
      • Partners
      • OSS/BSS
    • Solutions
    • Use Case Library
    • DataMiner Dashboards
    • DataMiner Downloads
    • DataMiner Modules
      • Core features
      • SRM features
    • DataMiner Apps
    • Professional Services
  • PARTNERS
    • All Partners
    • Technology Partners
    • Strategic Partner Program
    • Deal Registration
  • Pricing
  • More
    • Feature Suggestions
    • Online DataMiner Systems
    • Leaderboard
    • Swag Shop
    • Contact
      • General Inquiries
      • DataMiner DevOps Support
      • Commercial Requests
    • Global Feedback Survey
    • Verify a certificate
  • >> Go to dataminer.services

Table’s header filtering

Solved182 views19th July 2023Tables
1
Julien Poilbout [DevOps Member]38 11th July 2023 0 Comments

Hi,

In the following table, we've configured the "Header" with "Sum" for certain columns, and we're wondering whether it's possible to exclude certain rows from the calculation.

For example, we'd like to remove the row with the key "324_Total" from the calculation (without removing the row itself):

Thanks

Marieke Goethals [SLC] [DevOps Enabler] Selected answer as best 19th July 2023

2 Answers

  • Active
  • Voted
  • Newest
  • Oldest
3
Laurens Moutton [SLC] [DevOps Enabler]5.36K Posted 11th July 2023 1 Comment

Hi,

That is currently not possible to exclude rows from the header calculation.

Two alternatives are:
1) Add a single parameter, and do the calculation from a QAction with the rows that need to be taken into account
2) Or add a second column that contains the values that need to be taken into account, and zero for the ones that need to be ignored

A feature suggestion could also be added here to have the possibility to ignore rows from the header calculation.

Marieke Goethals [SLC] [DevOps Enabler] Selected answer as best 19th July 2023
Julien Poilbout [DevOps Member] commented 12th July 2023

Thank you

-1
Miguel Obregon [SLC] [DevOps Enabler]8.14K Posted 11th July 2023 2 Comments

Hi Julien,

As far as I know this is not possible. I believe there are two possible options:

  • Using aggregation rules: You can define an aggregation rule on the view where that element is located and define this custom filter.
  • Using dashboards: You can create a dashboard that can perform this aggregation.
    • Create a GQI query that gets data from this table. You could use the data source Get parameter table by ID or Get parameters for element.
    • Using the filter option on the 'key' column, you can remove the desired row
    • Then perform an aggregation based on the 'Rate' column. You will see that only the aggregated value is displayed
    • Finally, to have a reference to the row, you can group by the column 'key'.

Hope it helps.

Miguel Obregon [SLC] [DevOps Enabler] Posted new comment 12th July 2023
Julien Poilbout [DevOps Member] commented 12th July 2023

Thank you

Miguel Obregon [SLC] [DevOps Enabler] commented 12th July 2023

Hi,
The options described in the answer could be used when a connector update is not possible. We try to avoid custom logic in the connector. However, if you can update the connector to implement a custom logic, then the proposal from Laurens is the best approach.

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

My Dojo Points

0 Credits
0 Reputation

Question Tag Cloud

adl2099 (54) Alarm Console (53) alarms (70) alarm template (58) API (35) Automation (144) automation scipt (65) Automation script (95) backup (54) Cassandra (142) cloud (37) Connector (44) Correlation (42) Cube (114) Dashboard (134) Dashboards (136) database (64) DataMiner Cube (37) DIS (53) DMS (48) DOM (68) driver (48) DVE (43) Elastic (73) Elasticsearch (99) elements (49) Failover (90) GQI (51) HTTP (45) IDP (55) low code app (70) low code apps (43) MySQL (50) protocol (145) QAction (58) resources (35) security (71) SNMP (56) SRM (267) SRM resources (39) timeout (35) trending (66) upgrade (44) Visio (373) Visual Overview (290)
Privacy Policy • Terms & Conditions • Contact

© 2023 Skyline Communications. All rights reserved.

[ Placeholder content for popup link ] WordPress Download Manager - Best Download Management Plugin