What this widget shows
GGR Chart visualizes GGR over a selected time range and adds four summary cards:
- Total GGR
- Average Daily GGR
- Highest GGR
- GGR Trend
How to read it
The chart points come from the chart row source. The four summary cards are calculated by the widget from the returned ggr points.
- The widget defaults to the
14Dpreset on first render. Streamer datais a visible toggle. Off means non-streamer users only; on means streamer users only.Refreshre-runs the current chart query without changing the selected range.Download dataasks the same chart source for a file. In the current implementation this may not create a CSV because the chart source returns chart data, not a file response.Average Daily GGRdivides by the number of returned chart points, not by the nominal preset day count.
Time range behavior
The range buttons are:
7D14D30D90D
The selected range controls the start date sent to the chart query.
The widget subtracts 7, 14, 30, or 90 calendar days from the current date to build the query window. The label should therefore be read as a preset range helper, not as a guarantee about the exact number of returned chart points.
Trend logic
The widget splits the loaded series in half:
- first half = previous period
- second half = recent period
Then it calculates:
((recent_ggr - previous_ggr) / previous_ggr) * 100
If the previous half sums to zero, the trend is shown as 0.
This split happens after the row source has already:
- normalized dates into
Europe/Londonday buckets - returned only the visible chart series
- optionally padded a short response with one synthetic zero-GGR row
GGR source basis
The chart source loads casino transactions for bet and win actions in the selected date window. For each transaction it converts the cash amount with:
cash_amount / conversion_rate
The visible ggr point is then:
round(sum(converted cash bets) - sum(converted cash wins), 2)
Rows with game_identifier equal to correction, bonus_payout, rakeback_calendar, or referral_rakeback are excluded from the visible ggr. Marketing rows are also excluded. The source has separate bonus-side measures, but this widget renders only the cash-side ggr.
Known caveats
- The row source groups transactions by UTC date, then rewrites returned dates into
Europe/Londonday labels. - The source path still contains a display pad for a very short three-row response with no row matching the selected end date; in that case it pads the chart with a synthetic zero-GGR row.
Total GGR,Average Daily GGR,Highest GGR, andGGR Trendare all calculated from the loaded series, not returned as a dedicated summary object.- The row source uses the transaction-level
conversion_ratefield. If the rate is missing or zero, that row's converted amount becomes null and is ignored by the aggregate before the final zero fallback. Bet CountandWin Countare returned by the response type, but the current widget does not render them.