cancel
Showing results for 
Search instead for 
Did you mean: 

FILTERED JTD BASED ON LIST ROW ITEM

cartercjb
10 - ETL
10 - ETL

I have the following blox widget based on this code:

{
    "style": ".blox-slides:not(:first-child) .blox-pivot-title{display:none} .blox-slides .blox-pivot-title{margin-bottom:2px;font-weight:bold; color:black}",
    "titleStyle": [
        {
            "display": "none"
        }
    ],
    "showCarousel": false,
    "body": [
        {
            "weight": "light",
            "type": "Container",
            "width": "97%",
            "style": {
                "margin": "0 auto"
            },
            "items": [
                {
                    "type": "TextBlock",
                    "text": "<span>TPM BILLABLE HOURS</span>",
                    "horizontalAlignment": "center",
                    "size": "Mlarge",
                    "class": "blox-pivot-title",
                    "style": {
                        "background-color": "#006374",
                        "padding": "5px",
                        "border-radius": "5px",
                        "text-align": "center",
                        "color": "#ffffff"
                    }
                },
                {
                    "type": "ColumnSet",
                    "style": {
                        "background-color": "white",
                        "padding": "0px",
                        "font-style": "normal",
                        "text-align": "left"
                    },
                    "columns": [
                        {
                            "type": "Column",
                            "spacing": "default",
                            "width": "40%",
                            "items": [
                                {
                                    "size": "medium",
                                    "type": "TextBlock",
                                    "id": "",
                                    "class": "blox-pivot-title",
                                    "separator": false,
                                    "horizontalAlignment": "center",
                                    "vertical-align": "middle",
                                    "text": "TPM",
                                    "style": {
                                        "padding": "5px",
                                        "font-weight": "light",
                                        "backgroundColor": "#a90a40",
                                        "color": "#ffffff"
                                    },
                                    "backgroundColor": "blue"
                                },
                                {
                                    "type": "TextBlock",
                                    "size": "small",
                                    "weight": "light",
                                    "horizontalAlignment": "left",
                                    "separator": true,
                                    "spacing": "none",
                                    "text": "{panel:Therapist}",
                                    "style": {
                                        "text-indent": "0.5em",
                                        "border-right": "1px solid #a7a7a7",
                                        "border-left": "1px solid #a7a7a7",
                                        "border-bottom": "1px solid #A7A7A7",
                                        "border-top": "1px solid #A7A7A7",
                                        "padding": "5px 5px 5px 5px"
                                    }
                                }
                            ]
                        },
                        {
                            "type": "Column",
                            "spacing": "default",
                            "width": "20%",
                            "items": [
                                {
                                    "size": "medium",
                                    "type": "TextBlock",
                                    "id": "",
                                    "class": "blox-pivot-title",
                                    "separator": false,
                                    "horizontalAlignment": "center",
                                    "vertical-align": "middle",
                                    "text": "Billable Hours",
                                    "style": {
                                        "padding": "5px",
                                        "font-weight": "light",
                                        "backgroundColor": "#a90a40",
                                        "color": "#ffffff"
                                    },
                                    "backgroundColor": "blue"
                                },
                                {
                                    "type": "TextBlock",
                                    "weight": "light",
                                    "size": "small",
                                    "horizontalAlignment": "center",
                                    "separator": true,
                                    "spacing": "none",
                                    "text": "{panel:Billable Hours}",
                                    "style": {
                                        "border-right": "1px solid #a7a7a7",
                                        "border-left": "1px solid #a7a7a7",
                                        "border-bottom": "1px solid #A7A7A7",
                                        "border-top": "1px solid #A7A7A7",
                                        "padding": "5px 5px 5px 5px"
                                    }
                                }
                            ]
                        },
                        {
                            "type": "Column",
                            "spacing": "default",
                            "width": "40%",
                            "items": [
                                {
                                    "size": "medium",
                                    "type": "TextBlock",
                                    "id": "",
                                    "class": "blox-pivot-title",
                                    "separator": false,
                                    "horizontalAlignment": "center",
                                    "vertical-align": "middle",
                                    "text": "Drill Down",
                                    "style": {
                                        "padding": "5px",
                                        "font-weight": "light",
                                        "backgroundColor": "#a90a40",
                                        "color": "#ffffff"
                                    },
                                    "backgroundColor": "blue"
                                },
                                {
                                    "type": "ActionSet",
                                    "size": "small",
                                    "weight": "light",
                                    "separator": true,
                                    "spacing": "none",
                                    "style": {
                                        "border-right": "1px solid #a7a7a7",
                                        "border-left": "1px solid #a7a7a7",
                                        "border-bottom": "1px solid #A7A7A7",
                                        "border-top": "1px solid #A7A7A7",
                                        "padding": "0px 0px 0px 0px"
                                    },
                                    "actions": [
                                        {
                                            "type": "JTD",
                                            "style": {
                                                "font-size": "small",
                                                "weight": "light",
                                                "color": "#99b52c",
                                                "separator": true,
                                                "spacing": "none",
                                                "background-color": "#ffffff",
                                                "vertical-align": "top"
                                            },
                                            "title": "PRODUCTIVITY DETAIL",
                                            "data": {
                                                "dashboardId": "6234dad0be4b2e2fc893b372",
                                                "args": {
                                                    "displayDashboardsPane": false,
                                                    "displayFilterPane": true,
                                                    "displayToolbarRow": false,
                                                    "displayHeaderRow": false
                                                }
                                            }
                                        }
                                    ]
                                }
                            ]
                        }
                    ]
                }
            ]
        }
    ]
}

This looks something like this:

cartercjb_0-1649743044067.png

I have a JTD configured in the Drill Down column. Is there a way to filter the JTD report based on the row that is selected? For instance, if the end-user selects the PRODUCTIVITY DETAIL button for Person 1, then the JTD report will be filtered for Person 1 only. If the end-user selects Person 2 then the JTD report will be filtered for Person 2 only.

Thanks!

-Carter

1 REPLY 1

ronenavidor
Sisense Team Member
Sisense Team Member

Hi Carter,

Please take a look at this article ,https://support.sisense.com/kb/en/article/jump-to-dashboard-filter 

Thanks,

Ronen