Filament•2y ago

charts

I'm building mixed chart type widget, One chart is line and the other is Bar both of them have data from different tables.. so how can I retrieve there data from each table ... and I'm not using apex chart so if there is any other solution please tell me........ I'm already using getFilter and trenvalue map function but it only retrieve data of one graph ty

15 Replies

awcodes•2y ago

Is the problem only happening when you filter? If it’s only querying one table then I’d recommend just doing two separate queries with Trend::query. Then just map each one separately into different data objects.

NoorOP•2y ago

Can you please show me an example because If I use two trend queries with the same filter attribute twice, it doesn't work @awcodes

awcodes•2y ago

can you provide your widget code?

NoorOP•2y ago

message.txt

NoorOP•2y ago

message.txt

NoorOP•2y ago

message.txt

NoorOP•2y ago

@awcodes

awcodes•2y ago

$submissionData = Trend::model(Submission::class)....
$leadData = Trend::model(Lead::class)....

'datasets' => [
  [
      'label' => 'Submissions',
      'data' => $submissionData->map(fn (TrendValue $value) => $value->aggregate),
  ],
  [
      'label' => 'Leads',
      'data' => $leadData->map(fn (TrendValue $value) => $value->aggregate),
  ],
],

$submissionData = Trend::model(Submission::class)....
$leadData = Trend::model(Lead::class)....

'datasets' => [
  [
      'label' => 'Submissions',
      'data' => $submissionData->map(fn (TrendValue $value) => $value->aggregate),
  ],
  [
      'label' => 'Leads',
      'data' => $leadData->map(fn (TrendValue $value) => $value->aggregate),
  ],
],

This is what i meant

NoorOP•2y ago

and labels like this ? 'labels' => $submissionData->map(fn (TrendValue $value) => $value->date), 'labels' => $leadData->map(fn (TrendValue $value) => $value->date), @awcodes

awcodes•2y ago

you can only have one set of labels

NoorOP•2y ago

then it shows data error

awcodes•2y ago

but since both would have the same dates you could use either one for the lables

NoorOP•2y ago

undefined variable $data

awcodes•2y ago

'datasets' => [
  [
      'label' => 'Submissions',
      'data' => $submissionData->map(fn (TrendValue $value) => $value->aggregate),
  ],
  [
      'label' => 'Leads',
      'data' => $leadData->map(fn (TrendValue $value) => $value->aggregate),
  ],
],
'labels' => $leadData->map(fn (TrendValue $value) => $value->date)

'datasets' => [
  [
      'label' => 'Submissions',
      'data' => $submissionData->map(fn (TrendValue $value) => $value->aggregate),
  ],
  [
      'label' => 'Leads',
      'data' => $leadData->map(fn (TrendValue $value) => $value->aggregate),
  ],
],
'labels' => $leadData->map(fn (TrendValue $value) => $value->date)

in my head that should work

NoorOP•2y ago

okay I'll try that thankyou so much @awcodes

Gaming

Programming

charts

Did you find this page helpful?