Summer & Winter Exhibition statistics

← Return to the main page
@foreach($allYears as $yr)
@endforeach
Overall summary of all exhibitions (with paid entries)
@foreach($generalStats as $stat) @endforeach
Year Season Total Submissions Submission Period (Days) First Submission Last Submission Total Amount
{{ $stat->year }} @if($stat->Season == 'Summer') {{ $stat->Season }} @elseif($stat->Season == 'Winter') {{ $stat->Season }} @else {{ $stat->Season ?? 'N/A' }} @endif {{ $stat->Sum_entries }} {{ $stat->Submission_Days }} Day {{ $stat->First_submission_date }} {{ $stat->last_submission_date }} {{ $stat->Total }}
@foreach($allYears as $yr)
@endforeach
Submissions by country
Download as CSV
@foreach($countryStats as $stat) @php $percentage = $totalSubmissionsCount > 0 ? ($stat->total / $totalSubmissionsCount) * 100 : 0; @endphp @endforeach
Country ↕ Number of submissions ↕ % of Total ↕ Total Amount (£) ↕
{{ $stat->country ?? 'N/A' }} {{ $stat->total }} {{ number_format($percentage, 2) }}% {{ number_format($stat->total_amount ?? 0, 2) }} £
Grand Total: {{ $totalSubmissionsCount }} 100.0% {{ number_format($countryStats->sum('total_amount'), 2) }} £
@foreach($allYears as $yr)
@endforeach
Unique Emails (Total: {{ $uniqueEmails->count() }} | Total Amount: {{ number_format($totalEmailsSum, 2) }} £)
Download as CSV
@foreach($uniqueEmails as $emailRow) @endforeach
Name ↕ Last ↕ Email ↕ Count ↕ SumP (£) ↕
{{ $emailRow->Name }} {{ $emailRow->Last }} {{ $emailRow->Email }} {{ $emailRow->count }} {{ $emailRow->SumP }} £
@foreach($allYears as $yr)
@endforeach
Comparison of daily submissions by Exhibition
@foreach($allYears as $yr)
@endforeach
Artists (unique, total: {{ $uniqueArtists->count() }})
Download as CSV
@foreach($uniqueArtists->values() as $artist) @endforeach
Name ↕ Last ↕ Email ↕ Entries Count ↕ Total Amount (£) ↕
{{ $artist->Name }} {{ $artist->Last }} {{ $artist->Email }} {{ $artist->entry_count }} {{ number_format($artist->total_amount, 2) }} £
Grand Total: {{ number_format($grandTotalRevenue, 2) }} £
Annual revenues (filtered by Paid)
Download as CSV
@foreach($yearlyRevenue as $rev) @endforeach
Exhibition (Year & Season) Total
{{ $rev->year }} {{ $rev->Season }} {{ number_format($rev->total_amount, 2) }} £