FILTERED JTD BASED ON LIST ROW ITEM
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-11-2022 11:02 PM
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:
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
Labels:
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-14-2022 09:06 AM
Hi Carter,
Please take a look at this article ,https://support.sisense.com/kb/en/article/jump-to-dashboard-filter
Thanks,
Ronen
