Charts that feel like Rails

def show
  @filters = RailsuiCharts::Filters.new(params)

  current = revenue_for(@filters.range)
  previous = @filters.previous_range && revenue_for(@filters.previous_range)
  active_subscribers = Account.active.count
  previous_active_subscribers = Account.active.where(created_at: @filters.previous_range).count if @filters.previous_range
  new_trials = Account.trialing.where(created_at: @filters.range).count
  previous_new_trials = Account.trialing.where(created_at: @filters.previous_range).count if @filters.previous_range
  gross_volume = Order.paid.where(created_at: @filters.range).sum(:total)
  previous_gross_volume = Order.paid.where(created_at: @filters.previous_range).sum(:total) if @filters.previous_range
  churn_rate = Account.churn_rate(@filters.range)
  previous_churn_rate = Account.churn_rate(@filters.previous_range) if @filters.previous_range

  @metrics = [
    { label: "MRR", value: current.values.last, previous: previous&.values&.last,
      format: :currency, history: current, compare: previous&.values },
    { label: "ARR", value: current.values.last * 12, previous: previous&.values&.last&.*(12),
      format: :currency, history: current.transform_values { |value| value * 12 },
      compare: previous&.values&.map { |value| value * 12 } },
    { label: "Active subscribers", value: active_subscribers,
      previous: previous_active_subscribers, format: :number,
      history: current, compare: previous&.values },
    { label: "New trials", value: new_trials, previous: previous_new_trials,
      format: :number, history: current, compare: previous&.values },
    { label: "Gross volume", value: gross_volume, previous: previous_gross_volume,
      format: :currency, history: current, compare: previous&.values },
    { label: "Churn rate", value: churn_rate, previous: previous_churn_rate,
      format: :percentage, positive_is_good: false,
      history: current, compare: previous&.values }
  ]
end

private

# A grouped hash is already the shape the helper takes: label => value.
def revenue_for(range)
  Order.paid.where(created_at: range)
       .group("TO_CHAR(created_at, 'Mon DD')").sum(:total)
end

<%= railsui_chart_filters @filters, url: charts_path, frame: "chart-dashboard" %>

<div class="grid grid-cols-1 md:grid-cols-2 xl:grid-cols-3 gap-4 md:gap-5">
  <% @metrics.each do |metric| %>
    <%= railsui_metric_card(**metric, expand: true) %>
  <% end %>
</div>