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 date
  • 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
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 586
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 456
  • first
  • ‹ previous
  • 1
  • 2

Trending posts

CCR Source Control Hooks Now Automatically Update Productions and Restart Config Items!
Evan Gabhart
1 39
[Video] Eliminating Waste in Healthcare Supply Chains
Georgia Gans
1 19
InterSystems Open Exchange Applications Digest, June 2025
Anastasia Dyubaylo
1 15
Show more (2)
Key Questions of the Month: June 2025
Anastasia Dyubaylo
0 28
[Video] FHIR-Powered AI Healthcare Assistant
Simon Sha
0 16

Recently released

objectscript-docker-template
by Evgeny Shvarov
1.3K
AnalyzeThis
by Peter Steiwer
1.2K803
Generative AI Pattern Match WorkBench
by Alex Woodhead
49
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