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"}