cancel
Showing results for 
Search instead for 
Did you mean: 

BLOX WIDGET: PIVOT INSIDE A PIVOT

cartercjb
10 - ETL
10 - ETL

I have the following blox widget: 

cartercjb_1-1647629460323.png

 

 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:

cartercjb_2-1647629509001.png

 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:

cartercjb_6-1647629674234.png

cartercjb_5-1647629627259.png

 

0 REPLIES 0