Extend energy dashboard with carbon emissions

I have the energy dashboard setup with my electric, gas, and the CO2 signal integration. Along with some standard estimates of CO2 emissions, HA could display my CO2 emissions in the same way as energy & gas consumption.

I’m able to figure out how to compute these values, but I’m not so good with building fancy dashboards. Here’s what I’ve thrown together as custom sensors:

- sensor:
    - name: Carbon emissions from electricity usage
      unit_of_measurement: gCO2eq
      icon: mdi:molecule-co2
      state_class: measurement
      state: >
        {% set usage = states('sensor.total') | float %}
        {% set co2 = states('sensor.us_nw_ava_co2_intensity') | float %}
        {{ (co2 * usage / 1000.0) | int }}

# https://www.epa.gov/energy/greenhouse-gases-equivalencies-calculator-calculations-and-references
# there are 0.0551 metric tons CO2/Mcf
# there are 1000 kilograms/metric ton and 1000 ft^3/Mcf
# so there are 55.1 grams CO2/ft^3
- sensor:
    - name: Carbon emissions from gas usage
      unit_of_measurement: gCO2eq
      icon: mdi:molecule-co2
      state_class: measurement
      state: >-
        {% set usage = states('sensor.gas_meter_hourly_usage') | float %}
        {{ (usage * 55.1) | int }}

I’d really like to see the daily/monthly/yearly aggregations, as well as the breakdown by source. Even better might be drilling into the electrical consumption based on the Individual devices I have configured.