cartercjb
03-18-2022ETL
BLOX WIDGET: PIVOT INSIDE A PIVOT
I have the following blox widget:
with the following code:
{
"style": ".blox-slides:not(:first-child) .blox-pivot-title{display:none} .blox-slides .blox-pivot-title{margin-bottom:10px; font-weight:bold; color:black; font-size:1em}",
"showCarousel": false,
"body": [
{
"type": "ColumnSet",
"spacing": "none",
"separator": false,
"columns": [
{
"type": "Column",
"width": "30%",
"spacing": "small",
"separator": true,
"items": [
{
"type": "TextBlock",
"class": "blox-pivot-title",
"separator": true,
"weight": "bold",
"horizontalAlignment": "left",
"text": "TPM"
},
{
"type": "TextBlock",
"weight": "light",
"horizontalAlignment": "left",
"separator": true,
"spacing": "none",
"text": "{panel:Therapist}"
}
]
},
{
"type": "Column",
"separator": true,
"width": "24%",
"spacing": "small",
"items": [
{
"type": "TextBlock",
"class": "blox-pivot-title",
"horizontalAlignment": "center",
"separator": true,
"text": "Billable Hours"
},
{
"type": "TextBlock",
"horizontalAlignment": "center",
"separator": true,
"weight": "light",
"spacing": "none",
"text": "{panel:Billable Hours}"
}
]
},
{
"type": "Column",
"width": "18%",
"spacing": "small",
"separator": true,
"items": [
{
"type": "TextBlock",
"class": "blox-pivot-title",
"separator": true,
"weight": "bold",
"horizontalAlignment": "center",
"text": "Drill Down"
},
{
"type": "ActionSet",
"separator": true,
"spacing": "none",
"actions": [
{
"type": "Action.ShowCard",
"imageSizes": "large",
"style": {
"font-size": "11px",
"color": "#fa1b7c",
"background-color": "#FFFFFF"
},
"title": "Details",
"card": {
"body": [
{
"type": "ColumnSet",
"spacing": "none",
"separator": false,
"columns": [
{
"type": "Column",
"width": "25%",
"spacing": "small",
"separator": true,
"items": [
{
"type": "TextBlock",
"class": "blox-pivot-title",
"separator": true,
"weight": "bold",
"horizontalAlignment": "center",
"text": "Therapist"
},
{
"type": "TextBlock",
"weight": "light",
"horizontalAlignment": "center",
"separator": true,
"spacing": "none",
"text": "{panel:Date}"
}
]
},
{
"type": "Column",
"width": "25%",
"spacing": "small",
"separator": true,
"items": [
{
"type": "TextBlock",
"class": "blox-pivot-title",
"separator": true,
"weight": "bold",
"horizontalAlignment": "center",
"text": "Billable Hours"
},
{
"type": "TextBlock",
"weight": "light",
"horizontalAlignment": "center",
"separator": true,
"spacing": "none",
"text": "{panel:Billable Hours}"
}
]
},
{
"type": "Column",
"width": "25%",
"spacing": "small",
"separator": true,
"items": [
{
"type": "TextBlock",
"class": "blox-pivot-title",
"separator": true,
"weight": "bold",
"horizontalAlignment": "center",
"text": "Billable NPC Hours"
},
{
"type": "TextBlock",
"weight": "light",
"horizontalAlignment": "center",
"separator": true,
"spacing": "none",
"text": "{panel:BILLABLE NPC HOURS}"
}
]
},
{
"type": "Column",
"width": "25%",
"spacing": "small",
"separator": true,
"items": [
{
"type": "TextBlock",
"class": "blox-pivot-title",
"separator": true,
"weight": "bold",
"horizontalAlignment": "center",
"text": "Onsite Duration"
},
{
"type": "TextBlock",
"weight": "light",
"horizontalAlignment": "center",
"separator": true,
"spacing": "none",
"text": "{panel:ONSITE DURATION}"
}
]
},
{
"type": "Column",
"width": "25%",
"spacing": "small",
"separator": true,
"items": [
{
"type": "TextBlock",
"class": "blox-pivot-title",
"separator": true,
"weight": "bold",
"horizontalAlignment": "center",
"text": "Productivity"
},
{
"type": "TextBlock",
"weight": "light",
"horizontalAlignment": "center",
"separator": true,
"spacing": "none",
"text": "{panel:PRODUCTIVITY}"
}
]
}
]
}
]
}
}
]
}
]
}
]
}
]
}
When you click on the Details link you get this view:
My goal is to change it so that when you click on the details view you see a detailed breakdown by day. However, when I add the date item it breaks it down on the first level and then shows this on the details: