Ciro

Adds tiles to a saved dashboard this person can change (list_dashboards says which). Tiles work as in create_dashboard. They show first on the dashboard, or last once someone has arranged its layout. Returns the dashboard's tiles afterwards.

add_dashboard_tiles

Lists the values of a dimension, e.g. the organization's chains (retail_group_name), brands, categories, or the products and stores matching a search. Use it to get the exact spelling before filtering query_data with equals.

list_dimension_values

Lists every measure (metric) and dimension (breakdown) query_data accepts, grouped like Ciro's explorer, with labels, units and definitions, plus the organization's currency and today's date. Call it first when you don't know the exact field for a question.

get_data_catalog

Computes measures over the organization's sell-out (sales), stock and replenishment data, optionally broken down by dimensions and time. Returns a table with the exact date range covered. Examples: sales by chain last month → measures [total_net_sales, total_units_sold], dimensions [retail_group_name], date_range "last month". Monthly trend → time_granularity "month". Top 10 products → dimensions [product_name], order by the measure desc, limit 10. Stockouts → measures [stores_with_stockout, coverage_stockout] by product_name. Purchase suggestion → measures [suggested_units, suggested_money, current_doh] by retail_group_name or store_name. Stock measures always show the latest known stock, whatever the date range. Percentages come in points (12.5 = 12.5%).

query_data

Saves a new dashboard in Ciro with the given tiles (KPIs, charts and tables), e.g. to keep a report built with query_data: repeat each query's measures, dimensions, filters and date range, with a chart that fits it. It is personal (only this person sees it, under 'Mi espacio') unless shared is true, which puts it in the organization's dashboards for everyone. Only the organization's owners and admins can share. Tiles run on live data every time the dashboard opens and show every row their breakdown returns, so a title can't promise a top N: chart breakdowns with few values (chain, banner, brand, category, month) and use a sorted table for products or stores. Returns the dashboard's id, its link in Ciro and its tiles.

create_dashboard

Shows, per chain (Cadena), the last day with sales, the last stock report and the state and last successful sync of each of its integrations. Use it for 'is my data up to date?' questions or to explain gaps before analyzing recent days.

get_data_status

Runs every tile of a saved dashboard and returns each tile's data, the same numbers the person sees in Ciro. Pass date_range to read it over other days than the ones it was saved with.

run_dashboard

Lists the saved dashboards this person can see in Ciro (shared with the organization or personal), whether they can change each one, and each one's tiles with their ids. Use run_dashboard to read one.

list_dashboards

Removes tiles from a saved dashboard this person can change, by the tile ids list_dashboards shows. They're deleted for everyone who sees the dashboard and can't be restored. Returns the tiles left.

remove_dashboard_tiles