create_chart_report

1.Use Cases: - Create a chart report in the specified workspace for a table in Zoho Analytics. - Use this to generate visual representations of data using bar, line, pie, scatter, or bubble charts. 2.Important Notes: - A chart is a report that visually represents data from a table or multiple tables. - If y-axis operation is "actual", only "scatter" chart is allowed. For all other chart types, use "sum" for numeric columns and "count" for string columns in y-axis. - Charts can include filters to narrow down the dataset. - A chart can be created over columns from the same table or from other tables with which a relationship is defined. - For x-axis operations for numeric columns, use "measure" or "dimension" instead of "actual", depending upon the type of the numeric column. 3.Arguments: - workspace_id (str): ID of the workspace to create the chart in. - table_name (str): The base table name for the chart. - chart_name (str): Desired name for the chart report. - chart_details (dict): Details of the chart including: - chartType (str): One of ["bar", "line", "pie", "scatter", "bubble"] - x_axis (dict): - columnName (str) - operation (str): For string:- actual, count, distinctCount For number:- sum, average, min, max, measure, dimension, count, distinctCount For dates:- year, month, week, fullDate, dateTime, range, count, distinctCount - tableName (optional [str]): If the column belongs to another table with which a relationship is defined with base table, provide the tableName. - y_axis (dict): Same structure as x_axis - filters (list[dict] | None): Optional. Filter definitions per <filters_args>. - org_id (str | None): The ID of the organization to which the workspace belongs to. If not provided, it defaults to the organization ID from the configuration. 3.1.Filter Arguments: - tableName (str): The name of the table containing the column to filter. - columnName (str): The name of the column to filter. - operation (str): Specifies the function applied to the specified column used in the filter. The accepted functions differ based on the data type of the column. Date: year, quarterYear, monthYear, weekYear, fullDate, dateTime, range, quarter, month, week, weekDay, day, hour, count, distinctCount String: actual, count, distinctCount Number: measure, dimension, sum, average, min, max, count, distinctCount - filterType (str): The type of filter to apply. Accepted values: individualValues, range, ranking, rankingPct, dateRange, year, quarterYear, monthYear, weekYear, quarter, month, week, weekDay, day, hour, dateTime - values (list): The values to filter on. Example: - For individualValues: "value1", "value2" - For range: "10 to 20", "50 and above" - For ranking: "top 10", "bottom 5" - exclude (bool): Whether to exclude or include the filtered values. Default is False. 4.Returns: - str: Chart creation status or error message. It is categorised as a Write tool in the Zoho Analytics MCP Server, which means it can create or modify data. Consider rate limits to prevent runaway writes.

create_chart_report accepts 6 parameters: orgId, filters, chart_name, table_name, workspace_id, chart_details. Required: chart_name, table_name, workspace_id, chart_details. The full parameter table on this page comes from the server's own tool schema.

Register the Zoho Analytics MCP server in PolicyLayer and add a rule for create_chart_report: allow, deny, rate-limit, or require approval. Point your MCP client at the PolicyLayer proxy URL and the rule is enforced on every call, before it reaches Zoho Analytics. Nothing to install.

create_chart_report is a Write tool with medium risk. Write tools should be rate-limited to prevent accidental bulk modifications.

Yes. Add a rate_limit block to the create_chart_report rule in your PolicyLayer policy. For example, setting max: 10 and window: 60 limits the tool to 10 calls per minute. Rate limits are tracked per agent session and reset automatically.

Set action: deny in the PolicyLayer policy for create_chart_report. The AI agent will receive a policy violation error and cannot call the tool. You can also include a reason field to explain why the tool is blocked.

create_chart_report is provided by the Zoho Analytics MCP server (zoho-analytics-mcp-server). PolicyLayer sits as a proxy in front of this server to enforce policies before tool calls reach the server.