Stats - a number of different stats but only one by date_month

[timmoammo]

Hello,

I'm trying to report a number of different stats however only one of the stats needs to be by month. All of the other stats are sum/avg/max for the whole period. If I add "by date_month" to the end of the search it appears to complete each of the stats by month.

Is there any way to separate the one stats component from the rest?

stats sum(UAFG_Adjusted_Energy___GJ) as Consumption_Adjusted_for_UAFG 
sum(Energy___GJ) as Consumption_Without_UAFG
avg(gsa_energy_charge) as Commodity_Average_Rate
sum(Commodity) as Commodity_Total
avg(vic_mkt_energy_safe_vic_charge) as ESV_Average_Rate
max(Energy_Safe_VIC) as ESV_max
max(cud_mthly_metering) by date_month

Many thanks

[HiroshiSatoh]

Do not be resolved by "appendcols"?

search *|stats sum(a)･･････|appendcols [search *|stats sum(x) by month]

[HiroshiSatoh]

I am glad if there is no problem as the answer, and enjoy it by clicking the check to the left of the answer.

[timmoammo]

Thanks for your answer. I can see how this would work however I've found a different solution by adjusting the search upstream of the stats. Thanks