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
    • YouTube Videos
    • Solutions & Use Cases
      • Solutions
      • Use Case Library
    • Agility
      • Book your Agile Fundamentals training
      • Book you Kanban workshop
      • Learn more about 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)
    • >> Go to DataMiner Docs
  • DevOps
    • About the DevOps Program
    • Sign up for the DevOps Pogram
    • DataMiner DevOps Support
    • Feature Suggestions
    • Climb the leaderboard!
    • Swag Shop
  • Downloads
  • Contact
    • Sales, Training & Certification
    • DataMiner Support
    • Global Feedback Survey
  • PARTNERS
    • All Partners
    • Technology Partners
    • Strategic Partner Program
    • Solutions
    • Deal Registration
  • >> Go to dataminer.services

Dashboards – Filter Top X for each element in a table

Solved1.64K views21st February 2023
6
Thomas Rich [SLC] [DevOps Advocate]645 21st February 2023 0 Comments

I have a single dashboard table displaying 4 different fan speeds for 3 different elements. This can be seen in the picture below:

I was attempting to filter the table to display only the highest RPM Fan IDX for each element.
When using the Top X operator, I was only able to filter the table to the highest RPM IDX of all 3 elements rather than the highest RPM IDX for each element. This result can be seen below:

This table-wide filter happens regardless of where I place the Top X operator within the query.
Below is the query that I am using.

Before I add a new feature request, I wanted to check with others to see if I am missing something in my query.
Thank you in advance for any insight that can be provided.

Thomas Rich [SLC] [DevOps Advocate] Selected answer as best 21st February 2023

1 Answer

  • Active
  • Voted
  • Newest
  • Oldest
9
Miguel Obregon [SLC] [DevOps Catalyst]19.60K Posted 21st February 2023 2 Comments

Hi Thomas,

Instead of using Top x, I believe in this case you could aggregate first the fan speed(Get the maximum). Once the aggregation is calculated, you can group by element.

Hope it helps.

Miguel Obregon [SLC] [DevOps Catalyst] Posted new comment 21st February 2023
Thomas Rich [SLC] [DevOps Advocate] commented 21st February 2023

Miguel, thank you for the help. Using aggregate (maximum) and then group by element name worked.
When using Top x, there doesn’t appear to be the ‘group by’ operator as a next selection (like there is with aggregate).

When using the aggregate method, it seems to reduce the number of visible columns to two even though my query is specifying to select and join four or five columns of data. I will play around with it to see if I can recover those columns while maintaining the new filtering.

Thanks for your help.

Miguel Obregon [SLC] [DevOps Catalyst] commented 21st February 2023

Hi Thomas,
For that case you could use the feature available from 10.3.3 (multiple groupby operations). Check DataMiner Docs (https://docs.dataminer.services/release-notes/Web_apps/Web_apps_Feature_Release_10.3/Web_apps_Feature_Release_10.3.3.html#gqi-multiple-groupby-operations-can-now-be-applied-after-an-aggregation-operation-id_35355)

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