{
const { qdtCompose, QdtTable } = QdtComponents;
qdtCompose({
element,
component: QdtTable,
app,
options: { multiple: false },
properties: {
qHyperCubeDef: {
qDimensions: [
{
qDef: { qLabel: 'Case Number', qFieldDefs: ['CaseNumber'] },
},
{
qDef: { qLabel: 'Subject', qFieldDefs: ['Subject'] },
},
{
qDef: { qLabel: 'Case Owner', qFieldDefs: ['Case Owner'] },
},
{
qDef: { qLabel: 'Status', qFieldDefs: ['Status'] },
},
{
qDef: { qLabel: 'Case Created Date', qFieldDefs: ['Case Created Date'] },
},
{
qDef: { qLabel: 'Case Closed Date', qFieldDefs: ['Case Closed Date'] },
},
],
qMeasures: [
{
qDef: {
qLabel: 'Case Duration (dd hh:mm)',
qDef: "If(Count({$<[Case Is Closed]={'True'} >} %CaseId)>0, Avg ([Case Duration Time]),0)+ If(Count({$<[Case Is Closed]={'False'} >} %CaseId)>0, Avg([Case Aging]), 0)",
qNumFormat: { qType: 'D', qFmt: 'dd hh:mm' },
},
qSortBy: { qSortByNumeric: -1 },
},
],
},
}
});
}