{ "title": "Sample Healthcare - Bucketing 30/60/90 Days", "oid": "6696a51416425d00337483a0", "desc": "", "source": null, "type": "dashboard", "style": { "palette": { "name": "Vivid", "colors": [ "#00cee6", "#9b9bd7", "#6EDA55", "#fc7570", "#fbb755", "#218A8C" ] } }, "layout": { "instanceid": "F2137-4B8B-E7", "type": "columnar", "columns": [ { "width": 100, "cells": [ { "subcells": [ { "elements": [ { "minHeight": 128, "maxHeight": 2048, "minWidth": 128, "maxWidth": 2048, "height": "305px", "defaultWidth": 512, "widgetid": "6696a65a16425d00337483a2", "autoHeight": "305px" } ], "width": 100, "stretchable": false, "pxlWidth": 0, "index": 0 } ] } ], "pxlWidth": 0, "index": 0 } ], "container": { "sizzle1721148643942": { "undefined": { "parentNode": [ 1387.1585142175159, 31, true ] } } } }, "original": null, "dataExploration": false, "lastOpened": null, "previewLayout": [], "datasource": { "address": "LocalHost", "title": "Sample Healthcare", "id": "localhost_aSampleIAAaHealthcare", "database": "aSampleIAAaHealthcare", "fullname": "localhost/Sample Healthcare", "live": false }, "filters": [], "editing": true, "settings": { "autoUpdateOnFiltersChange": true }, "widgets": [ { "title": "Number of Admissions by Diagnosis and Length of Stay", "type": "pivot2", "subtype": "pivot2", "oid": "6696a65a16425d00337483a2", "desc": null, "source": null, "datasource": { "address": "LocalHost", "title": "Sample Healthcare", "id": "localhost_aSampleIAAaHealthcare", "database": "aSampleIAAaHealthcare", "fullname": "localhost/Sample Healthcare", "live": false }, "selection": null, "metadata": { "ignore": { "dimensions": [], "ids": [], "all": false }, "panels": [ { "name": "rows", "items": [ { "jaql": { "table": "Diagnosis", "column": "Description", "dim": "[Diagnosis.Description]", "datatype": "text", "merged": true, "title": "Diagnosis" }, "instanceid": "C0434-A6F0-2A", "panel": "rows", "field": { "id": "[Diagnosis.Description]", "index": 0 } } ] }, { "name": "values", "items": [ { "jaql": { "type": "measure", "formula": "SUM([BDCDF-929],\n CASE WHEN MAX(DDIFF([B8816-CF9], [E07E3-B2E])) < 30 THEN 1\n ELSE 0\n END\n)", "context": { "[E07E3-B2E]": { "table": "Admissions", "column": "Admission_Time", "dim": "[Admissions.Admission_Time (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Admission_Time" }, "[B8816-CF9]": { "table": "Admissions", "column": "Discharge_Time", "dim": "[Admissions.Discharge_Time (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Discharge_Time" }, "[BDCDF-929]": { "table": "Admissions", "column": "ID", "dim": "[Admissions.ID]", "datatype": "numeric", "title": "ID" } }, "title": "Admitted < 30 Days", "advancedFormulaFlag": false, "datatype": "numeric" }, "instanceid": "532AA-9F92-3D", "panel": "measures", "field": { "id": "MAX(DDIFF([B48F0-538], [0B5FB-07F]))", "index": 1 }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color" } } }, { "jaql": { "type": "measure", "formula": "SUM([0D0E4-660],\n CASE WHEN MAX(DDIFF([AB485-527], [C923E-2EF])) >= 30 AND \n\t\t MAX(DDIFF([AB485-527], [C923E-2EF])) <= 60THEN 1\n ELSE 0\n END\n)", "context": { "[C923E-2EF]": { "table": "Admissions", "column": "Admission_Time", "dim": "[Admissions.Admission_Time (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Admission_Time" }, "[AB485-527]": { "table": "Admissions", "column": "Discharge_Time", "dim": "[Admissions.Discharge_Time (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Discharge_Time" }, "[0D0E4-660]": { "table": "Admissions", "column": "ID", "dim": "[Admissions.ID]", "datatype": "numeric", "title": "ID" } }, "title": "Admitted 30-60 Days", "advancedFormulaFlag": false, "datatype": "numeric", "pv": { "Visible in View>Yes": 2, "Aggregation>Count": 2 } }, "instanceid": "532AA-9F92-3D", "panel": "measures", "field": { "id": "MAX(DDIFF([B48F0-538], [0B5FB-07F]))", "index": 2 }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color" } }, "disabled": false }, { "jaql": { "type": "measure", "formula": "SUM([95F6F-E96],\n CASE WHEN MAX(DDIFF([34725-821], [25D0A-159])) > 60 AND \n\t\t MAX(DDIFF([34725-821], [25D0A-159])) <= 90THEN 1\n ELSE 0\n END\n)", "context": { "[25D0A-159]": { "table": "Admissions", "column": "Admission_Time", "dim": "[Admissions.Admission_Time (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Admission_Time" }, "[34725-821]": { "table": "Admissions", "column": "Discharge_Time", "dim": "[Admissions.Discharge_Time (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Discharge_Time" }, "[95F6F-E96]": { "table": "Admissions", "column": "ID", "dim": "[Admissions.ID]", "datatype": "numeric", "title": "ID" } }, "title": "Admitted 61-90 Days", "advancedFormulaFlag": false, "datatype": "numeric", "pv": { "Visible in View>Yes": 2, "Aggregation>Count": 2 } }, "instanceid": "532AA-9F92-3D", "panel": "measures", "field": { "id": "MAX(DDIFF([B48F0-538], [0B5FB-07F]))", "index": 3 }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color" } }, "disabled": false }, { "jaql": { "type": "measure", "formula": "SUM([2C655-0F3],\n CASE WHEN MAX(DDIFF([6CA37-A2C], [322AF-CB3])) > 90 THEN 1\n ELSE 0\n END\n)", "context": { "[322AF-CB3]": { "table": "Admissions", "column": "Admission_Time", "dim": "[Admissions.Admission_Time (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Admission_Time" }, "[6CA37-A2C]": { "table": "Admissions", "column": "Discharge_Time", "dim": "[Admissions.Discharge_Time (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Discharge_Time" }, "[2C655-0F3]": { "table": "Admissions", "column": "ID", "dim": "[Admissions.ID]", "datatype": "numeric", "title": "ID" } }, "title": "Admitted 90+ Days", "advancedFormulaFlag": false, "datatype": "numeric" }, "instanceid": "532AA-9F92-3D", "panel": "measures", "field": { "id": "MAX(DDIFF([B48F0-538], [0B5FB-07F]))", "index": 4 }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color" } }, "disabled": false }, { "jaql": { "type": "measure", "formula": "[1D4E3-2DD]", "context": { "[1D4E3-2DD]": { "table": "Admissions", "column": "ID", "dim": "[Admissions.ID]", "datatype": "numeric", "agg": "count", "title": "# of unique ID" } }, "advancedFormulaFlag": false, "datatype": "numeric", "title": "Total Admissions" }, "instanceid": "532AA-9F92-3D", "panel": "measures", "field": { "id": "MAX(DDIFF([B48F0-538], [0B5FB-07F]))", "index": 5 }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color" } } } ] }, { "name": "columns", "items": [] }, { "name": "filters", "items": [] } ], "usedFormulasMapping": {} }, "style": { "scroll": false, "pageSize": 25, "automaticHeight": true, "colors": { "rows": true, "columns": false, "headers": false, "members": false, "totals": false }, "narration": { "enabled": false, "display": "above", "format": "bullets", "verbosity": "medium", "up_sentiment": "good", "aggregation": "sum", "labels": [ { "id": "description", "title": "Description", "singular": "Description", "plural": "Description" } ] } }, "instanceid": "3AA77-A260-69", "wasRendered": false, "drillToDashboardConfig": { "drilledDashboardPrefix": "_drill", "drilledDashboardsFolderPrefix": "", "displayFilterPane": true, "displayDashboardsPane": true, "displayToolbarRow": true, "displayHeaderRow": true, "volatile": false, "hideDrilledDashboards": true, "hideSharedDashboardsForNonOwner": true, "drillToDashboardMenuCaption": "Jump to dashboard", "drillToDashboardRightMenuCaption": "Jump to ", "drillToDashboardNavigateType": 2, "drillToDashboardNavigateTypePivot": 2, "drillToDashboardNavigateTypeCharts": 1, "drillToDashboardNavigateTypeOthers": 3, "excludeFilterDims": [], "includeFilterDims": [], "drilledDashboardDisplayType": 2, "dashboardIds": [], "modalWindowResize": false, "showFolderNameOnMenuSelection": false, "resetDashFiltersAfterJTD": false, "sameCubeRestriction": true, "showJTDIcon": true, "sendPieChartMeasureFiltersOnClick": true, "forceZeroInsteadNull": false, "mergeTargetDashboardFilters": false, "drillToDashboardByName": false }, "query": { "datasource": { "fullname": "localhost/Sample Healthcare", "id": "localhost_aSampleIAAaHealthcare", "address": "LocalHost", "database": "aSampleIAAaHealthcare", "live": false, "title": "Sample Healthcare" }, "format": "pivot", "grandTotals": { "title": "Grand Total" }, "metadata": [ { "jaql": { "table": "Diagnosis", "column": "Description", "dim": "[Diagnosis.Description]", "datatype": "text", "merged": true, "title": "Diagnosis" }, "instanceid": "C0434-A6F0-2A", "panel": "rows", "field": { "id": "[Diagnosis.Description]", "index": 0 } }, { "jaql": { "type": "measure", "formula": "SUM([BDCDF-929],\n CASE WHEN MAX(DDIFF([B8816-CF9], [E07E3-B2E])) < 30 THEN 1\n ELSE 0\n END\n)", "context": { "[E07E3-B2E]": { "table": "Admissions", "column": "Admission_Time", "dim": "[Admissions.Admission_Time (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Admission_Time" }, "[B8816-CF9]": { "table": "Admissions", "column": "Discharge_Time", "dim": "[Admissions.Discharge_Time (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Discharge_Time" }, "[BDCDF-929]": { "table": "Admissions", "column": "ID", "dim": "[Admissions.ID]", "datatype": "numeric", "title": "ID" } }, "title": "Admitted < 30 Days", "advancedFormulaFlag": false, "datatype": "numeric" }, "instanceid": "532AA-9F92-3D", "panel": "measures", "field": { "id": "MAX(DDIFF([B48F0-538], [0B5FB-07F]))", "index": 1 }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } } }, { "jaql": { "type": "measure", "formula": "SUM([0D0E4-660],\n CASE WHEN MAX(DDIFF([AB485-527], [C923E-2EF])) >= 30 AND \n\t\t MAX(DDIFF([AB485-527], [C923E-2EF])) <= 60THEN 1\n ELSE 0\n END\n)", "context": { "[C923E-2EF]": { "table": "Admissions", "column": "Admission_Time", "dim": "[Admissions.Admission_Time (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Admission_Time" }, "[AB485-527]": { "table": "Admissions", "column": "Discharge_Time", "dim": "[Admissions.Discharge_Time (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Discharge_Time" }, "[0D0E4-660]": { "table": "Admissions", "column": "ID", "dim": "[Admissions.ID]", "datatype": "numeric", "title": "ID" } }, "title": "Admitted 30-60 Days", "advancedFormulaFlag": false, "datatype": "numeric", "pv": { "Visible in View>Yes": 2, "Aggregation>Count": 2 } }, "instanceid": "532AA-9F92-3D", "panel": "measures", "field": { "id": "MAX(DDIFF([B48F0-538], [0B5FB-07F]))", "index": 2 }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "disabled": false }, { "jaql": { "type": "measure", "formula": "SUM([95F6F-E96],\n CASE WHEN MAX(DDIFF([34725-821], [25D0A-159])) > 60 AND \n\t\t MAX(DDIFF([34725-821], [25D0A-159])) <= 90THEN 1\n ELSE 0\n END\n)", "context": { "[25D0A-159]": { "table": "Admissions", "column": "Admission_Time", "dim": "[Admissions.Admission_Time (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Admission_Time" }, "[34725-821]": { "table": "Admissions", "column": "Discharge_Time", "dim": "[Admissions.Discharge_Time (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Discharge_Time" }, "[95F6F-E96]": { "table": "Admissions", "column": "ID", "dim": "[Admissions.ID]", "datatype": "numeric", "title": "ID" } }, "title": "Admitted 61-90 Days", "advancedFormulaFlag": false, "datatype": "numeric", "pv": { "Visible in View>Yes": 2, "Aggregation>Count": 2 } }, "instanceid": "532AA-9F92-3D", "panel": "measures", "field": { "id": "MAX(DDIFF([B48F0-538], [0B5FB-07F]))", "index": 3 }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "disabled": false }, { "jaql": { "type": "measure", "formula": "SUM([2C655-0F3],\n CASE WHEN MAX(DDIFF([6CA37-A2C], [322AF-CB3])) > 90 THEN 1\n ELSE 0\n END\n)", "context": { "[322AF-CB3]": { "table": "Admissions", "column": "Admission_Time", "dim": "[Admissions.Admission_Time (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Admission_Time" }, "[6CA37-A2C]": { "table": "Admissions", "column": "Discharge_Time", "dim": "[Admissions.Discharge_Time (Calendar)]", "datatype": "datetime", "merged": true, "level": "days", "title": "Days in Discharge_Time" }, "[2C655-0F3]": { "table": "Admissions", "column": "ID", "dim": "[Admissions.ID]", "datatype": "numeric", "title": "ID" } }, "title": "Admitted 90+ Days", "advancedFormulaFlag": false, "datatype": "numeric" }, "instanceid": "532AA-9F92-3D", "panel": "measures", "field": { "id": "MAX(DDIFF([B48F0-538], [0B5FB-07F]))", "index": 4 }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } }, "disabled": false }, { "jaql": { "type": "measure", "formula": "[1D4E3-2DD]", "context": { "[1D4E3-2DD]": { "table": "Admissions", "column": "ID", "dim": "[Admissions.ID]", "datatype": "numeric", "agg": "count", "title": "# of unique ID" } }, "advancedFormulaFlag": false, "datatype": "numeric", "title": "Total Admissions" }, "instanceid": "532AA-9F92-3D", "panel": "measures", "field": { "id": "MAX(DDIFF([B48F0-538], [0B5FB-07F]))", "index": 5 }, "format": { "mask": { "type": "number", "t": true, "b": true, "separated": true, "decimals": "auto", "isdefault": true }, "color": { "type": "color", "color": "transparent" } } } ], "m2mThresholdFlag": 0, "isMaskedResult": true, "widgetType": "pivot2", "by": "widget", "dashboard": "6696a51416425d00337483a0;Sample Healthcare", "offset": 0, "count": -1, "widget": "6696a65a16425d00337483a2;", "queryGuid": "C8D77-2CF0-7086-3379-D180-43B7-EC2F-95A2-6", "xTenantId": "613b0200bb44e7001b4fc914" }, "realTimeRefreshing": false, "options": { "dashboardFiltersMode": "filter", "selector": false, "triggersDomready": true, "drillToAnywhere": true, "autoUpdateOnEveryChange": true, "interactivePivot": { "enable": false } }, "dashboardid": "6696a51416425d00337483a0" } ], "hierarchies": [] }