Hello folks,

As im not CRM analytics developer its hard for me to set this up, maybe you can help!  This is TCRM our of the box leaderboard component. I just want to set a dynamic reference line with TODAY() date. Can you help? it can be done only with JSON editing. Attached how it should look like 

{
"parameters": {
"totalValue": "computeTotal",
"showPoints": true,
"legend": {
"descOrder": false,
"showHeader": true,
"show": false,
"customSize": "auto",
"position": "right-top",
"inside": false
},
"axisMode": "sync",
"tooltip": {
"content": {
"legend": {
"showBinLabel": true,
"measures": [],
"showNullValues": true,
"customizeLegend": false,
"showPercentage": true,
"showDimensions": true,
"showMeasures": true,
"dimensions": []
}
}
},
"visualizationType": "time",
"missingValue": "connect",
"dashLine": {
"measures": "",
"showDashLine": false
},
"exploreLink": false,
"timeAxis": {
"showTitle": false,
"predictiveLine": {
"color": "#9271E8",
"label": "TODAY"
},
"showAxis": true,
"title": ""
},
"title": {
"fontSize": 14,
"subtitleFontSize": 11,
"label": "",
"align": "center",
"subtitleLabel": ""
},
"trellis": {
"flipLabels": false,
"showGridLines": true,
"size": [
100,
100
],
"enable": false,
"type": "x",
"parameters": {},
"chartsPerLine": 4
},
"totalLabel": "",
"fillArea": true,
"showActionMenu": true,
"showZero": true,
"measureAxis2": {
"sqrtScale": false,
"showTitle": true,
"showAxis": true,
"title": "",
"customDomain": {
"showDomain": false
}
},
"measureAxis1": {
"sqrtScale": false,
"showTitle": false,
"showAxis": true,
"referenceLines": [
{
"color": "#2EC2BA",
"label": {
"data": "Quota - $ {{coalesce(cell(kpi_quota.result, 0, \"sum_quota\"),0).asObject()}}",
"type": "static"
},
"value": {
"data": "{{coalesce(cell(kpi_quota.result, 0, \"sum_quota\"), 0).asObject()}}",
"type": "static"
}
}
],
"title": "",
"customDomain": {
"showDomain": false
}
},
"valueType": "none",
"step": "time_chart_forecast_NEW",
"theme": "dark",
"applyConditionalFormatting": false,
"drawArea": {
"measure": "",
"showDrawArea": false,
"bounding1": "",
"bounding2": ""
}
},
"type": "chart"
}

Hello folks,

As im not CRM analytics developer its hard for me to set this up, maybe you can help!  This is TCRM our of the box leaderboard component. I just want to set a dynamic reference line with TODAY() date. Can you help? it can be done only with JSON editing. Attached how it should look like 

{
"parameters": {
"totalValue": "computeTotal",
"showPoints": true,
"legend": {
"descOrder": false,
"showHeader": true,
"show": false,
"customSize": "auto",
"position": "right-top",
"inside": false
},
"axisMode": "sync",
"tooltip": {
"content": {
"legend": {
"showBinLabel": true,
"measures": [],
"showNullValues": true,
"customizeLegend": false,
"showPercentage": true,
"showDimensions": true,
"showMeasures": true,
"dimensions": []
}
}
},
"visualizationType": "time",
"missingValue": "connect",
"dashLine": {
"measures": "",
"showDashLine": false
},
"exploreLink": false,
"timeAxis": {
"showTitle": false,
"predictiveLine": {
"color": "#9271E8",
"label": "TODAY"
},
"showAxis": true,
"title": ""
},
"title": {
"fontSize": 14,
"subtitleFontSize": 11,
"label": "",
"align": "center",
"subtitleLabel": ""
},
"trellis": {
"flipLabels": false,
"showGridLines": true,
"size": [
100,
100
],
"enable": false,
"type": "x",
"parameters": {},
"chartsPerLine": 4
},
"totalLabel": "",
"fillArea": true,
"showActionMenu": true,
"showZero": true,
"measureAxis2": {
"sqrtScale": false,
"showTitle": true,
"showAxis": true,
"title": "",
"customDomain": {
"showDomain": false
}
},
"measureAxis1": {
"sqrtScale": false,
"showTitle": false,
"showAxis": true,
"referenceLines": [
{
"color": "#2EC2BA",
"label": {
"data": "Quota - $ {{coalesce(cell(kpi_quota.result, 0, \"sum_quota\"),0).asObject()}}",
"type": "static"
},
"value": {
"data": "{{coalesce(cell(kpi_quota.result, 0, \"sum_quota\"), 0).asObject()}}",
"type": "static"
}
}
],
"title": "",
"customDomain": {
"showDomain": false
}
},
"valueType": "none",
"step": "time_chart_forecast_NEW",
"theme": "dark",
"applyConditionalFormatting": false,
"drawArea": {
"measure": "",
"showDrawArea": false,
"bounding1": "",
"bounding2": ""
}
},
"type": "chart"
}