Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to set or create alternate state using visualization API, could anyone place share the insights on this?
app.visualization.create(
'table',
[
{
"qDef": {
"qFieldDefs": [
"=If(Par>3,TClubName)"
],
"qFieldLabels": [
"Tee club"
],
"qSortCriterias": [
{
"qSortByLoadOrder": 1
}
]
},
"qNullSuppression": true
},
{
"qDef": {
"qLabel": "#",
"qDef": "Count(HoID)"
},
"qAttributeExpressions": [
{
"qExpression": "If(Count(HoID)<10,RGB(255, 115, 115))",
"id": "cellForegroundColor"
}
]
},
{
"qDef": {
"qLabel": "FIR%",
"qDef": "Avg(FwHit)",
"qNumFormat": {
"qType": "F",
"qnDec": 2,
"qUseThou": 0,
"qFmt": "0.0%",
"qDec": ".",
"qThou": ","
}
},
"qAttributeExpressions": [
{
"qExpression": "If(Avg(FwHit)<0.5,RGB(255, 115, 115),If(Avg(FwHit)>0.7,RGB(145, 194, 106)))",
"id": "cellBackgroundColor"
}
]
},
{
"qDef": {
"qLabel": "Avg",
"qDef": "Avg(DrDist)",
"qNumFormat": {
"qType": "F",
"qnDec": 2,
"qUseThou": 0,
"qFmt": "#,##0.00 m",
"qDec": ".",
"qThou": ","
},
"numFormatFromTemplate": false
}
},
{
"qDef": {
"qLabel": "Max",
"qDef": "Max(DrDist)",
"qNumFormat": {
"qType": "F",
"qnDec": 2,
"qUseThou": 0,
"qFmt": "#,##0 m",
"qDec": ".",
"qThou": ","
},
"numFormatFromTemplate": false
}
}
],
{
"showTitles": true,
"title": "Off the tee (Par 4s and Par 5s)"
}
).then(function(vis){
vis.show("QV01");
});
//I tried this way didn't work
app.visualization.create(
'table',
[{
"qDef": {
"qFieldDefs": [
"[EMR_CODE]"
],
"qFieldLabels": [
"MRN"
],
"qSortCriterias": [{
"qSortByLoadOrder": 1
}]
},
"qNullSuppression": true
},
{
"qDef": {
"qFieldDefs": [
"[REGNO]"
],
"qFieldLabels": [
"REGNO"
],
"qSortCriterias": [{
"qSortByLoadOrder": 1
}]
},
"qNullSuppression": true,
"qStateName": "DRGSelect",
},
], {}
).then(function (vis) {
vis.show("QV1");
});
It didn't work..:(