Learning Documentation Community Open Exchange Global Masters Certification Partner Directory Ideas Portal
Developer Community
  • Posts
    • InterSystems Official
    • Articles
    • Questions
    • Announcements
    • Discussions
    • Tags
  • Events
    • Tech Article Contest
    • Programming Contest
    • InterSystems Ideas Contest
    • Event Calendar
  • Products
    • InterSystems IRIS
    • InterSystems IRIS for Health
    • HealthShare
    • TrakCare
    • Caché
    • Ensemble
    • InterSystems Analytics (DeepSee)
    • InterSystems Text Analytics (iKnow)
  • Jobs
    • Job Opportunity
    • Job Wanted
  • Members
  • About
    • About Us
    • FAQ
    • Feedback
    • Report an Issue
    • Share an Idea
    • Code of Conduct
    • Contact Us

EN

Search by posts, members, tags
Language
EN|
ESPTJPCNFREN
New post
  • All posts
  • InterSystems Official
  • Announcements
  • Articles
  • Questions
  • No answer
  • No accepted answer
  • With accepted answer
  • Discussions
  • Videos
  • Jobs
  • Jobs Opportunities
  • Jobs Wanted
  • Global Masters Chat

InterSystems resources

  • Download InterSystems IRIS
  • InterSystems Container Registry
  • Early Access Program
  • Developer Hub
  • Share an idea
  • Become a partner
  • InterSystems IRIS Cloud SQL
  • InterSystems IRIS on AWS
  • InterSystems FHIR Server on AWS
  • InterSystems IRIS on Azure

Our social networks

  

#Analyzer

4

DeepSee Analyzer is a WYSIWYG editor for MDX queries which are the data sources for DeepSee interactive widgets

By update
  • By update
  • By date
  • By likes
  • By views
  • By replies
AllTop
Question
Ryan Miller · Oct 12, 2016
How to do a TOP 15 Payers and Percent of Total Paid

I'm stuck on how to show the top 15 payers and then also show the percentage of the total amount paid for each one. The total amount is what was paid by all the payers not just the top 15.

#Analyzer #InterSystems IRIS BI (DeepSee)
0 7
0 360
Question
Trevor Strong · Jul 26, 2016
Defining pivot variables

Is it possible to populate a pivot variable with a defined runtime variable from the settings page?

If so, what is the syntax?

#InterSystems IRIS BI (DeepSee) #Analyzer
0 4
0 384
Question
Evgeny Shvarov · Mar 31, 2016
Running total without %CELL

Hi!

There is an example in Samples which shows how to implement 'running total' measure: "Pareto Chart for Category" dashboard.

To calculate running total this pivot uses calculated measure with %Cell expression:

Measures.[Revenue as Percent of Total] + %CELL(0,-1)

#InterSystems IRIS BI (DeepSee) #Analyzer #MDX
0 3
0 457
Question
Daniel Kutac · May 31, 2016
API to retrieve MDX from a save pivot?

Hello,

is there any API available that would return an MDX query string for a given saved pivot name? I could not find anything except for pivots with manual MDX. But that's not my case, I need to get MDX for any pivot.

TIA!

Dan

#Analyzer #InterSystems IRIS BI (DeepSee)
3 9
0 587
  • first
  • ‹ previous
  • 1
  • 2

Trending posts

The Zen Angle
David Hockenbroch
3 49
InterSystems Developer Tools Contest 2025
Anastasia Dyubaylo
0 90
Key Questions of the Month: June 2025
Anastasia Dyubaylo
0 76
Show more (2)
InterSystems Developer Ecosystem News, Q2 2025
Anastasia Dyubaylo
0 25
InterSystems Data Fabric Studio at your service!
Luis Angel Pérez Ramos
0 21

Recently released

objectscript-docker-template
by Evgeny Shvarov
1.3K
MDX2JSON
by Eduard Lebedyuk
1.1K35.4K
ETL Interoperability Adapter
by Guillaume Rongier
65629
Featured
iris-vector-search
by Fan Ji
1.5K

News

Full details

Learn more

Full details

  • Privacy & Terms
  • Guarantee
  • Section 508
  • Contest Terms
  • Cookies Settings
© 2025 InterSystems Corporation, Cambridge, MA. All rights reserved.

Log in or sign up

Log in or create a new account to continue

Log inSign up

Log in or sign up

Log in or create a new account to continue

Log inSign up

Log in or sign up

Log in or create a new account to continue

Log inSign up

Log in or sign up

Log in or create a new account to continue

Log inSign up