Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory :  /home/corals/old/vendor/mirasvit/module-search-ultimate/src/SearchReport/etc/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?xml version="1.0" encoding="UTF-8"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:noNamespaceSchemaLocation="../../../../module-report/src/ReportApi/etc/mst_report.xsd">

    <table name="mst_search_report_log">

        <pk name="log_id" label="Searches"/>

        <column name="created_at" label="Date" type="date"/>

        <column name="results" label="Number of Results" type="number"/>

        <column name="unique_searches" label="Unique Searches" fields="query" type="qty"
                expr="COUNT(DISTINCT(%1))"/>

        <column name="users" label="Users" fields="session" expr="COUNT(DISTINCT(%1))" type="qty"/>

        <column name="engagement" label="Engagement" fields="clicks"
                type="percent" expr="ROUND(SUM(case when %1>0 then 1 else null end) * 100 / COUNT(log_id), 1)"/>

        <column name="query" label="Query" expr="%1"/>

        <column name="misspell_query" label="Misspell query" expr="%1"/>

        <column name="fallback_query" label="Fallback query" expr="%1"/>
    </table>
</config>