You need to sign in to do that
Don't have an account?
dynamic reference line
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"
}
https://www.paybyplatema.one/