{ "dataSourceParameter": { "connectionString": "Server=PlaceholderSqlServer,1433;Initial Catalog=PlaceholderDatabase;User ID=PlaceholderUserName;Password=PlaceholderPassword;", "query": "select * from your_table where timestamp = @StartTime" }, "dataFeedName": "Sample - cost/revenue - city/category", "dataFeedDescription": "This is a sample data feed.", "granularityName": "Daily", "metrics": [ { "metricName": "cost", "metricDisplayName": "cost" }, { "metricName": "revenue", "metricDisplayName": "revenue" } ], "dimension": [ { "dimensionName": "category", "dimensionDisplayName": "category" }, { "dimensionName": "city", "dimensionDisplayName": "city" } ], "timestampColumn": "timestamp", "dataStartFrom": "2020-01-01T00:00:00Z", "dataSourceType": "SqlServer", "startOffsetInSeconds": 86400, "maxConcurrency": 5, "minRetryIntervalInSeconds": 3600, "stopRetryAfterInSeconds": 604800, "needRollup": "NeedRollup", "rollUpMethod": "Sum", "allUpIdentification": "__SUM__", "fillMissingPointType": "SmartFilling", "viewMode": "Private", "authenticationType": "Basic" }
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter