intermediate
reports
exports
scheduling

Reports

Guide to generating and scheduling reports in Levy Fleets - create custom reports, export data, and automate reporting workflows.

Levy Fleets Team25 décembre 202510 min read

Reports

The Reports feature allows you to generate detailed reports on fleet operations, export data for analysis, and schedule automated report delivery.

Navigation

Access Reports from Dashboard > Analytics > Reports tab.

Available Reports

Ride Reports

ReportDescription
Ride SummaryOverview of rides for period
Ride DetailsFull details of each ride
Ride RevenueRevenue breakdown by ride
Ride DurationDuration analysis
Geographic ReportStart/end locations

Financial Reports

ReportDescription
Revenue SummaryTotal revenue breakdown
Daily RevenueDay-by-day revenue
Payment ReportPayment method analysis
Refund ReportRefunds issued
Promo Code ReportPromotion usage

Fleet Reports

ReportDescription
Vehicle StatusCurrent fleet state
Utilization ReportUsage by vehicle
Maintenance LogService history
Battery ReportCharge levels and health
IoT StatusDevice connectivity

Customer Reports

ReportDescription
Customer SummaryCustomer base overview
New CustomersAcquisition report
Customer ActivityEngagement metrics
Wallet ReportWallet balances
Loyalty ReportPoints and tiers

Operational Reports

ReportDescription
Zone UsageZone analytics
Compliance ReportPolicy adherence
Incident ReportIssues and resolutions
Staff ActivityOperator actions

Generating Reports

Quick Reports

Generate instant reports:

  1. Navigate to Reports
  2. Select report type
  3. Choose time period
  4. Apply filters
  5. Click Generate
  6. View or download

Custom Reports

Create tailored reports:

  1. Click Custom Report
  2. Select data sources
  3. Choose fields to include
  4. Apply grouping/sorting
  5. Set filters
  6. Generate or save template

Report Parameters

Common parameters:

ParameterOptions
Date RangeToday, week, month, custom
SubaccountAll or specific location
Vehicle TypeAll or specific model
StatusAll or specific status
FormatCSV, PDF, Excel

Report Formats

CSV Export

Best for:

  • Data analysis
  • Import to spreadsheets
  • Database loading
  • Large datasets

PDF Reports

Best for:

  • Sharing with stakeholders
  • Printing
  • Formal documentation
  • Visual reports

Excel Export

Best for:

  • Pivot tables
  • Charts and graphs
  • Multi-sheet reports
  • Formula-based analysis

Scheduling Reports

Create Scheduled Report

  1. Generate report with desired settings
  2. Click Schedule This Report
  3. Configure schedule:
    • Frequency (daily/weekly/monthly)
    • Day and time
    • Recipients
  4. Save schedule

Schedule Settings

SettingOptions
FrequencyDaily, Weekly, Monthly
DaySpecific day of week/month
TimeHour to generate
FormatCSV, PDF, Excel
RecipientsEmail addresses

Managing Schedules

View and manage scheduled reports:

  • See all active schedules
  • Edit schedule settings
  • Pause/resume delivery
  • Delete schedules

Example Schedules

Daily Operations:

  • Ride summary
  • Every morning at 7 AM
  • To: operations team

Weekly Management:

  • Revenue and fleet report
  • Every Monday at 9 AM
  • To: management team

Monthly Finance:

  • Full financial report
  • 1st of each month
  • To: finance team

Report Templates

Saving Templates

Save report configurations:

  1. Configure report settings
  2. Click Save as Template
  3. Name the template
  4. Template available in list

Using Templates

Generate from saved template:

  1. Select template
  2. Adjust date range if needed
  3. Generate report

Sharing Templates

Share templates with team:

  • Team-wide templates
  • Personal templates
  • Export/import templates

Data Fields

Ride Data Fields

FieldDescription
ride_idUnique ride identifier
start_timeRide start timestamp
end_timeRide end timestamp
durationDuration in minutes
distanceDistance in km
fareTotal charge
vehicle_idVehicle used
customer_idCustomer who rode

Financial Fields

FieldDescription
revenueTotal revenue
unlock_feeUnlock fee charged
time_chargePer-minute charges
distance_chargePer-km charges
promo_discountDiscounts applied
net_revenueAfter discounts

Vehicle Fields

FieldDescription
vehicle_numberVehicle identifier
modelVehicle model
statusCurrent status
batteryBattery percentage
last_rideLast ride timestamp
total_ridesLifetime rides

Filtering Reports

Basic Filters

Apply simple filters:

  • Date range
  • Status
  • Location
  • Vehicle type

Advanced Filters

Create complex filters:

WHERE revenue > 5
AND duration < 60
AND start_zone = 'Downtown'

Filter Combinations

Combine multiple conditions:

  • AND: All conditions must match
  • OR: Any condition matches
  • NOT: Exclude matching

Aggregations

Summary Calculations

Available aggregations:

FunctionDescription
SUMTotal of values
AVGAverage
COUNTNumber of items
MINMinimum value
MAXMaximum value

Grouping

Group data by:

  • Date (day/week/month)
  • Vehicle
  • Customer
  • Zone
  • Model

Example Aggregations

Revenue by Day:

GROUP BY date
SUM(revenue)

Rides by Model:

GROUP BY vehicle_model
COUNT(ride_id)
AVG(duration)

Report Delivery

Email Delivery

Scheduled reports delivered via email:

  • PDF attachment
  • CSV attachment
  • Direct download link
  • In-line summary

Dashboard Access

View generated reports:

  • Recent reports list
  • Download history
  • Regenerate option

API Access

Programmatic report access:

  • Report generation endpoint
  • Download endpoint
  • Status checking

Data Retention

Report History

Reports are retained for:

  • Generated reports: 90 days
  • Scheduled reports: 30 days
  • Download links: 7 days

Data Export

For long-term storage:

  1. Generate report
  2. Download immediately
  3. Store in your systems

Best Practices

Report Design

  • Include only needed fields
  • Use appropriate aggregations
  • Choose right time granularity
  • Name reports clearly

Performance

  • Filter data before export
  • Use date ranges appropriately
  • Avoid overly complex reports
  • Schedule during off-peak

Security

  • Limit report access
  • Redact sensitive data
  • Review recipient lists
  • Monitor report usage

Troubleshooting

Report Not Generating

  1. Check date range has data
  2. Verify filter selections
  3. Try smaller date range
  4. Check system status

Wrong Data

  1. Verify filters are correct
  2. Check time zone settings
  3. Review data source
  4. Compare with dashboard

Scheduled Report Not Received

  1. Check recipient email
  2. Verify schedule is active
  3. Check spam folder
  4. Review delivery logs

Need Help?

For reporting assistance, contact support@levyelectric.com.