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)

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.