do calculation on collections of model

Hi everyone, I have the collection below and I want to compute the average of all uptimes with the type API group by every day, how can I do that? I fetched all data from the table first, and I want to do calculations on it with the help of eloquent, I do not want to get average at first, I mean I want to find every day average uptime of API types. is there a good way to do so? I don't want to use chart data, think that I don't have any access to the model, I just should work with this collection. thank you all,

	Illuminate\Database\Eloquent\Collection {#1262
#items: array:3 [
0 => App\Models\ChartData {#1263
  #connection: "mysql"
  #table: "chart_data"
  #primaryKey: "id"
  #keyType: "int"
  +incrementing: true
  #with: []
  #withCount: []
  +preventsLazyLoading: false
  #perPage: 15
  +exists: true
  +wasRecentlyCreated: false
  #escapeWhenCastingToString: false
  #attributes: array:3 [
    "date" => "2023-04-16 20:29:28"
    "uptime" => "100"
    "type" => "API"
  ]
  #original: array:3 [
    "date" => "2023-04-16 20:29:28"
    "uptime" => "100"
    "type" => "API"
  ]
  #changes: []
  #casts: []
  #classCastCache: []
  #attributeCastCache: []
  #dates: []
  #dateFormat: null
  #appends: []
  #dispatchesEvents: []
  #observables: []
  #relations: []
  #touches: []
  +timestamps: true
  #hidden: []
  #visible: []
  #fillable: array:4 [
    0 => "type"
    1 => "site_name"
    2 => "uptime"
    3 => "date"
  ]
  #guarded: array:1 [
    0 => "*"
  ]
}
1 => App\Models\ChartData {#1264
  #connection: "mysql"
  #table: "chart_data"
  #primaryKey: "id"
  #keyType: "int"
  +incrementing: true
  #with: []
  #withCount: []
  +preventsLazyLoading: false
  #perPage: 15
  +exists: true
  +wasRecentlyCreated: false
  #escapeWhenCastingToString: false
  #attributes: array:3 [
    "date" => "2023-04-16 20:29:28"
    "uptime" => "100"
    "type" => "Dashboard"
  ]
  #original: array:3 [
    "date" => "2023-04-16 20:29:28"
    "uptime" => "100"
    "type" => "Dashboard"
  ]
  #changes: []
  #casts: []
  #classCastCache: []
  #attributeCastCache: []
  #dates: []
  #dateFormat: null
  #appends: []
  #dispatchesEvents: []
  #observables: []
  #relations: []
  #touches: []
  +timestamps: true
  #hidden: []
  #visible: []
  #fillable: array:4 [
    0 => "type"
    1 => "site_name"
    2 => "uptime"
    3 => "date"
  ]
  #guarded: array:1 [
    0 => "*"
  ]
}
2 => App\Models\ChartData {#1265
  #connection: "mysql"
  #table: "chart_data"
  #primaryKey: "id"
  #keyType: "int"
  +incrementing: true
  #with: []
  #withCount: []
  +preventsLazyLoading: false
  #perPage: 15
  +exists: true
  +wasRecentlyCreated: false
  #escapeWhenCastingToString: false
  #attributes: array:3 [
    "date" => "2023-04-16 20:29:28"
    "uptime" => "100"
    "type" => "Pay"
  ]
  #original: array:3 [
    "date" => "2023-04-16 20:29:28"
    "uptime" => "100"
    "type" => "Pay"
  ]
  #changes: []
  #casts: []
  #classCastCache: []
  #attributeCastCache: []
  #dates: []
  #dateFormat: null
  #appends: []
  #dispatchesEvents: []
  #observables: []
  #relations: []
  #touches: []
  +timestamps: true
  #hidden: []
  #visible: []
  #fillable: array:4 [
    0 => "type"
    1 => "site_name"
    2 => "uptime"
    3 => "date"
  ]
  #guarded: array:1 [
    0 => "*"
  ]
}

]

LaryAI

3 years ago

Level 58

To compute the average of all uptimes with the type API group by every day, you can use the groupBy() method to group the collection by date and type, and then use the avg() method to calculate the average uptime for each group. Here's an example:

$averages = $collection->groupBy(function ($item) {
    return $item->date->format('Y-m-d') . '-' . $item->type;
})->map(function ($group) {
    return $group->avg('uptime');
});

This will return a new collection where the keys are the date and type of each group, and the values are the average uptimes for each group. You can then further manipulate this collection as needed.

Note that this assumes that the date attribute on your ChartData model is a Carbon instance or can be converted to one. If it's not, you may need to modify the groupBy() callback accordingly.

1 like

Please or to participate in this conversation.