Question Derrek Kegler · Mar 29, 2017 Dollar Ranges How to setup dollar ranges to get the number of patient accounts. So, I want to capture the number of patient accounts based on the original balance of: 0 to 499 500 to 999 1000 to 2499 5000 to 9999 10000 to 24999 25000 to 49999 50000 to 74000 75000 to 99999 =100000 #MDX #InterSystems IRIS BI (DeepSee) 0 2 0 477
Question Derrek Kegler · Mar 16, 2017 Dollar Range I am building a pivot table and need help creating a calculated field for a dollar range. For instance, I am trying to create a calculated field to show account balance greater than $5k and less than $10k. #Analyzer #InterSystems IRIS BI (DeepSee) 0 2 0 333
Question Derrek Kegler · Mar 7, 2017 Grand Total How can I create a calculated field that will give me the grand total of a column? For instance, if I have a row that has 200, 300, 500, 600, how do I get the Grand Total? I have already used the wrench under Column Options as % of Total so, I can't use that option. #Analyzer #InterSystems IRIS BI (DeepSee) 0 9 0 429
Question Derrek Kegler · Mar 4, 2017 Calculated Fields How can I create a calculated field to give the previous date. For example, I need to create a pivot table that shows total payments posted for the prior day. How to create a calculated field to show average daily collections divided by the number of the days passed in a month. So, for today, it would be the average daily collections divided by 4days. Thanks! #InterSystems IRIS BI (DeepSee) 0 3 0 520
Question Derrek Kegler · Dec 2, 2016 DeepSee - Dashboards Is there a way to add a scroll bar to a widget on a dashboard. I want to shorten the width of my bar graph widget but it causes the bar graph to be scrunch together. Also, is there a way to expand the width between each bar on the graph?Thanks! #Dashboards #InterSystems IRIS BI (DeepSee) 0 2 0 373
All posts
All posts
All posts