Manage Report

Reports → Custom Report Builder

The Custom Report Builder lets you answer ad-hoc questions without writing SQL. You pick the schema, time period, dimensions, metrics, and optional filters—Mavvrik builds the query, shows a chart on top and a data table below.

The Reports list

Navigating to Reports takes you to a list of existing reports before you build a new one. At the top, a users / default toggle switches between reports you and your team have created ("users") and Mavvrik's built-in default report templates ("default").

The list table's columns are: Name (links straight to that report), Description, Owner, Shared With, Created, and Action — which has five icons: Favorite, Clone, Share, Edit, and Delete.

1. Open and name your report

1. Go to Reports → New report.

2. Enter a Report name at the top (e.g., "EC2 Cost by Tag – Last 3 Months").

2. Choose what you want to analyze

In the Report tab — the only tab available until you've picked at least one Dimension and Metric (see step 3) — you'll also find an Include Chart checkbox, checked by default. Uncheck it if you only want the data table, with no chart generated for this report.

1. Schema – pick the data source:

   • Cloud Cost – billing/cost data

   • Cloud Resources – resource inventory

   • Datacenter Cost – on-prem / colo costs

   • Kubernetes Cost – cluster / namespace / workload costs

   • GenAI Cost – LLM/GenAI usage and spend

2. Period – choose:

   • Quick picks: Last 1 / 3 / 6 / 12 months

   • Or a Custom range

3. Pick dimensions & metrics

Still in the Report tab:

1. Dimensions – "how to group" the data (rows):

   • This is not a short curated list. For the Cloud Cost schema, Dimensions is the full raw billing-export field schema for the selected provider — hundreds of entries following the provider's own raw field names, e.g. for AWS: aws_bill_BillingEntity, aws_lineItem_UsageType, aws_pricing_RateCode, aws_product_accounts, and so on. It's the same kind of raw-schema field list used by Cost Explorer, not a small set of friendly names like "Account" or "Service".

   • You can pick more than one (e.g., two related billing fields together).

2. Metrics – "what numbers to show":

   • Unlike Dimensions, this list is genuinely curated, with a name and a description for each, e.g. Total Amortized Cost — "Cost with reservations/savings plans amortized over time", Total Chargeable Cost — "Cost that can be charged back to customers".

   • Select all the metrics you want on the chart & table.

3. Limit – control how many rows come back (e.g., Top 10).

   • Tick No limit to see everything (may be slower).

Click Preview (once shown) to run the query.

4. Filter the data (optional)

1. Go to the Filter tab (only visible once Dimensions and Metrics are selected — see the note above).

2. Click + Filter to add a condition. Like Dimensions, filter conditions are built against the same raw schema fields for the selected provider — this is a dynamic filter builder over raw fields, not a fixed list of conditions like "Account = …" or "Service IN (EC2, RDS)".

3. Apply the filters and Preview again.

This narrows down what shows in both the chart and the table.

5. Adjust chart & table (optional)

Chart and Table appear both as their own tabs in the tab bar, and as panels shown alongside the Report/Filter/SQL tab content once Dimensions and Metrics are selected.

• Chart

  • Shows a quick visual based on your dimensions & metrics (unless you unchecked Include Chart in step 2).

  • Use this to spot trends, spikes, and outliers.

• Table

  • Shows the exact rows behind the chart.

  • Use the Search box to find specific values.

  • Use the download icon to export (if enabled).

6. (Advanced) SQL view

• The SQL tab shows two separate generated queries: Generated Chart SQL and Generated Table SQL. They're usually similar but can differ — for example, the Table query applies your row Limit from step 3, while the Chart query typically doesn't.

• It's read-only for most users—meant for transparency and debugging, not required to use the builder.

7. Save and re-use

1. Once you're happy with the configuration, click Save.

2. Your report will appear in the Reports list so you can:

   • Re-run it with new dates

   • Tweak filters/dimensions/metrics

   • Share the report with your team (if permissions allow)

Favorite, Edit, Clone, Share, or Delete a Report

Favorite a Report

Click the Favorite icon in the report's Action column to pin it for quicker access.

Edit report

1. From the report header, click Edit report (or the equivalent edit icon).

2. You can:

   • Rename the report.

   • Modify existing report settings.

3. Click Save to apply your changes.

Clone Report

Use the Clone option to create a new Report based on an existing one.

• Click Clone from the Report options

• A duplicate Report is created with the same configuration as the original.

• You can modify the cloned Report as needed without starting from scratch.

• Cloning does not impact the original Report.

Share a Report

Click the Share icon in the Action column to share the report with other users or teams (if permissions allow) — they'll appear in that report's Shared With column.

Delete Report

To permanently remove a Report:

1. Click the Delete Report option.

2. Confirm the deletion when prompted.

Common things customers do with the builder

• "Can I mix my own dimensions and metrics without writing SQL?"
  Yes—just select them in Dimensions and Metrics. The SQL tab will show what was generated for both the chart and the table.

• "Can I see a quick visual and the rows behind it together?"
  Yes—the Chart tab/panel shows the visual; the Table tab/panel shows all the rows powering that chart.

• "Can I pivot between cost, resources, datacenter, K8s, or GenAI for the same analysis?"
  Yes—switch the Schema dropdown. Note that the available Dimensions (raw fields) change based on the Schema and provider you pick, since Dimensions reflects that data source's own raw schema.

Troubleshooting

• If Preview doesn't return the data you expect, check the Filter tab — a filter applied earlier in the session narrows both the chart and table together, and it's easy to forget one's still active.

• If the SQL tab looks locked or non-editable, that's expected — it's read-only for most users, meant for transparency and debugging rather than direct editing.

• If you can't find the Filter, Chart, Table, or SQL tabs, select at least one Dimension and one Metric first — those tabs (and the Preview button) only appear once both are set.

• If a Dimension you expected isn't in the list, remember Dimensions is the raw billing-export schema for the selected Schema/provider — the field may exist under a different raw name (e.g. AWS's own CUR column naming) than you'd expect from the UI's other pages.