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.

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:

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):

   • Examples: Account, Service, Region, Namespace, Cluster, Action Status, etc.

   • You can pick more than one (e.g., Account + Service).

2. Metrics – “what numbers to show”:

   • Examples: Cost, Average Cost, Usage quantity, Number of resources, etc.

   • 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 (if shown) to run the query.

4. Filter the data (optional)

1. Go to the Filter tab.

2. Add conditions like:

   • Account = …

   • Service IN (EC2, RDS)

   • Tag = “Production”

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

  • The top panel shows a quick visual based on your dimensions & metrics.

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

• Table

  • The bottom panel 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 the query the builder generated.

• 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)

Edit/Clone or Delete a Report

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.

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.

• “Can I see a quick visual and the rows behind it together?”
  Yes—the Chart shows the visual; the Table 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 and keep similar dimensions/metrics where available.