Quick StartThe ReportMagic MenuSchedulesBatch JobsReport StudioFilesProfileAdminAccount DetailsGetting StartedAbout ReportMagicRegistering and Logging InReport LibrarySearching ReportMagicConnections and AgentsWriting ReportsStarting Out With Report StudioCreating Report TemplatesRMScriptMacro ShorthandReporting on Different Periods of TimeSetting Macro Parameter DefaultsStoring Input and Output FilesReport VariablesUsing Variable ParametersSpecifying How Graphs LookStep-by-Step LogicMonitor Graph ExamplesStep-by-Step Jira Graph ExamplesSpecifying How Tables LookChanging Fonts and ColorsUsing Macros in PowerPoint TemplatesRestricted MacrosGenerating Reports Using SchedulesUsing HTML Forms in SchedulesSeeing How Reports RanViewing ReportsCached ValuesUsing AggregationsAdvanced Report StudioAdvanced [Object.Graph:] MacroAPI AccessREST APIREST API - FilesAdvancedRole-Based Access Control (RBAC)SecurityMiscellaneousBadgesCertificationsTips, Tricks and Shortcut KeysMacrosAgentAgent.ConnectionAgent.ExecuteAgent.MonitorMagicNodeListAgent.MonitorMagicNodeMeasurementListAgent.MonitorMagicNodeMeasurementSummaryAgent.MonitorMagicNodePropertyListAgent.MonitorMagicNodeTypeListAgent.PropertyAgent.SqlAnalysisAgent.SqlGraphAgent.SqlListAgent.SqlTableAgent.SqlValueAgent.SqlValuesAgent.WebQueryAlertMagicAlertMagic.MetricsGraphAlertMagic.MetricsListAlertMagic.StatisticsAutoTaskAutoTask.AccountListAutoTask.AccountPropertyAutoTask.ConnectionAutoTask.CountAutoTask.FieldListAutoTask.FieldPropertyAutoTask.ListAutoTask.PropertyAutoTask.SummaryValueAutoTask.TicketListAutoTask.TicketPropertyAzureAzure.ConnectionAzure.LogAnalyticsGraphAzure.LogAnalyticsQueryAzure.LogAnalyticsScalarAzure.LogAnalyticsTableAzure.ResourceGroupListAzure.ResourceListAzure.ResourcePropertiesAzure.SentinelAlertRuleListAzure.SentinelConnectorListAzure.SentinelIncidentListAzure.SentinelThreatIndicatorListAzure.SentinelThreatIndicatorMetricListAzure.SubscriptionListBloggerBlogger.BlogPropertyBlogger.ConnectionBlogger.PageBlogger.PageListBlogger.PagePropertyBlogger.PostBlogger.PostListBlogger.PostPropertyCacheCache.ExpiresCache.GetCache.IsSetCache.SetCache.UnsetCertifyCertify.ConnectionCertify.DepartmentListCertify.DepartmentPropertyCherwellCherwell.BusinessObjectDefinitionListCherwell.BusinessObjectListCherwell.BusinessObjectSchemaCherwell.BusinessObjectSummaryCherwell.ConnectionCiscoCisco.ConnectionCisco.FirmwareVersionPropertyCisco.SecurityAdvisoryListCisco.SerialNumberPropertyCisco.SoftwareSuggestionListCiscoDnaCenterCiscoDnaCenter.ConnectionCiscoDnaCenter.SiteListCiscoDnaCenter.SitePropertyCloudHealthCloudHealth.AssetDetailsCloudHealth.AssetListCloudHealth.AvailableReportDimensionsCloudHealth.AvailableReportOptionsCloudHealth.AvailableReportsListCloudHealth.AwsAccountDetailsCloudHealth.AwsAccountsListCloudHealth.ConnectionCloudHealth.CustomerDetailsCloudHealth.CustomerListCloudHealth.CustomerReportDetailsCloudHealth.CustomerStatementDetailsCloudHealth.OrganisationAccountsListCloudHealth.OrganisationListCloudHealth.QueryCodacyCodacy.ConnectionCodacy.ListConnectWiseManageConnectWiseManage.ConnectionConnectWiseManage.CountConnectWiseManage.DictionaryConnectWiseManage.ListConnectWiseManage.PropertyCoreArrayArray.CountBreakBreakpointCalculateColorCommentContinueConvertDeleteDeleteRowDocumentBookmarkDocumentBreakDocumentInsertSectionDocumentSectionEmailEmailFileEmailReportExecuteForEachFormatTableCellFormatTableRowIfIgnoreIncInsertTableCellImageIsSetLinearRegressionLinkMapObjectRandomRegexRepeatRowSearchAndReplaceSectionSettingsSleepStopStopwatchStringStringIndexSubstringSwitchThrowExceptionUnsetWarningDatabaseDatabase.ConnectionDatabase.GraphDatabase.ListDatabase.TableDatabase.ValueDatabase.ValuesDataMagicDataMagic.SyncDictionaryDictionary.ItemDictionary.KeysDictionary.ValuesDocumentDocument.SetPropertiesDropBoxSignDropBoxSign.ConnectionFileFile.CopyFile.CopyOutputFilesFile.Csv.CellFile.Csv.RowFile.Csv.RowCountFile.Csv.TableFile.EmbedFile.ExecuteFile.ExistsFile.ImageFile.InsertFile.ListFile.LoadListFile.LoadObjectFile.LoadStringFile.LoadVariablesFile.SaveObjectFile.Xlsx.CellFile.Xlsx.RowFile.Xlsx.RowCountFile.Xlsx.TableFunctionFunction.CallFunction.DefineGoogleGoogle.ConnectionGoogle.TableGraphGraph.AddDataGraph.DeleteDataGraph.RenameDataGraph.UpdateGravatarGravatar.ImageHaloPsaHaloPsa.ConnectionHaloPsa.ListHighlightHighlight.BearerSummaryHighlight.BroadbandSummaryHighlight.CellularSummaryHighlight.ConnectionHighlight.FolderListHighlight.HttpServerPerformanceSummaryHighlight.IcmpTcpUdpPerformanceSummaryHighlight.MosPerformanceSummaryHighlight.PrecisionPerformanceSummaryHighlight.TunnelSummaryHighlight.WatchNodeListHighlight.WirelessAccessPointSummaryHubSpotHubSpot.ListHubSpot.PropertyHubSpot.QueryJarrayJarray.TableJiraJira.AttachmentImageJira.AttachmentListJira.AttachmentPropertyJira.ConnectionJira.GraphJira.InsertMarkupJira.IssueAnalysisJira.IssueCommentListJira.IssueCommentPropertyJira.IssueLastCommentPropertyJira.IssueListJira.IssuePropertyJira.IssueResponseTimeJira.LastImageJira.StatusListJira.TableJira.TimeInStateJira.UserListJira.UserPropertyJsonJson.ItemJson.ListKrokiKroki.ImageListList.AddList.AnalysisList.ComplementList.CountList.DequeueList.DuplicatesList.FirstList.GraphList.GroupByList.IndicesOfList.IntersectionList.ItemList.RangeList.SelectList.SelectColumnsList.SortList.SummaryValueList.TableList.UnionList.WhereLogicMonitorLogicMonitor.AccountPropertyLogicMonitor.AlertAnalysisLogicMonitor.AlertCalendarLogicMonitor.AlertCountLogicMonitor.AlertListLogicMonitor.AlertMapLogicMonitor.AlertPropertyLogicMonitor.AlertRuleListLogicMonitor.AlertRulePropertyLogicMonitor.AlertStatusLogicMonitor.AlertTableLogicMonitor.AppliesToFunctionListLogicMonitor.AppliesToFunctionPropertyLogicMonitor.AppliesToListLogicMonitor.AuditEventAnalysisLogicMonitor.BigNumberWidgetValuesLogicMonitor.ClearCacheLogicMonitor.CollectorExecuteLogicMonitor.CollectorGroupListLogicMonitor.CollectorGroupPropertyLogicMonitor.CollectorListLogicMonitor.CollectorPropertyLogicMonitor.CollectorVersionListLogicMonitor.CollectorVersionPropertyLogicMonitor.ConfigCheckListLogicMonitor.ConfigCheckPropertyLogicMonitor.ConfigSourceGroupListLogicMonitor.ConfigSourceListLogicMonitor.ConfigSourcePropertyLogicMonitor.ConfigSourceXmlLogicMonitor.ConnectionLogicMonitor.ConnectionApiTokenLogicMonitor.ConvertToLiveWidgetLogicMonitor.DashboardLogicMonitor.DashboardGroupListLogicMonitor.DashboardGroupPropertyLogicMonitor.DashboardListLogicMonitor.DashboardPropertyLogicMonitor.DashboardWidgetListLogicMonitor.DatamartSyncLogicMonitor.DataPointListLogicMonitor.DataPointPropertyLogicMonitor.DataSourceGraphListLogicMonitor.DataSourceGraphPropertyLogicMonitor.DataSourceGroupListLogicMonitor.DataSourceListLogicMonitor.DataSourcePropertyLogicMonitor.DataSourceXmlLogicMonitor.DeviceConfigSourceFileLogicMonitor.DeviceConfigSourceInstanceListLogicMonitor.DeviceConfigSourceListLogicMonitor.DeviceConfigSourcePropertyLogicMonitor.DeviceCountLogicMonitor.DeviceDataSourceListLogicMonitor.DeviceDataSourcePropertyLogicMonitor.DeviceGroupListLogicMonitor.DeviceGroupPropertyLogicMonitor.DeviceListLogicMonitor.DevicePropertyLogicMonitor.DeviceSlaWidgetPropertyLogicMonitor.DeviceTableLogicMonitor.EscalationChainDestinationListLogicMonitor.EscalationChainDestinationPropertyLogicMonitor.EscalationChainListLogicMonitor.EscalationChainPropertyLogicMonitor.EventSourceFilterListLogicMonitor.EventSourceFilterPropertyLogicMonitor.EventSourceGroupListLogicMonitor.EventSourceListLogicMonitor.EventSourcePropertyLogicMonitor.EventSourceXmlLogicMonitor.FinancialInformationLogicMonitor.ForecastLogicMonitor.GraphLogicMonitor.GraphSpecificationLogicMonitor.HistoricSdtListLogicMonitor.ImageLogicMonitor.InstanceAnalysisLogicMonitor.InstanceCountLogicMonitor.InstanceDetailsTableLogicMonitor.InstanceGroupCountLogicMonitor.InstanceGroupListLogicMonitor.InstanceListLogicMonitor.InstancePropertyLogicMonitor.IntegrationListLogicMonitor.IntegrationPropertyLogicMonitor.JobMonitorListLogicMonitor.JobMonitorPropertyLogicMonitor.LastMeasurementLogicMonitor.LogAnalysisLogicMonitor.LogicModuleMetadataPropertyLogicMonitor.LogicModuleUpdateListLogicMonitor.LogicModuleUpdatePropertyLogicMonitor.LogItemListLogicMonitor.NetscanGroupListLogicMonitor.NetscanGroupPropertyLogicMonitor.NetscanListLogicMonitor.NetscanPropertyLogicMonitor.NewUserMessagePropertyLogicMonitor.PaymentInformationLogicMonitor.PercentageAvailabilityLogicMonitor.PortalVersionLogicMonitor.PropertySourceGroupListLogicMonitor.PropertySourceJsonLogicMonitor.PropertySourceListLogicMonitor.PropertySourcePropertyLogicMonitor.QueryLogicMonitor.RecipientGroupListLogicMonitor.RecipientGroupPropertyLogicMonitor.RecycleBinItemListLogicMonitor.RecycleBinItemPropertyLogicMonitor.ReportGroupListLogicMonitor.ReportGroupPropertyLogicMonitor.ReportListLogicMonitor.ReportPropertyLogicMonitor.ResourceAnalysisLogicMonitor.ResourceGroupAnalysisLogicMonitor.RoleListLogicMonitor.RolePropertyLogicMonitor.SdtListLogicMonitor.SdtPercentageLogicMonitor.SdtPropertyLogicMonitor.SingleSignOnPropertyLogicMonitor.SlaWidgetValuesLogicMonitor.SnmpSysOidMapListLogicMonitor.SnmpSysOidMapPropertyLogicMonitor.SummaryValueLogicMonitor.SummaryValueListLogicMonitor.ThresholdLogicMonitor.TrafficTableLogicMonitor.UnmonitoredDeviceListLogicMonitor.UnmonitoredDevicePropertyLogicMonitor.UserApiTokenListLogicMonitor.UserApiTokenPropertyLogicMonitor.UserListLogicMonitor.UserPropertyLogicMonitor.WebsiteCheckpointDataListLogicMonitor.WebsiteCountLogicMonitor.WebsiteGroupAnalysisLogicMonitor.WebsiteGroupCountLogicMonitor.WebsiteGroupListLogicMonitor.WebsiteGroupPropertyLogicMonitor.WebsiteListLogicMonitor.WebsitePropertyLogicMonitor.WidgetStatusMagicSuiteMagicSuite.ConnectionListMagicSuite.SubscriptionListMerakiMeraki.CameraImageMeraki.ConfigurationChangeListMeraki.ConnectionMeraki.DevicePropertyMeraki.DeviceUplinkPropertyMeraki.EndOfLifeMeraki.NetworkClientListMeraki.NetworkDeviceListMeraki.NetworkEventListMeraki.NetworkListMeraki.NetworkPropertyMeraki.NetworkSwitchPortsListMeraki.NetworkSwitchStackListMeraki.OrganizationDeviceLicenseListMeraki.OrganizationDeviceLicensePropertyMeraki.OrganizationDeviceListMeraki.OrganizationDeviceListStatusPropertyMeraki.OrganizationInventoryListMeraki.OrganizationLicenseStatePropertyMeraki.OrganizationListMeraki.OrganizationPropertyMeraki.OrganizationUplinkUsageMeraki.WirelessNetworkClientConnectionStatsPropertyMeraki.WirelessNetworkClientLatencyListMeraki.WirelessNetworkClientsConnectionStatsListMeraki.WirelessNetworkClientsLatencyListMeraki.WirelessNetworkConnectionStatsPropertyMeraki.WirelessNetworkDeviceConnectionStatsPropertyMeraki.WirelessNetworkDeviceLatencyListMeraki.WirelessNetworkDevicesConnectionStatsListMeraki.WirelessNetworkDevicesLatencyListMeraki.WirelessNetworkLatencyListMicrosoftDataverseMicrosoftDataverse.ConnectionMicrosoftDataverse.CountMicrosoftDataverse.EntityDefinitionsListMicrosoftDataverse.EntityListMicrosoftDataverse.EntityPropertyListMicrosoftDataverse.ListMicrosoftDataverse.PropertyMicrosoftGraphMicrosoftGraph.ConnectionMicrosoftGraph.QueryObjectObject.ArrayCountObject.GraphObject.PropertyObject.TypeObject.UnpackObject.UnpackVariablesOpenAiOpenAi.AnswerOpenAi.CompleteOpenAi.ConnectionOpenAi.ImageQuickBooksQuickBooks.ConnectionQuickBooks.PropertyReportMagicReportMagic.ApplyBrandReportMagic.BadgeListReportMagic.ConnectionPropertyReportMagic.ConnectionStatusPropertyReportMagic.FeedbackListReportMagic.FeedbackPropertyReportMagic.MacroGroupListReportMagic.MacroHelpReportMagic.MacroListReportMagic.ReportBatchJobCountReportMagic.ReportBatchJobListReportMagic.ReportBatchJobPropertyReportMagic.ReportConnectionSummaryReportMagic.ReportJobCountReportMagic.ReportJobListReportMagic.ReportJobPropertyReportMagic.ReportMacroCountReportMagic.ReportPropertyReportMagic.ReportScheduleCountReportMagic.ReportScheduleListReportMagic.ReportSchedulePropertyReportMagic.SetReportPropertyReportMagic.SystemPropertyReportMagic.TenantImageReportMagic.TopicHelpReportMagic.VersionSalesforceSalesforce.ConnectionSalesforce.ListSalesforce.PropertyServiceNowServiceNow.ConnectionServiceNow.CountServiceNow.CreateServiceNow.DeleteServiceNow.DictionaryServiceNow.ListServiceNow.PropertyServiceNow.UpdateShapeShape.AddShape.CloneShape.DeleteShape.FormatShape.HideShape.SetPropertyShape.SetTextSideroLabsOmniSideroLabsOmni.ConnectionSideroLabsOmni.ListSideroLabsOmni.ObjectSlackSlack.ConnectionSlack.MessageSlideSlide.DeleteSlide.DeleteSectionSlide.LinkSlide.MoveToSlide.RepeatSmtpSmtp.ConnectionSnmpSnmp.EnterprisePropertySolarWindsSolarWinds.ConnectionSolarWinds.SqlListSolarWinds.SqlTableSqlSql.AnalysisTableTable.ColumnCountTable.DeleteTable.FormatTable.GraphTable.MergeCellsTable.RowCountTable.SaveTable.SortTable.WorldMapTimeCalendarCronHumanReadableCronRunDateDateRangeDateTimeDateTime.IsInWorkHoursDateTime.WorkHoursDurationTimeSpanTogglToggl.ClientListToggl.ClientPropertyToggl.ConnectionToggl.ProjectListToggl.ProjectPropertyToggl.ProjectReportPropertyToggl.TimeEntryListToggl.TimeEntryPropertyToggl.UserListToggl.UserPropertyToggl.WorkspaceListToggl.WorkspacePropertyTwilioTwilio.ConnectionTwilio.SmsUkParliamentUkParliament.PetitionCountUkParliament.PetitionListUkParliament.PetitionPropertyVariableVariable.ImageVariable.ListVariable.PropertyWebWeb.ConnectionWeb.HtmlWeb.ImageWeb.QueryWeb.ScreenshotWeb.TableWeb.TextXlsxXlsx.AddAnalysisXlsx.EmbedZendeskZendesk.ConnectionZendesk.ListZendesk.PropertyZoho.DeskZoho.Desk.ZohoListZoho.Desk.ZohoProperty
[Object.Graph:]
Outputs a graph, defined by a graph specification JObject.
Macro Compatibility
The macro can be used in all input document types and in Report Studio.
Usage
The graph specification is detailed here.
| Parameter | Type | Presence | Purpose | Options | Default |
|---|---|---|---|---|---|
| JObject | Mandatory | The input graph specification as a JObject. This can be passed in via a previously-stored variable, or as raw JSON text. The specification could be generated by another macro, such as [LogicMonitor.GraphSpecification:]. For a complete description of the required JObject's structure and options, refer to the detailed help page here. | N/A | N/A | |
| Double | Conditional | The image height in centimetres. If set, then 'imageWidthCm' must also be. | N/A | N/A | |
| Int32 | Conditional | The image height in pixels. If set, then 'imageWidthPx' must also be. | N/A | N/A | |
| Double | Conditional | The image width in centimetres. If set, then 'imageHeightCm' must also be. | N/A | N/A | |
| Int32 | Conditional | The image width in pixels. If set, then 'imageHeightPx' must also be. | N/A | N/A | |
| Double | Optional | The number of pixels to clip from the bottom. | N/A | N/A | |
| Double | Optional | The number of pixels to clip from the left. | N/A | N/A | |
| Double | Optional | The number of pixels to clip from the right. | N/A | N/A | |
| Double | Optional | The number of pixels to clip from the top. | N/A | N/A | |
| String | Optional | Add a comment to make your document template more readable. The comment is discarded in the output document. | N/A | N/A | |
| String | Optional | The description for visually-impaired users. This text also displays when the user hovers the mouse over the image in Word or a PDF viewer. | N/A | N/A | |
| Boolean | Optional | Should NCalc expression evaluation throw error on Overflow |
|
true | |
| String | Optional | The text to display should the macro fail to execute. Note that a poorly-specified macro (e.g. omitting mandatory parameters) will still result in an error message. | N/A | N/A | |
| String | Optional | The name of a variable to create should the macro fail to execute. The variable will be a text variable, and will contain either the failure text (only if the failureText parameter is set), otherwise it will contain the exception / failure message. | N/A | N/A | |
| PowerPointImageHorizontalAlign | Optional | For PowerPoint only, the ability to horizontally align images produced by macros, with vertical lines. |
|
N/A | |
| HorizontalPositionAlignment | Optional | The horizontal position alignment. |
|
Left | |
| HorizontalPositionRelativeTo | Optional | What the horizontal position is relative to. |
|
Inline | |
| String | Optional | The condition that must be true in order for the macro to be executed/evaluated. Must either evaluate to true or false, for example: "3+5=8" or "contains('abcd', 'z'). | N/A | true | |
| MacroMode | Optional | The mode in which variables are stored. In the legacy mode (default for Schedules), the variable created is a string and formatted. In the normal mode (default for Report Studio), the output variable is stored as a strongly-typed object, e.g. an Int32 or a List |
|
Legacy | |
| ObfuscationType | Optional | Obfuscation type. Use obfuscation to write reports where sensitive data is hidden. When used, ReportMagic guarantees that the same input string will map to the same output string for the whole of the report (but the next time the report runs, it will most likely map to a different value). If you use obfuscation, the property in your macro will not show up and instead, you will see a fake item of the obfuscation type chosen. |
|
None | |
| Double | Optional | The image opacity (0 is transparent, 100 is solid). |
|
100 | |
| Double | Optional | The page height percentage. |
|
N/A | |
| Double | Optional | The page width percentage. This overrides the pixel and centimetre width and height parameters. |
|
N/A | |
| String | Optional | The image title for visually-impaired users. | N/A | N/A | |
| Int32 | Optional | The title heading level. Don't specify if no heading is required. | N/A | N/A | |
| PowerPointImageVerticalAlign | Optional | For PowerPoint only, the ability to vertically align images produced by macros, with horizontal lines. |
|
N/A | |
| VerticalPositionAlignment | Optional | The Vertical position alignment. |
|
Top | |
| VerticalPositionRelativeTo | Optional | What the vertical position is relative to. |
|
Inline | |
| String | Optional | If specified, adds a warning message for this macro. This is processed as an NCalc, and the warning message will ALWAYS be present and will be the value of the evaluated NCalc expression. | N/A | N/A | |
| Wrapping | Optional | Image wrapping. |
|
Inline |
Examples (3)
Example 1:
This example produces the graph specification by first using the [LogicMonitor.GraphSpecification:] macro, for Devices that exist in the LogicMonitor portal:
[ForEach: storeAs=orderby_forDeviceListmacro, values=Id;Link;NetflowCollectorId;PreferredCollectorId;CollectorDescription;EnableNetflow;AlertStatus;Status;CurrentCollectorId;EffectiveAlertEnabled;SdtStatus;DeviceStatus]
~~~ [String: value={orderby_forDeviceListmacro}] ~~~
[LogicMonitor.DeviceList: deviceGroups=/, recurseDeviceGroups=true, =>Devices, orderBy={orderby_forDeviceListmacro}][Json.List: jArray=`{Devices}`, jsonPath="$.[*].DisplayName", =>DeviceDisplayName] [ForEach: storeAs=displayname, values={DeviceDisplayName}, take=10]
*** [String:value={displayname} ***] : [LogicMonitor.GraphSpecification: device={displayname}, graphName=CPU Usage, dataSourceInstanceName=WinCPU, =>GraphSpecification, failureText="No graph of this name on this device, please try again"]
[Object.Graph: graphSpec={=GraphSpecification}, pageWidthPercent=100, failureText="No graph"] [Unset: variable=GraphSpecification]
[EndForEach:][EndForEach:]Example 2:
This example defines a graph specification that has 1 series, and stores it into a variable using the [String:] macro, before passing it to the [Object.Graph:] macro:
// Using a String macro, define the JSON and store it in a variable (you could just pass this directly into the Object.Graph macro instead)
[String: value=`{
"SeriesList":
[
{
"ChartType": "Area",
"Name": "Busy",
"BorderWidth": 2,
"IsXValueIndexed": false,
"XValueType": "DateTime",
"Color": "Green",
"Points": [
{
"XValue": 45808.708333333336,
"YValue": 18.0052,
},
{
"XValue": 45808.75,
"YValue": 18.5592,
},
{
"XValue": 45808.791666666664,
"YValue": 19.2466,
},
{
"XValue": 45808.833333333336,
"YValue": 19.1072,
},
{
"XValue": 45808.875,
"YValue": 18.795,
},
{
"XValue": 45808.916666666664,
"YValue": 18.0939,
},
{
"XValue": 45808.958333333336,
"YValue": 12.307,
},
{
"XValue": 45809.0,
"YValue": 57.9964,
},
{
"XValue": 45809.041666666664,
"YValue": 33.856,
},
{
"XValue": 45809.083333333336,
"YValue": 19.3426,
},
{
"XValue": 45809.125,
"YValue": 19.8072,
},
{
"XValue": 45809.166666666664,
"YValue": 19.5215,
},
{
"XValue": 45809.208333333336,
"YValue": 20.9294,
},
{
"XValue": 45809.25,
"YValue": 25.3711,
},
{
"XValue": 45809.291666666664,
"YValue": 26.1338,
},
{
"XValue": 45809.333333333336,
"YValue": 25.4968,
},
{
"XValue": 45809.375,
"YValue": 30.628,
},
{
"XValue": 45809.416666666664,
"YValue": 30.4667,
},
{
"XValue": 45809.458333333336,
"YValue": 25.1796,
},
{
"XValue": 45809.5,
"YValue": 23.2416,
},
{
"XValue": 45809.541666666664,
"YValue": 25.356,
},
{
"XValue": 45809.583333333336,
"YValue": 24.4038,
},
{
"XValue": 45809.625,
"YValue": 26.0311,
},
{
"XValue": 45809.666666666664,
"YValue": 30.9392,
},
{
"XValue": 45809.708333333336,
"YValue": 27.4559,
},
{
"XValue": 45809.75,
"YValue": 28.651,
},
{
"XValue": 45809.791666666664,
"YValue": 27.1604,
},
{
"XValue": 45809.833333333336,
"YValue": 27.7907,
},
{
"XValue": 45809.875,
"YValue": 30.7597,
},
{
"XValue": 45809.916666666664,
"YValue": 26.594,
},
{
"XValue": 45809.958333333336,
"YValue": 13.9091,
},
{
"XValue": 45810.0,
"YValue": 56.049,
},
{
"XValue": 45810.041666666664,
"YValue": 40.7254,
},
{
"XValue": 45810.083333333336,
"YValue": 22.872,
},
{
"XValue": 45810.125,
"YValue": 23.4862,
},
{
"XValue": 45810.166666666664,
"YValue": 21.8159,
},
{
"XValue": 45810.208333333336,
"YValue": 25.0847,
},
{
"XValue": 45810.25,
"YValue": 30.7773,
},
{
"XValue": 45810.291666666664,
"YValue": 31.4038,
},
{
"XValue": 45810.333333333336,
"YValue": 23.5389,
},
{
"XValue": 45810.375,
"YValue": 25.3341,
},
{
"XValue": 45810.416666666664,
"YValue": 26.8848,
},
{
"XValue": 45810.458333333336,
"YValue": 24.8973,
},
{
"XValue": 45810.5,
"YValue": 26.6294,
},
{
"XValue": 45810.541666666664,
"YValue": 27.5703,
},
{
"XValue": 45810.583333333336,
"YValue": 27.7703,
},
{
"XValue": 45810.625,
"YValue": 26.4922,
},
{
"XValue": 45810.666666666664,
"YValue": 25.3085,
},
{
"XValue": 45810.708333333336,
"YValue": 25.8547,
},
{
"XValue": 45810.75,
"YValue": 26.8197,
},
{
"XValue": 45810.791666666664,
"YValue": 26.1777,
},
{
"XValue": 45810.833333333336,
"YValue": 27.4687,
},
{
"XValue": 45810.875,
"YValue": 26.7907,
},
{
"XValue": 45810.916666666664,
"YValue": 23.6409,
},
{
"XValue": 45810.958333333336,
"YValue": 12.4966,
},
{
"XValue": 45811.0,
"YValue": 55.5444,
},
{
"XValue": 45811.041666666664,
"YValue": 39.8914,
},
{
"XValue": 45811.083333333336,
"YValue": 20.472,
},
{
"XValue": 45811.125,
"YValue": 18.071,
},
{
"XValue": 45811.166666666664,
"YValue": 17.5793,
},
{
"XValue": 45811.208333333336,
"YValue": 19.3485,
},
{
"XValue": 45811.25,
"YValue": 25.0085,
},
{
"XValue": 45811.291666666664,
"YValue": 27.4835,
},
{
"XValue": 45811.333333333336,
"YValue": 35.4356,
},
{
"XValue": 45811.375,
"YValue": 37.4221,
},
{
"XValue": 45811.416666666664,
"YValue": 31.3936,
},
{
"XValue": 45811.458333333336,
"YValue": 34.2402,
},
{
"XValue": 45811.5,
"YValue": 38.2895,
},
{
"XValue": 45811.541666666664,
"YValue": 38.0499,
},
{
"XValue": 45811.583333333336,
"YValue": 45.6332,
},
{
"XValue": 45811.625,
"YValue": 46.0656,
},
{
"XValue": 45811.666666666664,
"YValue": 44.3677,
},
{
"XValue": 45811.708333333336,
"YValue": 44.1964,
},
{
"XValue": 45811.75,
"YValue": 48.4527,
},
{
"XValue": 45811.791666666664,
"YValue": 52.5395,
},
{
"XValue": 45811.833333333336,
"YValue": 54.1347,
},
{
"XValue": 45811.875,
"YValue": 53.6316,
},
{
"XValue": 45811.916666666664,
"YValue": 36.3512,
},
{
"XValue": 45811.958333333336,
"YValue": 13.0657,
},
{
"XValue": 45812.0,
"YValue": 50.8107,
},
{
"XValue": 45812.041666666664,
"YValue": 36.3529,
},
{
"XValue": 45812.083333333336,
"YValue": 20.5522,
},
{
"XValue": 45812.125,
"YValue": 19.9925,
},
{
"XValue": 45812.166666666664,
"YValue": 17.8333,
},
{
"XValue": 45812.208333333336,
"YValue": 18.7397,
},
{
"XValue": 45812.25,
"YValue": 23.3862,
},
{
"XValue": 45812.291666666664,
"YValue": 24.5123,
},
{
"XValue": 45812.333333333336,
"YValue": 20.0563,
},
{
"XValue": 45812.375,
"YValue": 20.2552,
},
{
"XValue": 45812.416666666664,
"YValue": 21.4263,
},
{
"XValue": 45812.458333333336,
"YValue": 21.5288,
},
{
"XValue": 45812.5,
"YValue": 21.7575,
},
{
"XValue": 45812.541666666664,
"YValue": 21.6045,
},
{
"XValue": 45812.583333333336,
"YValue": 21.3039,
},
{
"XValue": 45812.625,
"YValue": 20.4755,
},
{
"XValue": 45812.666666666664,
"YValue": 20.3037,
},
{
"XValue": 45812.708333333336,
"YValue": 20.7502,
},
{
"XValue": 45812.75,
"YValue": 20.4047,
},
{
"XValue": 45812.791666666664,
"YValue": 20.5791,
},
{
"XValue": 45812.833333333336,
"YValue": 20.185,
},
{
"XValue": 45812.875,
"YValue": 20.5066,
},
{
"XValue": 45812.916666666664,
"YValue": 19.3098,
},
{
"XValue": 45812.958333333336,
"YValue": 12.7459,
},
{
"XValue": 45813.0,
"YValue": 48.3422,
},
{
"XValue": 45813.041666666664,
"YValue": 39.2346,
},
{
"XValue": 45813.083333333336,
"YValue": 19.2272,
},
{
"XValue": 45813.125,
"YValue": 17.4751,
},
{
"XValue": 45813.166666666664,
"YValue": 16.8431,
},
{
"XValue": 45813.208333333336,
"YValue": 17.9681,
},
{
"XValue": 45813.25,
"YValue": 23.9562,
},
{
"XValue": 45813.291666666664,
"YValue": 23.9842,
},
{
"XValue": 45813.333333333336,
"YValue": 25.3692,
},
{
"XValue": 45813.375,
"YValue": 18.7601,
},
{
"XValue": 45813.416666666664,
"YValue": 19.1826,
},
{
"XValue": 45813.458333333336,
"YValue": 18.7201,
},
{
"XValue": 45813.5,
"YValue": 18.8435,
},
{
"XValue": 45813.541666666664,
"YValue": 18.8625,
},
{
"XValue": 45813.583333333336,
"YValue": 18.4243,
},
{
"XValue": 45813.625,
"YValue": 18.0317,
},
{
"XValue": 45813.666666666664,
"YValue": 18.3285,
},
{
"XValue": 45813.708333333336,
"YValue": 18.4915,
},
{
"XValue": 45813.75,
"YValue": 19.0993,
},
{
"XValue": 45813.791666666664,
"YValue": 18.8653,
},
{
"XValue": 45813.833333333336,
"YValue": 19.2347,
},
{
"XValue": 45813.875,
"YValue": 19.4036,
},
{
"XValue": 45813.916666666664,
"YValue": 18.4098,
},
{
"XValue": 45813.958333333336,
"YValue": 12.9869,
},
{
"XValue": 45814.0,
"YValue": 48.2514,
},
{
"XValue": 45814.041666666664,
"YValue": 39.9294,
},
{
"XValue": 45814.083333333336,
"YValue": 18.8441,
},
{
"XValue": 45814.125,
"YValue": 17.8083,
},
{
"XValue": 45814.166666666664,
"YValue": 18.257,
},
{
"XValue": 45814.208333333336,
"YValue": 18.2029,
},
{
"XValue": 45814.25,
"YValue": 24.7681,
},
{
"XValue": 45814.291666666664,
"YValue": 24.5643,
},
{
"XValue": 45814.333333333336,
"YValue": 21.231,
},
{
"XValue": 45814.375,
"YValue": 18.6771,
},
{
"XValue": 45814.416666666664,
"YValue": 19.6051,
},
{
"XValue": 45814.458333333336,
"YValue": 19.6595,
},
{
"XValue": 45814.5,
"YValue": 20.2179,
},
{
"XValue": 45814.541666666664,
"YValue": 21.1286,
},
{
"XValue": 45814.583333333336,
"YValue": 19.7281,
},
{
"XValue": 45814.625,
"YValue": 20.4982,
},
{
"XValue": 45814.666666666664,
"YValue": 20.6417,
},
{
"XValue": 45814.708333333336,
"YValue": 19.621,
},
{
"XValue": 45814.75,
"YValue": 19.7594,
},
{
"XValue": 45814.791666666664,
"YValue": 19.8813,
},
{
"XValue": 45814.833333333336,
"YValue": 19.5298,
},
{
"XValue": 45814.875,
"YValue": 19.4439,
}
],
"LabelText": "",
"LegendText": "",
}
],
"DoughnutRadius": 60,
"PieLabelStyle": "inside",
"PieLineColor": "LightGray",
"PieStartAngleDegrees": 0,
"PieCollectedColor": "LightGray",
"PieCollectedLabel": "Other",
"PieCollectedThresholdPercent": 5.0,
"Palette":
[
"Yes^#0d0",
"No^#d00",
"True^#0d0",
"False^#d00",
"OK^#0d0",
"Error^#d00",
"Unknown^#ddd"
],
"FixedLines" : [ { "Name" : "Line 1", "Color" : "Red", "Value" : 50 }, { "Name" : "Line 2", "Color" : "Green", "Value" : 100 } ],
"YAxisMinimum": 0.0,
"LegendWidthPercent": 20.0,
"LegendHeightPercent": 80,
"LegendXPosition": 80,
"LegendYPosition": 0,
"LegendFontSize": 20.0,
"ChartAreaXPosition": 0,
"ChartAreaYPosition": 0,
"ChartAreaWidthPercent": 80,
"ChartAreaHeightPercent": 100,
"InnerPlotXPosition": 10,
"InnerPlotYPosition": 10,
"InnerPlotWidthPercent": 85,
"InnerPlotHeightPercent": 75,
"XAxisIntervalAutoMode": "FixedCount",
"XAxisIntervalType": "Auto",
"XAxisIsAutoFit": true,
"XAxisLabelAutoFitStyle": "DecreaseFont",
"XAxisMajorGridEnabled": true,
"XAxisMinorGridEnabled": true,
"XAxisFontColor": "Black",
"XAxisFontSize": 20.0,
"XAxisLineDashStyle": "Solid",
"YAxisIntervalAutoMode": "FixedCount",
"YAxisIntervalType": "Auto",
"YAxisIsAutoFit": true,
"YAxisMajorGridEnabled": true,
"YAxisMinorGridEnabled": true,
"YAxisFontColor": "Black",
"YAxisFontSize": 20.0,
"YAxisLineDashStyle": "Solid",
"YAxisTitle": "%",
"UseYAxisShortLabels": true,
"YAxisShortLabelsAreData": false,
"ChartWidth": 2560,
"ChartHeight": 400,
"YAxisLabelAngle": 0,
"YAxisLabelAutoFitStyle": "DecreaseFont",
"XValueType": "DateTime",
"Enable3d": false,
"Inclination3dDegrees": 50,
"Rotation3dDegrees": 30,
"Perspective3dPercent": 0,
"PointDepth3dPercent": 100,
"PointGapDepth3dPercent": 100,
"LabelFontSize": 16.0,
"LegendStyle": "Column",
"ChartBorderLineColor": "Black",
"ChartBorderLineWidth": 0,
"ChartBorderLineDashStyle": "Solid",
"XAxisLabelFormat": "yyyy-MM-dd",
"XAxisIsLogarithmic": false,
"YAxisIsLogarithmic": false,
"EnsureColorsUnique": false,
"ImageFormat": 1,
"OrderAreaChartSeriesByMean": false,
"OverridePaletteType": "Default",
"LegendTextWrapThreshold": 25
}`, =>Spec]
// Pass the stored 'GraphSpec' variable into the Object.Graph: macro. This will render a graph in the document
[Object.Graph: graphSpec={=Spec}, pageWidthPercent=100]Example 3:
This example defines a graph specification that has 2 series, and passes it into the [Object.Graph:] macro directly:
[Object.Graph: graphSpec=`{
"SeriesList": [
{
"ChartType": "Area",
"Name": "Busy",
"BorderWidth": 2,
"IsXValueIndexed": false,
"XValueType": "DateTime",
"Color": "255, 154, 6",
"Points": [
{
"XValue": 45809.0,
"YValue": 57.9964,
"Color": ""
},
{
"XValue": 45809.041666666664,
"YValue": 33.856,
"Color": ""
},
{
"XValue": 45809.083333333336,
"YValue": 19.3426,
"Color": ""
},
{
"XValue": 45809.125,
"YValue": 19.8072,
"Color": ""
},
{
"XValue": 45809.166666666664,
"YValue": 19.5215,
"Color": ""
}
],
"LabelText": "",
"LegendText": "",
"PointWidth": null
},
{
"ChartType": "Line",
"Name": "CPUBusyPercent_Max",
"BorderWidth": 2,
"IsXValueIndexed": false,
"XValueType": "DateTime",
"Color": "255, 255, 0",
"Points": [
{
"XValue": 45809.0,
"YValue": 97.8711,
"Color": ""
},
{
"XValue": 45809.041666666664,
"YValue": 90.5924,
"Color": ""
},
{
"XValue": 45809.083333333336,
"YValue": 38.2813,
"Color": ""
},
{
"XValue": 45809.125,
"YValue": 40.8333,
"Color": ""
},
{
"XValue": 45809.166666666664,
"YValue": 30.8008,
"Color": ""
}
],
"LabelText": "",
"LegendText": "",
"PointWidth": null
},
{
"ChartType": "Line",
"Name": "CPUBusyPercent_Min",
"BorderWidth": 2,
"IsXValueIndexed": false,
"XValueType": "DateTime",
"Color": "49, 255, 71",
"Points": [
{
"XValue": 45809.0,
"YValue": 8.112,
"Color": ""
},
{
"XValue": 45809.041666666664,
"YValue": 10.3451,
"Color": ""
},
{
"XValue": 45809.083333333336,
"YValue": 10.2409,
"Color": ""
},
{
"XValue": 45809.125,
"YValue": 10.3451,
"Color": ""
},
{
"XValue": 45809.166666666664,
"YValue": 10.3385,
"Color": ""
}
],
"LabelText": "",
"LegendText": "",
"PointWidth": null
}
],
"DoughnutRadius": 60,
"PieLabelStyle": "inside",
"PieLineColor": "LightGray",
"PieStartAngleDegrees": 0,
"PieCollectedColor": "LightGray",
"PieCollectedLabel": "Other",
"PieCollectedThresholdPercent": 5.0,
"Palette": [
"Yes^#0d0",
"No^#d00",
"True^#0d0",
"False^#d00",
"OK^#0d0",
"Error^#d00",
"Unknown^#ddd"
],
"YAxisMinimum": 0.0,
"YAxisMaximum": null,
"FixedLines": [],
"LegendWidthPercent": 20.0,
"LegendHeightPercent": 80,
"LegendXPosition": 80,
"LegendYPosition": 0,
"MarkerBorderColors": [],
"MarkerColors": [],
"MarkerBorderWidths": [],
"MarkerSizes": [],
"MarkerStyles": [],
"ChartBackgroundColor": null,
"LegendFontSize": 20.0,
"LegendBorderColor": null,
"LegendBackgroundColor": null,
"ChartAreaXPosition": 0,
"ChartAreaYPosition": 0,
"ChartAreaWidthPercent": 80,
"ChartAreaHeightPercent": 100,
"InnerPlotXPosition": 10,
"InnerPlotYPosition": 10,
"InnerPlotWidthPercent": 85,
"InnerPlotHeightPercent": 75,
"ChartAreaBackgroundColor": null,
"XAxisIntervalAutoMode": "FixedCount",
"XAxisIntervalType": "Auto",
"XAxisIsMarginVisible": null,
"XAxisIsAutoFit": true,
"XAxisHeightPercent": null,
"XAxisLabelAngle": 0,
"XAxisLabelAutoFitStyle": "DecreaseFont",
"XAxisTitle": null,
"XAxisMajorGridEnabled": true,
"XAxisMajorGridIntervalType": null,
"XAxisMajorGridInterval": null,
"XAxisMinorGridEnabled": true,
"XAxisMinorGridIntervalType": null,
"XAxisMinorGridInterval": null,
"XAxisFontColor": "Black",
"XAxisFontSize": 20.0,
"XAxisLineWidth": null,
"XAxisLineColor": null,
"XAxisLineDashStyle": "Solid",
"YAxisIntervalAutoMode": "FixedCount",
"YAxisIntervalType": "Auto",
"YAxisInterval": null,
"YAxisIsAutoFit": true,
"YAxisWidthPercent": null,
"YAxisMajorGridEnabled": true,
"YAxisMajorGridIntervalType": null,
"YAxisMajorGridInterval": null,
"YAxisMinorGridEnabled": true,
"YAxisMinorGridIntervalType": null,
"YAxisMinorGridInterval": null,
"YAxisFontColor": "Black",
"YAxisFontSize": 20.0,
"YAxisLineWidth": null,
"YAxisLineColor": null,
"YAxisLineDashStyle": "Solid",
"YAxisTitle": "%",
"UseYAxisShortLabels": true,
"YAxisShortLabelsAreData": false,
"ChartWidth": 2560,
"ChartHeight": 400,
"Labels": null,
"YAxisLabelAngle": 0,
"YAxisLabelAutoFitStyle": "DecreaseFont",
"XValueType": "DateTime",
"Enable3d": false,
"Inclination3dDegrees": 50,
"Rotation3dDegrees": 30,
"Perspective3dPercent": 0,
"PointDepth3dPercent": 100,
"PointGapDepth3dPercent": 100,
"XAxisInterval": null,
"LabelFontSize": 16.0,
"LabelColor": null,
"LabelBackgroundColor": null,
"LegendStyle": "Column",
"ChartBorderLineColor": "Black",
"ChartBorderLineWidth": 0,
"ChartBorderLineDashStyle": "Solid",
"XAxisLabelFormat": "yyyy-MM-dd",
"YAxisLabelFormat": null,
"XAxisIsLogarithmic": false,
"YAxisIsLogarithmic": false,
"EnsureColorsUnique": false,
"ImageFormat": 1,
"OrderAreaChartSeriesByMean": false,
"OverridePaletteType": "Default",
"CustomPaletteHexCodes": "",
"LegendTextWrapThreshold": 25
}`, pageWidthPercent=100, failureText="No graph"]