InovacaoMediaBrasil/ProcessWorkflowsAndDatabaseScripts

<gadget>
    <prompt-parameters>
        <parameter id="DTINI" description="1. Data Inicial" metadata="date" required="true" keep-last="true" keep-date="false"/>
        <parameter id="DTFIM" description="2. Data Final" metadata="date" required="true" keep-last="true" keep-date="false"/>
    </prompt-parameters>
    <level id="lvl_v0i5ov" description="Principal">
        <container orientacao="V" tamanhoRelativo="100">
            <chart id="cht_v0i5o5" type="pizza">
                <expression type="sql" data-source="MGEDS">
                    <![CDATA[  SELECT OCORRENCIA, COUNT(DISTINCT CODPROD) AS QTD_PRODUTOS  FROM sankhya.AD_LOGALTERACOESVTEX WITH(NOLOCK)  WHERE DTALTER >= :DTINI AND DTALTER < DATEADD(DAY,1,:DTFIM)  GROUP BY OCORRENCIA]]>
                </expression>
                <metadata>
                    <field name="OCORRENCIA" label="Ocorrência" type="S" visible="true" useFooter="false"/>
                    <field name="QTD_PRODUTOS" label="Qtd_Produtos" type="I" visible="true" useFooter="false"/>
                </metadata>
                <series>
                    <serie type="pizza">
                        <field>QTD_PRODUTOS</field>
                        <nameField>OCORRENCIA</nameField>
                    </serie>
                </series>
            </chart>
        </container>
    </level>
</gadget>