2c:null 2d:["$","title",null,{"children":"Enigma.js - Simple Hypercube - Get All Data | Yianni Ververis | Observable"}] 32:T678,{ const app = await enigmaApp; const properties = { qInfo: { qType: 'visualization' }, qHyperCubeDef: { qDimensions: [ { qDef: { qFieldDefs: ['Case Owner Group'] }, qNullSuppression: true }, { qDef: { qFieldDefs: ['Priority'] }, qNullSuppression: true }, ], qMeasures: [ { qDef: { qDef: 'Avg([Case Duration Time])', autoSort: false }, qSortBy: { qSortByNumeric: -1 }}, ], qInitialDataFetch: [{ qTop: 0, qLeft: 0, qWidth: 3, qHeight: 5, }], qSortByAscii: 1, qSortByLoadOrder: 1, qInterColumnSortOrder: [1, 0], qSuppressZero: true, qSuppressMissing: true, } } const model = await app.createSessionObject(properties); let layout = await model.getLayout(); let data = layout.qHyperCube.qDataPages[0].qMatrix const columns = layout.qHyperCube.qSize.qcx; const totalheight = layout.qHyperCube.qSize.qcy; const pageheight = 5 // Math.floor(10000 / columns); const numberOfPages = Math.ceil(totalheight / pageheight); for (let i = 1; i < numberOfPages; i++) { const page = { qTop: pageheight * i, qLeft: 0, qWidth: columns, qHeight: pageheight, }; const row = await model.getHyperCubeData('/qHyperCubeDef', [page]); data.push(...row[0].qMatrix); } const table = data.map(x => `${x[0].qText}${x[1].qText}${x[2].qText}`); return html` ${table}

Department	Priority	Avg Duration

` }33:[] 30:{"id":"966d8b3a0e303e93","slug":"enigma-js-simple-hypercube-get-all-data","title":"Enigma.js - Simple Hypercube - Get All Data","thumbnail":"b5e49dc752aeb6a12105798676a02d0855b3042c593402a47ed0a7919ca2b286","access_level":"public","create_time":"$D2021-05-04T13:01:26.996Z","update_time":"$D2021-05-05T10:29:23.953Z","view_time":null,"first_public_time":"$D2021-05-04T15:08:17.793Z","fork":false,"stars":1,"starred":false,"owner":{"type":"team","id":"24e10c5750ae65d4","login":"yianni-ververis","name":"Yianni Ververis","avatar_url":"https://avatars-next.observableusercontent.com/45072eb4ccbd6107e214687245157298c6142795aa301eccd10faf1d15c48eef","tier":"starter_2024"},"version":81,"publish_version":81,"role":null,"authored":false,"authors":[{"type":"individual","id":"064a3ff4daa514a9","login":"yianni-ververis","name":"Yianni Ververis","avatar_url":"https://avatars-next.observableusercontent.com/45072eb4ccbd6107e214687245157298c6142795aa301eccd10faf1d15c48eef","tier":null}],"members":[{"type":"individual","id":"064a3ff4daa514a9","login":"yianni-ververis","name":"Yianni Ververis","avatar_url":"https://avatars-next.observableusercontent.com/45072eb4ccbd6107e214687245157298c6142795aa301eccd10faf1d15c48eef","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":1,"collection":{"id":"5d7e911b2970a372","slug":"enigmajs","title":"Enigma","owner":{"id":"24e10c5750ae65d4","login":"yianni-ververis","name":"Yianni Ververis"}},"type":"notebook","body":{"title":"Enigma.js - Simple Hypercube - Get All Data","cells":[{"id":0,"value":"md`# Enigma.js - Simple Hypercube - Get All Data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":7,"value":"import { enigmaApp } from \"@yianni-ververis/enigma-js\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":4,"value":"$32","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"}],"files":"$W33","stdlib":"1","titling":"auto"}} 31:"$30:body"