Dear Team, I need a small help on how to write a query in value metrics function. And below is my requirement.

I need to display the sum/count of the payment done by different payment modes like cash,card and cheque by value metrics functionality.

payment type (column name) and we will store the id of different payment types like 1(id) - cash, 2(id) - card and 3(id) - cheque.

And for that i need to join the above table with other table to print the name of the payment type.

so now how can i implement the above requirement for value metric functionality.

<?php

use \koolreport\dashboard\metrics\Value;
use \koolreport\dashboard\fields\Date;
use \koolreport\dashboard\fields\Number;

class PaymentTable extends Value
{
    protected function dataSource()
    {
        return AutoMaker::table("table name");
    }

    protected function fields()
    {
        return [
            Date::create("Cloumn name"),
            $this->sum(
                Number::create("Cloumn name")
            ),
			$this->sum(
                Number::create("Cloumn name")
            ),
        ];
	
    }
	
}

Please help me

Dear Team, Can I expect a reply from you people. or else still i need to wait?

Hey you supporting team are you hearing my issue or not. Can I expect a reply from you people. or else still i need to wait?

Dear Team, Thanks for the solutions and the above code had worked and able to produce the desire output.

Dear Team, When I am implementing the panel concept for group of value metrics it is now showing in adjacent format.

Cloud you please help me on how correct my code to display the value metrics in adjacent of panel. And the code is below.

how make them adjacent in a panel and not like in the image below.

HomeBoard.php

Row::create([
			Panel::create()->header("Patient Statistics")->type("primary")->sub([
			    inquires::create()->width(1/6),
				appointments::create()->width(1/6),
                visits::create()->width(1/6),
                consultations::create()->width(1/6),
				registrations::create()->width(1/6),
				renewals::create()->width(1/6)
            ])
			]),

Dear Team, Thanks for the solutions and I do have any other query that is I have implemented a column chart in the dashboard but there are some of the conditions that need to satisfy.

1. Count of inquiries, appointments, visits, and consultations based on individual branches need to be shown in the chart.

2. I need to join data from different tables like branches from table branch, inquiries from table customer inquiries.

3. appointments, visits, and consultations from table consultations.

So, can you please help me with how to join the three tables(branch, customer inquiries, consultations) and need to show the count data of inquiries, appointments, visits, and consultations based on individual branches.

I have used only one table in my code but i need to join 3 tables as specified above please help me on how join them.

Branchdata.php

<?php
use \koolreport\dashboard\widgets\google\BarChart;
//use \koolreport\dashboard\fields\Date;
use \koolreport\dashboard\fields\Text;
use \koolreport\dashboard\fields\Number;


class branchdata extends BarChart
{
	protected function onCreated()
    {
        $this
        ->title("Registrations by individual branch")
        ->options([
            "isStacked"=>true
        ]);
        //->colorScheme(["#000","#444","#888"])
        //->height("320px");
    }
	
    protected function dataSource()
    {
        return AutoMaker::table("tblcustomerenquiries")
                ->groupBy("custBranchId")
                ->select("custBranchId")
                ->sum("custRegistrationId")->alias("registrations")
				->sum("custEnquiryId")->alias("inquires");
    }

    protected function fields()
    {
        return [
            Number::create("custBranchId"),
            Number::create("registrations"),
			Number::create("inquires"),
        ];
    }
}

Dear Team, Please help me with how to join various tables in the dashboard chart.

Dear Team, As per you instructions I have implemented the code but it not worked out.

Panel::create()->header("Patient Statistics")->type("primary")->Row::create([
			sub([inquires::create(),
				appointments::create(),
                visits::create(),
                consultations::create(),
				registrations::create(),
				renewals::create(),
            ])
			]),

Error for above code

Dear Team please help me for the following issue https://www.koolreport.com/forum/topics/2125#p11385

Dear Team, I am really sorry for the issues and now I have raised the separate ticket for the above issue.