Hi Team,
Could you please help me to understand how can I link my column values in the blox code. As per the below code I want to display Revenue in the dashboard but getting
{
"style": "",
"titleStyle": [
{
"display": "none"
}
],
"script": "[].slice.call( document.getElementsByClassName('blox-date') ).forEach(function ( div ) { div.innerHTML = new Date().toLocaleDateString(); })",
"title": "",
"showCarousel": true,
"carouselAnimation": {
"delay": 0,
"showButtons": false
},
"conditions": [
{
"minRange": "-Infinity",
"maxRange": 0,
"color": "#FA5656",
"image": "/plugins/BloX/blox-images/StockMarket/arrow-down.png"
},
{
"minRange": 0,
"maxRange": "Infinity",
"color": "#54a254",
"image": "/plugins/BloX/blox-images/StockMarket/arrow-up.png"
}
],
"body": [
{
"spacing": "",
"type": "Container",
"width": "100%",
"style": {
"margin": "0 auto"
},
"items": [
{
"type": "TextBlock",
"text": "FINANCIAL KPI'S | RUNNING WEEKLY TREND",
"class": "blox-pivot-title",
"horizontalAlignment": "center",
"size": "medium",
"style": {
"padding": "2px",
"border-radius": "5px",
"background-color": "#006374",
"color": "#ffffff"
}
},
{
"type": "ColumnSet",
"class": "condition_container ",
"columns": [
{
"type": "Column",
"items": [
{
"spacing": "small",
"type": "TextBlock",
"text": "REVENUE",
"horizontalAlignment": "center",
"weight": "bold",
"size": "small",
"style": {
"color": "#000000"
}
},
{
"type": "ColumnSet",
"class": "condition_container ",
"columns": [
{
"type": "Column",
"items": [
{
"type": "TextBlock",
"text": "{panel:REVENUE}",
"horizontalAlignment": "center",
"weight": "bold",
"size": "large",
"style": {
"color": "#a90a40"
}
}
]
}
]
},
{
"type": "ColumnSet",
"class": "condition_container",
"columns": [
{
"type": "Column",
"items": [
{
"type": "TextBlock",
"text": "<span class='blox-sparkline' type='line' line-color='#006374' width='200' height='30' line-width='2' fill-color='#B2D4DF' point-color:'#A90A40'>{spark:-21REVENUE},{spark:-14REVENUE},{spark:-7REVENUE}</span>",
"horizontalAlignment": "center",
"weight": "bold",
"size": "small",
"style": {
"color": "#117899"
}
}
]
}
]
},
{
"type": "ColumnSet",
"columns": [
{
"type": "Column",
"items": [
{
"type": "TextBlock",
"text": "BUDGET:",
"style": {
"text-align": "left",
"font-size": "small",
"font-style": "",
"color": "#d5d5d5"
}
},
{
"type": "TextBlock",
"text": "FULL MONTH FORECAST:",
"style": {
"text-align": "left",
"font-size": "small",
"font-style": "",
"color": "#d5d5d5"
}
}
]
},
{
"type": "Column",
"width": "30%",
"items": [
{
"type": "TextBlock",
"text": "{panel:REV_BUDGET}",
"style": {
"text-align": "center",
"font-size": "small",
"font-weight": "regular",
"color": "#006274",
"font-style": ""
}
},
{
"type": "TextBlock",
"text": "{panel:REVENUE_FORECAST}",
"style": {
"text-align": "center",
"font-size": "small",
"font-weight": "regular",
"color": "#006274",
"font-style": ""
}
}
]
}
]
}
]
},
{
"separator": true,
"type": "Column",
"items": [
{
"spacing": "small",
"type": "TextBlock",
"text": "CONTRIBUTION MARGIN",
"horizontalAlignment": "center",
"weight": "bold",
"size": "small",
"style": {
"color": "#000000"
}
},
{
"type": "TextBlock",
"text": "{panel:CONT. MARGIN $} ({panel: CM%})",
"horizontalAlignment": "center",
"weight": "bold",
"size": "large",
"style": {
"color": "#a90a40"
}
},
{
"type": "ColumnSet",
"class": "condition_container 2",
"columns": [
{
"type": "Column",
"items": [
{
"type": "TextBlock",
"text": "<span class='blox-sparkline' type='line' line-color='#006374' width='200' height='30' line-width='2' fill-color='#B2D4DF' point-color:'#117899'>{spark:-21CM$},{spark:-14CM$},{spark:-7CM$}</span>",
"horizontalAlignment": "center",
"weight": "bold",
"size": "small",
"style": {
"color": "#117899"
}
}
]
}
]
},
{
"type": "ColumnSet",
"columns": [
{
"type": "Column",
"items": [
{
"type": "TextBlock",
"text": "{panel:CM_BUDGET} ({panel:CMPERC_BUDGET})",
"style": {
"text-align": "right",
"font-size": "small",
"font-weight": "regular",
"color": "#006274",
"font-style": ""
}
},
{
"type": "TextBlock",
"text": "{panel:CM_FORECAST} ({panel:CM%})",
"style": {
"text-align": "right",
"font-size": "small",
"font-weight": "regular",
"color": "#006274",
"font-style": ""
}
}
]
}
]
}
]
},
{
"separator": true,
"type": "Column",
"items": [
{
"spacing": "small",
"type": "TextBlock",
"text": "PRODUCTIVITY",
"horizontalAlignment": "center",
"weight": "bold",
"size": "small",
"style": {
"color": "#000000"
}
},
{
"type": "TextBlock",
"text": "{panel:PRODUCTIVITY}",
"horizontalAlignment": "center",
"weight": "bold",
"size": "large",
"style": {
"color": "#a90a40"
}
},
{
"type": "ColumnSet",
"class": "condition_container 3",
"columns": [
{
"type": "Column",
"items": [
{
"type": "TextBlock",
"text": "<span class='blox-sparkline' type='line' line-color='#006374' width='200' height='30' line-width='2' fill-color='#B2D4DF' point-color:'#117899'>{spark:PROD_M1},{spark:PROD_M2}, {spark:PROD_M3}</span>",
"horizontalAlignment": "center",
"weight": "bold",
"size": "small",
"style": {
"color": "grey"
}
}
]
}
]
},
{
"type": "ColumnSet",
"columns": [
{
"type": "Column",
"items": [
{
"type": "TextBlock",
"text": "BUDGET:",
"style": {
"text-align": "left",
"font-size": "small",
"font-style": "",
"color": "#FFFFFF"
}
},
{
"type": "TextBlock",
"text": "PREV. MONTH:",
"style": {
"text-align": "left",
"font-size": "small",
"font-style": "",
"color": "#d5d5d5"
}
}
]
},
{
"type": "Column",
"items": [
{
"type": "TextBlock",
"text": "{panel:PROD_BUDGET}",
"style": {
"text-align": "center",
"font-size": "small",
"font-weight": "regular",
"color": "#006274",
"font-style": ""
}
},
{
"type": "TextBlock",
"text": "{panel:PRODUCTIVITY -1M}",
"style": {
"text-align": "center",
"font-size": "small",
"font-weight": "regular",
"color": "#006274",
"font-style": ""
}
}
]
}
]
}
]
}
]
}
]
}
],
"actions": []
}
Hi Hamzaj,
I have used the field name(ncc) in the blox code but still showing NA in the output.
Hi Hamzaj,
I used the false condition and now showing multiple values of ncc but i need sum(ncc) so that one single value will display.
Hi Hamzaj,
I have removed the NCC from item and getting single value but that value is incorrect with actual .
Its showing 5.% M but it shd be 7.2 M..is thr any reason for this?
Hi @Angelina_QBeeQ,
I am trying to display max date in the box panel. Getting blank value. kindly help on below sc.
Hi Silutions,
I have used the field name(ncc) in the blox code but still showing NA in the output.
Hi @Sijo1995 @HamzaJ @Silutions ,
I have created simple home page and wanted to add jump to dashboard feature into it. Kindly help me to integrate this feature into below code. Help me with one and will do it rest 3.
{
"style": "",
"script": "",
"title": "",
"showCarousel": true,
"body": [
{
"type": "Container",
"spacing": "extraLarge",
"style": {
"backgroundImage": "linear-gradient(#F5A9AA, #E97EA3)",
"box-shadow": "0 1px 3px 1px rgba(58,67,86,0.1)",
"padding": "50px"
},
"items": [
{
"type": "TextBlock",
"horizontalAlignment": "center",
"size": "large",
"weight": "bold",
"text": "SERVICING 360"
},
{
"type": "TextBlock",
"horizontalAlignment": "center",
"size": "medium",
"spacing": "small",
"text": "Open BloX Editor to customize filters"
}
]
},
{
"type": "Container",
"spacing": "extraLarge",
"width": "200px",
"Alignment": "center",
"style": {
"backgroundImage": "linear-gradient(#F5A9AA, #E97EA3)",
"box-shadow": "0 1px 3px 1px rgba(58,67,86,0.1)",
"padding": "20px"
},
"items": [
{
"type": "TextBlock",
"horizontalAlignment": "center",
"size": "large",
"weight": "bold",
"text": "SERVICING 360"
}
]
}
],
"actions": [
{
"type": "Filters",
"title": "Contact Sense Overview",
"data": {
"filters": [
{
"filterName": "Stage",
"filterJaql": {
"explicit": true,
"members": [
"Prospect"
]
}
},
{
"filterName": "Days in Date",
"filterJaql": {
"last": {
"count": 7,
"offset": 0
}
}
}
]
}
},
{
"type": "Filters",
"title": "Calls by Number of Topics",
"data": {
"filters": [
{
"filterName": "Stage",
"filterJaql": {
"explicit": true,
"members": [
"Prospect"
]
}
},
{
"filterName": "Risk Level",
"filterJaql": {
"from": 4
}
}
]
}
},
{
"type": "Filters",
"title": "Top Topics",
"data": {
"filters": [
{
"filterName": "Stage",
"filterJaql": {
"explicit": true,
"members": [
"Prospect"
]
}
},
{
"filterName": "Days Open",
"filterJaql": {
"from": 90
}
}
]
}
},
{
"type": "Filters",
"title": "Pair Topics",
"data": {
"filters": [
{
"filterName": "Stage",
"filterJaql": {
"explicit": true,
"members": [
"Prospect"
]
}
},
{
"filterName": "Days Open",
"filterJaql": {
"from": 90
}
}
]
}
}
]
}
