Dashboard randomly displaying incorrect data

Question

Question

Mike Rowland · Jan 17, 2023

#Analytics #Analyzer #Dashboards #Visualization #InterSystems IRIS BI (DeepSee)

I built a dashboard to show hourly instrument capacities based on a term list. The term list consists of the TestInstrumentID and the number of tests that instrument can perform in 1 hour. The calculation works correctly and the data is accurate but periodically if you go to check the dashboard the percentages all get changed to 100% across every hour. If you check it later or add an additional site to the filter then the percentages correct themselves. I don't know what's causing this or how to troubleshoot it because it does calculate correctly but is not consistent.

Product version: Caché 2016.1

$ZV: Cache for Windows (x86-64) 2016.2 (Build 736_0_18100U)

Discussion (6)3

Log in or sign up to continue

score 0 · Answer 1 · 2023-01-17T10:23:37-05:00

Oliver Wilms · Jan 17, 2023

Hard to help without seeing the actual calculation code

0 0

score 0 · Answer 2 · 2023-01-17T15:27:34-05:00

ah, yes, good point, sorry, first post.

Here is the query:

SELECT NON EMPTY NONEMPTYCROSSJOIN([IMResultDateTimeD].[H1].[IMResultDateHour].Members,%LABEL([MEASURES].[CAPACITIESTEST],"","#%")) ON 0,NON EMPTY [TestInstrumentIDD].[H1].[TestInstrumentID].Members ON 1 FROM [IMTESTCUBE] %FILTER [IMResultDateTimeD].[H1].[IMResultDateDayMonthYear].&[NOW] %FILTER ([ConnectionLocationD].[H1].[ConnectionLocation].&[(NULL)].%NOT,[ConnectionLocationD].[H1].[ConnectionLocation].&[System].%NOT)

And here is how I have capacityTest defined:

[TestStatusD].[H1].[TestStatus].&[Released]/%LOOKUP("Capacity",[TestInstrumentIDD].[H1].[TestInstrumentID].CURRENTMEMBER.Properties("Name"))

score 0 · Answer 3 · 2023-01-17T13:55:21-05:00

Evgeny Shvarov · Jan 17, 2023

Hi Mike! Do you want to try DSW for visualization IRIS-BI (DeepSee) dashboards?

0 0

score 0 · Answer 4 · 2023-01-17T15:31:44-05:00

Hi Evgeny,

I'm not familiar with DSW, only started building dashboards via DeepSee User Portal within the last 6 months or so. I see it says the application is not supported by intersystems. What can DSW do for me and how difficult is it to setup? Would this affect maintenance agreements?

score 0 · Answer 5 · 2023-01-18T02:58:41-05:00

Yes, it is a community project with open source. Basically it can render all your existing dashboards via Angular UI that works with a REST-API endpoint.

It can be installed in IRIS with IPM, using:

USER>zpm "install dsw"

score 0 · Answer 6 · 2023-02-17T06:13:21-05:00

Thank you for all your responses. We discovered, with Intersystems help, there is a bug in our current version of Cache 2018.1.7. We found a workaround by excluding the NOW hour.