Dashboards & Visualizations
Highlighted

"Search produced no results" using timepicker token.

Explorer

Hi Everyone,

I'm using 5 dropdown filter on my dashboard. The dropdown get time value from TIMEPICKER. So, when I changed the timepicker one time or second time, itś work fine.
alt text

but, if I change the value on third time, I have the error "Search produced no results".

alt text

On my search string, I can set>

index=xxx earliest="$timerange.earliest$" latest="$timerange.latest$"

How I can fix this?

I tried with another browser, same error.

Thanks!!!

Tags (2)
0 Karma
Highlighted

Re: "Search produced no results" using timepicker token.

Influencer

Can you post the XML source code of your dashboard? It would be helpful in debugging this.

Highlighted

Re: "Search produced no results" using timepicker token.

Explorer

@masonmorales

That's my XML.

<form refresh="30000">
  <label>NET - Analise de serviços - Principal</label>
  <description>Analise de serviços</description>
  <fieldset submitButton="false" autoRun="true"></fieldset>
  <row>
    <panel depends="$menu$">
      <input type="time" token="timerange" searchWhenChanged="true">
        <label>Periodo</label>
        <default>
          <earliest>0</earliest>
          <latest></latest>
        </default>
      </input>
      <input type="dropdown" token="BU" searchWhenChanged="true">
        <choice value="*">TODOS</choice>
        <default>*</default>
        <search>
          <query>index=aternity_raw   earliest="$timerange.earliest$"  latest="$timerange.latest$"    $TRANSACTION_NAME$ STATE="$STATE$"   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    ACTIVITY_TYPE="$ACTIVITY_TYPE$" | stats count by CONTAINER_NAME</query>
        </search>
        <fieldForLabel>CONTAINER_NAME</fieldForLabel>
        <fieldForValue>CONTAINER_NAME</fieldForValue>
      </input>
      <input type="dropdown" token="LOCATION" searchWhenChanged="true">
        <label>Lojas / Operação</label>
        <choice value="*">Todos</choice>
        <search>
          <query>index=aternity_raw   earliest="$timerange.earliest$"  latest="$timerange.latest$"    $TRANSACTION_NAME$ CONTAINER_NAME="$BU$"   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="$ACTIVITY_TYPE$"   | stats count by LOCATION</query>
          <earliest>0</earliest>
        </search>
        <fieldForLabel>LOCATION</fieldForLabel>
        <fieldForValue>LOCATION</fieldForValue>
        <default>*</default>
      </input>
      <input type="dropdown" token="STATE" searchWhenChanged="true">
        <label>Localização</label>
        <search>
          <query>index=aternity_raw   earliest="$timerange.earliest$"  latest="$timerange.latest$"    $TRANSACTION_NAME$ CONTAINER_NAME="$BU$"   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    ACTIVITY_TYPE="$ACTIVITY_TYPE$"  | stats count by STATE   | sort STATE</query>
          <earliest>@d</earliest>
          <latest>now</latest>
        </search>
        <fieldForLabel>STATE</fieldForLabel>
        <fieldForValue>STATE</fieldForValue>
        <choice value="*">TODOS</choice>
        <default>*</default>
      </input>
      <input type="radio" token="LOCATION2" searchWhenChanged="true">
        <label></label>
        <choice value="=*">Loja / Operação</choice>
        <choice value="=Loja*">Loja</choice>
        <choice value="!=Loja*">Operação</choice>
        <default>=*</default>
      </input>
      <input type="multiselect" token="TRANSACTION_NAME" searchWhenChanged="true">
        <label>Transação</label>
        <choice value="*">Todos</choice>
        <search>
          <query>index=aternity_raw   earliest="$timerange.earliest$"  latest="$timerange.latest$"  $TRANSACTION_NAME$ CONTAINER_NAME="$BU$"   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    | stats count by  TRANSACTION_NAME</query>
          <earliest>0</earliest>
        </search>
        <fieldForLabel>TRANSACTION_NAME</fieldForLabel>
        <fieldForValue>TRANSACTION_NAME</fieldForValue>
        <prefix>(</prefix>
        <suffix>)</suffix>
        <valuePrefix>TRANSACTION_NAME="</valuePrefix>
        <valueSuffix>"</valueSuffix>
        <delimiter> OR</delimiter>
        <default>*</default>
      </input>
      <input type="dropdown" token="ACTIVITY_TYPE" searchWhenChanged="true">
        <label>Tipo</label>
        <choice value="*">Todos</choice>
        <search>
          <query>index=aternity_raw   earliest="$timerange.earliest$"  latest="$timerange.latest$"  $TRANSACTION_NAME$ CONTAINER_NAME="$BU$"   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )       | stats count by ACTIVITY_TYPE</query>
          <earliest>0</earliest>
        </search>
        <fieldForLabel>ACTIVITY_TYPE</fieldForLabel>
        <fieldForValue>ACTIVITY_TYPE</fieldForValue>
        <default>*</default>
        <initialValue>TN-Transaction Response</initialValue>
      </input>
      <input type="checkbox" token="cabo" searchWhenChanged="true">
        <label>Apresentar:</label>
        <choice value="true">Cabo</choice>
        <default>true</default>
      </input>
      <input type="checkbox" token="DTH">
        <label></label>
        <choice value="true">DTH</choice>
        <default>true</default>
      </input>
      <input type="checkbox" token="MOVEL" searchWhenChanged="true">
        <label></label>
        <choice value="true">Movel</choice>
        <default>true</default>
      </input>
      <input type="text" token="USERNAME" searchWhenChanged="true">
        <label>Usuário</label>
        <default>*</default>
        <prefix>*</prefix>
        <suffix>*</suffix>
      </input>
      <html>

        <a href="/app/App_Net/prototipo_main">limpar</a>
  </html>
    </panel>
  </row>
  <row>
    <panel>
      <input type="checkbox" token="menu" searchWhenChanged="true">
        <label></label>
        <choice value="show">Mostra/Ocultar menu</choice>
        <default>show</default>
      </input>
    </panel>
  </row>
  <row>
    <panel depends="$cabo$">
      <title>CABO - Duração | Operações | Usuário(s) | Usuário(s) impactado(s)</title>
      <single>
        <search>
          <query>index=aternity_raw     USERNAME="$USERNAME$"  (CONTAINER_NAME="NetSMS" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="TN-Transaction Response"     TRANSACTION_NAME="TN-LOGIN"  



| strcat USERNAME + " [" + HOSTNAME + "]"  iduser  
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO


| join [search index=aternity_raw   USERNAME="$USERNAME$"  (CONTAINER_NAME="NetSMS" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="Activity Response"     TRANSACTION_NAME="TN-LOGIN" 



     | strcat USERNAME + " [" + HOSTNAME + "]"  iduser   | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE  by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]

| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe 
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
          <earliest>$timerange.earliest$</earliest>
          <latest>$timerange.latest$</latest>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">block</option>
        <option name="drilldown">all</option>
        <option name="numberPrecision">0.00</option>
        <option name="showSparkline">1</option>
        <option name="showTrendIndicator">1</option>
        <option name="trendColorInterpretation">standard</option>
        <option name="trendDisplayMode">absolute</option>
        <option name="underLabel">TN-Login</option>
        <option name="unitPosition">after</option>
        <option name="useColors">1</option>
        <option name="useThousandSeparators">1</option>
        <option name="linkView">search</option>
        <option name="classField">value</option>
        <option name="field">duration</option>
        <drilldown>
          <link>
            <![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Login&CONTAINER_NAME=NetSMS&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
          </link>
        </drilldown>
      </single>
      <single>
        <search>
          <query>index=aternity_raw     USERNAME="$USERNAME$"  (CONTAINER_NAME="NetSMS" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="TN-Transaction Response"     TRANSACTION_NAME="TN-Abertura de OC"  



| strcat USERNAME + " [" + HOSTNAME + "]"  iduser  
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO


| join [search index=aternity_raw   USERNAME="$USERNAME$"  (CONTAINER_NAME="NetSMS" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="Activity Response"     TRANSACTION_NAME="TN-Abertura de OC" 



     | strcat USERNAME + " [" + HOSTNAME + "]"  iduser   | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE  by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]

| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe 
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
          <earliest>$timerange.earliest$</earliest>
          <latest>$timerange.latest$</latest>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">block</option>
        <option name="drilldown">all</option>
        <option name="numberPrecision">0.00</option>
        <option name="showSparkline">1</option>
        <option name="showTrendIndicator">1</option>
        <option name="trendColorInterpretation">standard</option>
        <option name="trendDisplayMode">absolute</option>
        <option name="underLabel">TN-Abertura de OC</option>
        <option name="unitPosition">after</option>
        <option name="useColors">1</option>
        <option name="useThousandSeparators">1</option>
        <option name="linkView">search</option>
        <option name="classField">value</option>
        <option name="field">duration</option>
        <drilldown>
          <link>
            <![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Abertura de OC&CONTAINER_NAME=NetSMS&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
          </link>
        </drilldown>
      </single>
      <single>
        <search>
          <query>index=aternity_raw     USERNAME="$USERNAME$"  (CONTAINER_NAME="NetSMS" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="TN-Transaction Response"     TRANSACTION_NAME="TN-Abertura de OS"  



| strcat USERNAME + " [" + HOSTNAME + "]"  iduser  
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO


| join [search index=aternity_raw   USERNAME="$USERNAME$"  (CONTAINER_NAME="NetSMS" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="Activity Response"     TRANSACTION_NAME="TN-Abertura de OS" 



     | strcat USERNAME + " [" + HOSTNAME + "]"  iduser   | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE  by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]

| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe 
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
          <earliest>$timerange.earliest$</earliest>
          <latest>$timerange.latest$</latest>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">block</option>
        <option name="drilldown">all</option>
        <option name="numberPrecision">0.00</option>
        <option name="showSparkline">1</option>
        <option name="showTrendIndicator">1</option>
        <option name="trendColorInterpretation">standard</option>
        <option name="trendDisplayMode">absolute</option>
        <option name="unitPosition">after</option>
        <option name="useColors">1</option>
        <option name="useThousandSeparators">1</option>
        <option name="linkView">search</option>
        <option name="classField">value</option>
        <option name="field">duration</option>
        <option name="underLabel">TN-Abertura de OS</option>
        <drilldown>
          <link>
            <![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Abertura de OS&CONTAINER_NAME=NetSMS&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
          </link>
        </drilldown>
      </single>
      <single>
        <search>
          <query>index=aternity_raw     USERNAME="$USERNAME$"  (CONTAINER_NAME="NetSMS" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="TN-Transaction Response"     TRANSACTION_NAME="TN-Atendimento de Retencao"  



| strcat USERNAME + " [" + HOSTNAME + "]"  iduser  
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO


| join [search index=aternity_raw   USERNAME="$USERNAME$"  (CONTAINER_NAME="NetSMS" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="Activity Response"     TRANSACTION_NAME="TN-Atendimento de Retencao" 



     | strcat USERNAME + " [" + HOSTNAME + "]"  iduser   | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE  by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]

| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe 
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
          <earliest>$timerange.earliest$</earliest>
          <latest>$timerange.latest$</latest>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">block</option>
        <option name="drilldown">all</option>
        <option name="numberPrecision">0.00</option>
        <option name="showSparkline">1</option>
        <option name="showTrendIndicator">1</option>
        <option name="trendColorInterpretation">standard</option>
        <option name="trendDisplayMode">absolute</option>
        <option name="underLabel">TN-Atendimento de Retenção</option>
        <option name="unitPosition">after</option>
        <option name="useColors">1</option>
        <option name="useThousandSeparators">1</option>
        <option name="linkView">search</option>
        <option name="classField">value</option>
        <option name="field">duration</option>
        <drilldown>
          <link>
            <![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Atendimento de Retencao&CONTAINER_NAME=NetSMS&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
          </link>
        </drilldown>
      </single>
      <single>
        <search>
          <query>index=aternity_raw     USERNAME="$USERNAME$"  (CONTAINER_NAME="NetSMS" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="TN-Transaction Response"     TRANSACTION_NAME="TN-Emissao de 2a Via de Fatura"  



| strcat USERNAME + " [" + HOSTNAME + "]"  iduser  
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO


| join [search index=aternity_raw   USERNAME="$USERNAME$"  (CONTAINER_NAME="NetSMS" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="Activity Response"     TRANSACTION_NAME="TN-Emissao de 2a Via de Fatura" 



     | strcat USERNAME + " [" + HOSTNAME + "]"  iduser   | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE  by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]

| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe 
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
          <earliest>$timerange.earliest$</earliest>
          <latest>$timerange.latest$</latest>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">block</option>
        <option name="drilldown">all</option>
        <option name="numberPrecision">0.00</option>
        <option name="showSparkline">1</option>
        <option name="showTrendIndicator">1</option>
        <option name="trendColorInterpretation">standard</option>
        <option name="trendDisplayMode">absolute</option>
        <option name="underLabel">TN-Emissao de 2a Via de Fatura</option>
        <option name="unitPosition">after</option>
        <option name="useColors">1</option>
        <option name="useThousandSeparators">1</option>
        <option name="linkView">search</option>
        <option name="classField">value</option>
        <option name="field">duration</option>
        <drilldown>
          <link>
            <![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Emissao de 2a Via de Fatura&CONTAINER_NAME=NetSMS&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
          </link>
        </drilldown>
      </single>
    </panel>
  </row>
  <row>
    <panel depends="$DTH$">
      <title>DTH - Duração | Operações | Usuário(s) | Usuário(s) impactado(s)</title>
      <single>
        <search>
          <query>index=aternity_raw     USERNAME="$USERNAME$"  (CONTAINER_NAME="VSMS" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="TN-Transaction Response"     TRANSACTION_NAME="TN-LOGIN"  



| strcat USERNAME + " [" + HOSTNAME + "]"  iduser  
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO


| join [search index=aternity_raw   USERNAME="$USERNAME$"  (CONTAINER_NAME="VSMS" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="Activity Response"     TRANSACTION_NAME="TN-LOGIN" 



     | strcat USERNAME + " [" + HOSTNAME + "]"  iduser   | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE  by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]

| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe 
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
          <earliest>$timerange.earliest$</earliest>
          <latest>$timerange.latest$</latest>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">block</option>
        <option name="drilldown">all</option>
        <option name="numberPrecision">0.00</option>
        <option name="showSparkline">1</option>
        <option name="showTrendIndicator">1</option>
        <option name="trendColorInterpretation">standard</option>
        <option name="trendDisplayMode">absolute</option>
        <option name="underLabel">TN-Login</option>
        <option name="unitPosition">after</option>
        <option name="useColors">1</option>
        <option name="useThousandSeparators">1</option>
        <option name="linkView">search</option>
        <option name="classField">value</option>
        <option name="field">duration</option>
        <drilldown>
          <link>
            <![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Login&CONTAINER_NAME=VSMS&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
          </link>
        </drilldown>
      </single>
      <single>
        <search>
          <query>index=aternity_raw     USERNAME="$USERNAME$"  (CONTAINER_NAME="VSMS" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="TN-Transaction Response"     TRANSACTION_NAME="TN-Abertura de OC"  



| strcat USERNAME + " [" + HOSTNAME + "]"  iduser  
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO


| join [search index=aternity_raw   USERNAME="$USERNAME$"  (CONTAINER_NAME="VSMS" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="Activity Response"     TRANSACTION_NAME="TN-Abertura de OC" 



     | strcat USERNAME + " [" + HOSTNAME + "]"  iduser   | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE  by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]

| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe 
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
          <earliest>$timerange.earliest$</earliest>
          <latest>$timerange.latest$</latest>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">block</option>
        <option name="drilldown">all</option>
        <option name="numberPrecision">0.00</option>
        <option name="showSparkline">1</option>
        <option name="showTrendIndicator">0</option>
        <option name="trendColorInterpretation">inverse</option>
        <option name="trendDisplayMode">absolute</option>
        <option name="trendInterval">-1h</option>
        <option name="underLabel">TN-Abertura de OC</option>
        <option name="unitPosition">after</option>
        <option name="useColors">1</option>
        <option name="useThousandSeparators">1</option>
        <option name="linkView">search</option>
        <option name="classField">value</option>
        <option name="field">duration</option>
        <drilldown>
          <link>
            <![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Abertura de OC&CONTAINER_NAME=VSMS&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
          </link>
        </drilldown>
      </single>
      <single>
        <search>
          <query>index=aternity_raw     USERNAME="$USERNAME$"  (CONTAINER_NAME="VSMS" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="TN-Transaction Response"     TRANSACTION_NAME="TN-Abertura de OS"  



| strcat USERNAME + " [" + HOSTNAME + "]"  iduser  
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO


| join [search index=aternity_raw   USERNAME="$USERNAME$"  (CONTAINER_NAME="VSMS" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="Activity Response"     TRANSACTION_NAME="TN-Abertura de OS" 



     | strcat USERNAME + " [" + HOSTNAME + "]"  iduser   | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE  by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]

| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe 
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
          <earliest>$timerange.earliest$</earliest>
          <latest>$timerange.latest$</latest>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">block</option>
        <option name="drilldown">all</option>
        <option name="numberPrecision">0.00</option>
        <option name="showSparkline">1</option>
        <option name="showTrendIndicator">1</option>
        <option name="trendColorInterpretation">standard</option>
        <option name="trendDisplayMode">absolute</option>
        <option name="underLabel">TN-Abertura de OS</option>
        <option name="unitPosition">after</option>
        <option name="useColors">1</option>
        <option name="useThousandSeparators">1</option>
        <option name="linkView">search</option>
        <option name="classField">value</option>
        <option name="field">duration</option>
        <drilldown>
          <link>
            <![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Abertura de OS&CONTAINER_NAME=VSMS&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
          </link>
        </drilldown>
      </single>
      <single>
        <search>
          <query>index=aternity_raw     USERNAME="$USERNAME$"  (CONTAINER_NAME="VSMS" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="Activity Response"     TRANSACTION_NAME="TN-Abertura de OS"   "HIT DE DECODER" 



| strcat USERNAME + " [" + HOSTNAME + "]"  iduser  
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO


| join [search index=aternity_raw   USERNAME="$USERNAME$"  (CONTAINER_NAME="VSMS" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="Activity Response"     TRANSACTION_NAME="TN-Abertura de OS"  "HIT DE DECODER" 



     | strcat USERNAME + " [" + HOSTNAME + "]"  iduser   | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE  by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]

| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe 
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
          <earliest>$timerange.earliest$</earliest>
          <latest>$timerange.latest$</latest>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">block</option>
        <option name="drilldown">all</option>
        <option name="numberPrecision">0.00</option>
        <option name="showSparkline">1</option>
        <option name="showTrendIndicator">0</option>
        <option name="trendColorInterpretation">inverse</option>
        <option name="trendDisplayMode">absolute</option>
        <option name="trendInterval">-1h</option>
        <option name="underLabel">TN-Envio de HIT</option>
        <option name="unitPosition">after</option>
        <option name="useColors">1</option>
        <option name="useThousandSeparators">1</option>
        <option name="linkView">search</option>
        <option name="classField">value</option>
        <option name="field">duration</option>
        <drilldown>
          <link>
            <![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Abertura de OS" "HIT DE DECODER&CONTAINER_NAME=VSMS&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
          </link>
        </drilldown>
      </single>
      <single>
        <search>
          <query>index=aternity_raw     USERNAME="$USERNAME$"  (CONTAINER_NAME="VSMS" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="TN-Transaction Response"     TRANSACTION_NAME="TN-Visualizacao de Fatura"    



| strcat USERNAME + " [" + HOSTNAME + "]"  iduser  
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO


| join [search index=aternity_raw   USERNAME="$USERNAME$"  (CONTAINER_NAME="VSMS" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="Activity Response"     TRANSACTION_NAME="TN-Visualizacao de Fatura"  



     | strcat USERNAME + " [" + HOSTNAME + "]"  iduser   | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE  by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]

| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe 
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
          <earliest>$timerange.earliest$</earliest>
          <latest>$timerange.latest$</latest>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">block</option>
        <option name="drilldown">all</option>
        <option name="numberPrecision">0.00</option>
        <option name="showSparkline">1</option>
        <option name="showTrendIndicator">0</option>
        <option name="trendColorInterpretation">inverse</option>
        <option name="trendDisplayMode">absolute</option>
        <option name="trendInterval">-1h</option>
        <option name="underLabel">TN-Visualização de Fatura</option>
        <option name="unitPosition">after</option>
        <option name="useColors">1</option>
        <option name="useThousandSeparators">1</option>
        <option name="linkView">search</option>
        <option name="classField">value</option>
        <option name="field">duration</option>
        <drilldown>
          <link>
            <![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Visualizacao de Fatura&CONTAINER_NAME=VSMS&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
          </link>
        </drilldown>
      </single>
    </panel>
  </row>
  <row>
    <panel depends="$MOVEL$">
      <title>MÓVEL - Duração | Operações | Usuário(s) | Usuário(s) impactado(s)</title>
      <single>
        <search>
          <query>index=aternity_raw     USERNAME="$USERNAME$"  (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="TN-Transaction Response"     TRANSACTION_NAME="TN-Login Mobile"    



| strcat USERNAME + " [" + HOSTNAME + "]"  iduser  
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO


| join [search index=aternity_raw   USERNAME="$USERNAME$"  (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="Activity Response"     TRANSACTION_NAME="TN-Login Mobile"  



     | strcat USERNAME + " [" + HOSTNAME + "]"  iduser   | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE  by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]

| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe 
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
          <earliest>$timerange.earliest$</earliest>
          <latest>$timerange.latest$</latest>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">block</option>
        <option name="drilldown">all</option>
        <option name="numberPrecision">0.00</option>
        <option name="showSparkline">1</option>
        <option name="showTrendIndicator">1</option>
        <option name="trendColorInterpretation">standard</option>
        <option name="trendDisplayMode">absolute</option>
        <option name="underLabel">TN-Login Mobile</option>
        <option name="unitPosition">after</option>
        <option name="useColors">1</option>
        <option name="useThousandSeparators">1</option>
        <option name="linkView">search</option>
        <option name="classField">value</option>
        <option name="field">duration</option>
        <drilldown>
          <link>
            <![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Login Mobile&CONTAINER_NAME=Claro&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
          </link>
        </drilldown>
      </single>
      <single>
        <search>
          <query>index=aternity_raw     USERNAME="$USERNAME$"  (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="TN-Transaction Response"     TRANSACTION_NAME="TN-Login PS8"    



| strcat USERNAME + " [" + HOSTNAME + "]"  iduser  
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO


| join [search index=aternity_raw   USERNAME="$USERNAME$"  (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="Activity Response"     TRANSACTION_NAME="TN-Login PS8"  



     | strcat USERNAME + " [" + HOSTNAME + "]"  iduser   | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE  by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]

| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe 
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
          <earliest>$timerange.earliest$</earliest>
          <latest>$timerange.latest$</latest>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">block</option>
        <option name="drilldown">all</option>
        <option name="numberPrecision">0.00</option>
        <option name="showSparkline">1</option>
        <option name="showTrendIndicator">0</option>
        <option name="trendColorInterpretation">inverse</option>
        <option name="trendDisplayMode">absolute</option>
        <option name="trendInterval">-1h</option>
        <option name="underLabel">TN-Login PS8</option>
        <option name="unitPosition">after</option>
        <option name="useColors">1</option>
        <option name="useThousandSeparators">1</option>
        <option name="linkView">search</option>
        <option name="classField">value</option>
        <option name="field">duration</option>
        <drilldown>
          <link>
            <![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Login PS8&CONTAINER_NAME=Claro&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
          </link>
        </drilldown>
      </single>
      <single>
        <search>
          <query>index=aternity_raw     USERNAME="$USERNAME$"  (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="TN-Transaction Response"     TRANSACTION_NAME="TN-Login WA"    



| strcat USERNAME + " [" + HOSTNAME + "]"  iduser  
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO


| join [search index=aternity_raw   USERNAME="$USERNAME$"  (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="Activity Response"     TRANSACTION_NAME="TN-Login WA"  



     | strcat USERNAME + " [" + HOSTNAME + "]"  iduser   | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE  by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]

| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe 
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
          <earliest>$timerange.earliest$</earliest>
          <latest>$timerange.latest$</latest>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">block</option>
        <option name="drilldown">all</option>
        <option name="numberPrecision">0.00</option>
        <option name="showSparkline">1</option>
        <option name="showTrendIndicator">1</option>
        <option name="trendColorInterpretation">standard</option>
        <option name="trendDisplayMode">absolute</option>
        <option name="underLabel">TN-Login WA</option>
        <option name="unitPosition">after</option>
        <option name="useColors">1</option>
        <option name="useThousandSeparators">1</option>
        <option name="linkView">search</option>
        <option name="classField">value</option>
        <option name="field">duration</option>
        <drilldown>
          <link>
            <![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Login WA&CONTAINER_NAME=Claro&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
          </link>
        </drilldown>
      </single>
      <single>
        <search>
          <query>index=aternity_raw     USERNAME="$USERNAME$"  (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="TN-Transaction Response"     TRANSACTION_NAME="TN-Login WM"    



| strcat USERNAME + " [" + HOSTNAME + "]"  iduser  
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO


| join [search index=aternity_raw   USERNAME="$USERNAME$"  (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="Activity Response"     TRANSACTION_NAME="TN-Login WM"  



     | strcat USERNAME + " [" + HOSTNAME + "]"  iduser   | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE  by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]

| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe 
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
          <earliest>$timerange.earliest$</earliest>
          <latest>$timerange.latest$</latest>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">block</option>
        <option name="drilldown">all</option>
        <option name="numberPrecision">0.00</option>
        <option name="showSparkline">1</option>
        <option name="showTrendIndicator">0</option>
        <option name="trendColorInterpretation">inverse</option>
        <option name="trendDisplayMode">absolute</option>
        <option name="trendInterval">-1h</option>
        <option name="underLabel">TN-Login WM</option>
        <option name="unitPosition">after</option>
        <option name="useColors">1</option>
        <option name="useThousandSeparators">1</option>
        <option name="linkView">search</option>
        <option name="classField">value</option>
        <option name="field">duration</option>
        <drilldown>
          <link>
            <![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Login WM&CONTAINER_NAME=Claro&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
          </link>
        </drilldown>
      </single>
      <single>
        <search>
          <query>index=aternity_raw     USERNAME="$USERNAME$"  (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="TN-Transaction Response"     TRANSACTION_NAME="TN-Login WPP"    



| strcat USERNAME + " [" + HOSTNAME + "]"  iduser  
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO


| join [search index=aternity_raw   USERNAME="$USERNAME$"  (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="Activity Response"     TRANSACTION_NAME="TN-Login WPP"  



     | strcat USERNAME + " [" + HOSTNAME + "]"  iduser   | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE  by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]

| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe 
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
          <earliest>$timerange.earliest$</earliest>
          <latest>$timerange.latest$</latest>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">block</option>
        <option name="drilldown">all</option>
        <option name="numberPrecision">0.00</option>
        <option name="showSparkline">1</option>
        <option name="showTrendIndicator">0</option>
        <option name="trendColorInterpretation">inverse</option>
        <option name="trendDisplayMode">absolute</option>
        <option name="trendInterval">-1h</option>
        <option name="underLabel">TN-Login WPP</option>
        <option name="unitPosition">after</option>
        <option name="useColors">1</option>
        <option name="useThousandSeparators">1</option>
        <option name="linkView">search</option>
        <option name="classField">value</option>
        <option name="field">duration</option>
        <drilldown>
          <link>
            <![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Login WPP&CONTAINER_NAME=Claro&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
          </link>
        </drilldown>
      </single>
    </panel>
  </row>
  <row>
    <panel depends="$MOVEL$">
      <single>
        <search>
          <query>index=aternity_raw     USERNAME="$USERNAME$"  (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="TN-Transaction Response"     TRANSACTION_NAME="TN-Geracao de Protocolo"    



| strcat USERNAME + " [" + HOSTNAME + "]"  iduser  
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO


| join [search index=aternity_raw   USERNAME="$USERNAME$"  (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="Activity Response"     TRANSACTION_NAME="TN-Geracao de Protocolo"  



     | strcat USERNAME + " [" + HOSTNAME + "]"  iduser   | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE  by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]

| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe 
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
          <earliest>$timerange.earliest$</earliest>
          <latest>$timerange.latest$</latest>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">block</option>
        <option name="drilldown">all</option>
        <option name="numberPrecision">0.00</option>
        <option name="showSparkline">1</option>
        <option name="showTrendIndicator">1</option>
        <option name="trendColorInterpretation">standard</option>
        <option name="trendDisplayMode">absolute</option>
        <option name="underLabel">TN-Geracao de Protocolo</option>
        <option name="unitPosition">after</option>
        <option name="useColors">1</option>
        <option name="useThousandSeparators">1</option>
        <option name="linkView">search</option>
        <option name="classField">value</option>
        <option name="field">duration</option>
        <drilldown>
          <link>
            <![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Geracao de Protocolo&CONTAINER_NAME=Claro&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
          </link>
        </drilldown>
      </single>
      <single>
        <search>
          <query>index=aternity_raw     USERNAME="$USERNAME$"  (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="TN-Transaction Response"     TRANSACTION_NAME="TN-Migracao de Cliente Pre para Pos"    



| strcat USERNAME + " [" + HOSTNAME + "]"  iduser  
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO


| join [search index=aternity_raw   USERNAME="$USERNAME$"  (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="Activity Response"     TRANSACTION_NAME="TN-Migracao de Cliente Pre para Pos"  



     | strcat USERNAME + " [" + HOSTNAME + "]"  iduser   | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE  by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]

| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe 
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
          <earliest>$timerange.earliest$</earliest>
          <latest>$timerange.latest$</latest>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">block</option>
        <option name="drilldown">all</option>
        <option name="numberPrecision">0.00</option>
        <option name="showSparkline">1</option>
        <option name="showTrendIndicator">0</option>
        <option name="trendColorInterpretation">inverse</option>
        <option name="trendDisplayMode">absolute</option>
        <option name="trendInterval">-1h</option>
        <option name="underLabel">TN-Migracao de Cliente Pre para Pos</option>
        <option name="unitPosition">after</option>
        <option name="useColors">1</option>
        <option name="useThousandSeparators">1</option>
        <option name="linkView">search</option>
        <option name="classField">value</option>
        <option name="field">duration</option>
        <drilldown>
          <link>
            <![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Migracao de Cliente Pre para Pos&CONTAINER_NAME=Claro&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
          </link>
        </drilldown>
      </single>
      <single>
        <search>
          <query>index=aternity_raw     USERNAME="$USERNAME$"  (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="TN-Transaction Response"     TRANSACTION_NAME="TN-Portabilidade"    



| strcat USERNAME + " [" + HOSTNAME + "]"  iduser  
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO


| join [search index=aternity_raw   USERNAME="$USERNAME$"  (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="Activity Response"     TRANSACTION_NAME="TN-Portabilidade"  



     | strcat USERNAME + " [" + HOSTNAME + "]"  iduser   | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE  by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]

| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe 
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
          <earliest>$timerange.earliest$</earliest>
          <latest>$timerange.latest$</latest>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">block</option>
        <option name="drilldown">all</option>
        <option name="numberPrecision">0.00</option>
        <option name="showSparkline">1</option>
        <option name="showTrendIndicator">1</option>
        <option name="trendColorInterpretation">standard</option>
        <option name="trendDisplayMode">absolute</option>
        <option name="underLabel">TN-Portabilidade</option>
        <option name="unitPosition">after</option>
        <option name="useColors">1</option>
        <option name="useThousandSeparators">1</option>
        <option name="linkView">search</option>
        <option name="classField">value</option>
        <option name="field">duration</option>
        <drilldown>
          <link>
            <![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Portabilidade&CONTAINER_NAME=Claro&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
          </link>
        </drilldown>
      </single>
      <single>
        <search>
          <query>index=aternity_raw     USERNAME="$USERNAME$"  (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="TN-Transaction Response"     TRANSACTION_NAME="TN-Ativacao de Linha Pos e Pre Pago"    



| strcat USERNAME + " [" + HOSTNAME + "]"  iduser  
| stats sum(VALUE_BASELINE) as VALUE_BASELINE by iduser ID_TRANSACAO


| join [search index=aternity_raw   USERNAME="$USERNAME$"  (CONTAINER_NAME="Claro" AND CONTAINER_NAME="$BU$")   (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="Activity Response"     TRANSACTION_NAME="TN-Ativacao de Linha Pos e Pre Pago"  



     | strcat USERNAME + " [" + HOSTNAME + "]"  iduser   | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE  by iduser ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | fields ID_TRANSACAO controle]

| stats dc(iduser) as iduser dc(ID_TRANSACAO) as ID_TRANSACAO avg(VALUE_BASELINE) as VALUE_BASELINE count(eval(controle!="Severidade Normal")) as Impactado
| eval duration=tostring(round(VALUE_BASELINE,0), "duration") + " - [" + ID_TRANSACAO + "]" + " - [" + iduser + "]" + " - [" + Impactado + "]"
| eval duration=if(isnull(duration), "--", duration)
| eval VALUE_BASELINE=if(isnull(VALUE_BASELINE), "--", VALUE_BASELINE)
| eval value=if(VALUE_BASELINE!="--", (Impactado*100)/iduser, VALUE_BASELINE)
| rangemap field=value low=0-10, elevated=11-20 default=severe 
| eval range=if(VALUE_BASELINE="--", "none", range)</query>
          <earliest>$timerange.earliest$</earliest>
          <latest>$timerange.latest$</latest>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">block</option>
        <option name="drilldown">all</option>
        <option name="numberPrecision">0.00</option>
        <option name="showSparkline">1</option>
        <option name="showTrendIndicator">0</option>
        <option name="trendColorInterpretation">inverse</option>
        <option name="trendDisplayMode">absolute</option>
        <option name="trendInterval">-1h</option>
        <option name="underLabel">TN-Ativacao de Linha Pos e Pre Pago</option>
        <option name="unitPosition">after</option>
        <option name="useColors">1</option>
        <option name="useThousandSeparators">1</option>
        <option name="linkView">search</option>
        <option name="classField">value</option>
        <option name="field">duration</option>
        <drilldown>
          <link>
            <![CDATA[/app/App_Net/prototipo?TRANSACTION_NAME=TN-Ativacao de Linha Pos e Pre Pago&CONTAINER_NAME=Claro&LOCATION=$LOCATION$&ACTIVITY_TYPE=$ACTIVITY_TYPE$&STATE=$STATE$&earliest=$timerange.earliest$&latest=$timerange.latest$]]>
          </link>
        </drilldown>
      </single>
    </panel>
  </row>
  <row>
    <panel>
      <input type="radio" token="show">
        <label>Apresentar por:</label>
        <choice value="CONTAINER_NAME TRANSACTION_NAME">BU</choice>
        <choice value="TRANSACTION_NAME CONTAINER_NAME">TN</choice>
        <default>CONTAINER_NAME TRANSACTION_NAME</default>
      </input>
      <input type="radio" token="ty" searchWhenChanged="true">
        <label>Info</label>
        <choice value="| bin _time span=5m  | rex mode=sed field=VALUE &quot;s/,/./g&quot; | eval VALUE=tonumber(VALUE) | stats avg(VALUE) as duration first(_time) as _time by TRANSACTION_NAME  CONTAINER_NAME | eval duration=duration*1000">media</choice>
        <choice value="| rex mode=sed field=VALUE &quot;s/,/./g&quot; | eval VALUE=tonumber(VALUE) | table _time TRANSACTION_NAME  CONTAINER_NAME VALUE   | rename VALUE as duration | eval duration=duration*1000">real</choice>
        <default>| bin _time span=5m  | rex mode=sed field=VALUE "s/,/./g" | eval VALUE=tonumber(VALUE) | stats avg(VALUE) as duration first(_time) as _time by TRANSACTION_NAME  CONTAINER_NAME | eval duration=duration*1000</default>
        <initialValue>| bin _time span=5m  | rex mode=sed field=VALUE "s/,/./g" | eval VALUE=tonumber(VALUE) | stats avg(VALUE) as duration first(_time) as _time by TRANSACTION_NAME  CONTAINER_NAME | eval duration=duration*1000</initialValue>
      </input>
      <viz type="timeline_app.timeline">
        <search>
          <query>index=aternity_raw   USERNAME="$USERNAME$" CONTAINER_NAME="$BU$"  (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )  STATE="$STATE$"     $TRANSACTION_NAME$ ACTIVITY_TYPE="$ACTIVITY_TYPE$"  $ty$ 


 | fields _time  $show$ duration</query>
          <earliest>$timerange.earliest$</earliest>
          <latest>$timerange.latest$</latest>
        </search>
        <option name="timeline_app.timeline.useColors">1</option>
        <option name="timeline_app.timeline.colorMode">categorical</option>
        <option name="timeline_app.timeline.numOfBins">3</option>
        <option name="timeline_app.timeline.maxColor">#DA5C5C</option>
        <option name="timeline_app.timeline.minColor">#FFE8E8</option>
        <option name="timeline_app.timeline.axisTimeFormat">SECONDS</option>
        <option name="timeline_app.timeline.tooltipTimeFormat">SUBSECONDS</option>
      </viz>
    </panel>
  </row>
  <row>
    <panel>
      <html>
        <h1 align="center"> SLA </h1>
  </html>
    </panel>
  </row>
  <row>
    <panel>
      <viz type="horseshoe_meter_app.horseshoe_meter">
        <title>Disponibilidade CABO</title>
        <search>
          <query>index=aternity_raw  USERNAME="$USERNAME$"   ACTIVITY_TYPE=Availability      (CONTAINER_NAME="NetSMS")    (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )  STATE="$STATE$"         | stats count(eval(VALUE_BASELINE=0.0)) as Disponivel count(eval(VALUE_BASELINE>0)) as Indisponivel   | eval percent=round((Disponivel*100)/(Disponivel+Indisponivel),2)  | eval percent=if(isnull(percent), "0.0", percent)  | fields percent</query>
          <earliest>$timerange.earliest$</earliest>
          <latest>$timerange.latest$</latest>
        </search>
        <option name="horseshoe_meter_app.horseshoe_meter.backgroundColor">#fff</option>
        <option name="horseshoe_meter_app.horseshoe_meter.dialColor">#d93f3c</option>
        <option name="horseshoe_meter_app.horseshoe_meter.valueColor">#555</option>
        <option name="horseshoe_meter_app.horseshoe_meter.minValue">0</option>
        <option name="horseshoe_meter_app.horseshoe_meter.maxValue">100</option>
        <option name="horseshoe_meter_app.horseshoe_meter.useRangemap">true</option>
        <option name="horseshoe_meter_app.horseshoe_meter.thresholdStyle">realValue</option>
        <option name="horseshoe_meter_app.horseshoe_meter.minRangeColor">#d93f3c</option>
        <option name="horseshoe_meter_app.horseshoe_meter.midRangeColor">#d93f3c</option>
        <option name="horseshoe_meter_app.horseshoe_meter.midRangeThreshold">80</option>
        <option name="horseshoe_meter_app.horseshoe_meter.maxRangeColor">#65a637</option>
        <option name="horseshoe_meter_app.horseshoe_meter.maxRangeThreshold">99.5</option>
        <option name="horseshoe_meter_app.horseshoe_meter.caption">SLA %</option>
      </viz>
    </panel>
    <panel>
      <viz type="horseshoe_meter_app.horseshoe_meter">
        <title>Disponibilidade DTH</title>
        <search>
          <query>index=aternity_raw  USERNAME="$USERNAME$"   ACTIVITY_TYPE=Availability      (CONTAINER_NAME="VSMS")    (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )  STATE="$STATE$"         | stats count(eval(VALUE_BASELINE=0.0)) as Disponivel count(eval(VALUE_BASELINE>0)) as Indisponivel   | eval percent=round((Disponivel*100)/(Disponivel+Indisponivel),2)  | eval percent=if(isnull(percent), "0.0", percent)  | fields percent</query>
          <earliest>0</earliest>
          <latest></latest>
        </search>
        <option name="horseshoe_meter_app.horseshoe_meter.backgroundColor">#FFF</option>
        <option name="horseshoe_meter_app.horseshoe_meter.dialColor">#555</option>
        <option name="horseshoe_meter_app.horseshoe_meter.valueColor">#555</option>
        <option name="horseshoe_meter_app.horseshoe_meter.minValue">0</option>
        <option name="horseshoe_meter_app.horseshoe_meter.maxValue">100</option>
        <option name="horseshoe_meter_app.horseshoe_meter.useRangemap">true</option>
        <option name="horseshoe_meter_app.horseshoe_meter.thresholdStyle">percentage</option>
        <option name="horseshoe_meter_app.horseshoe_meter.minRangeColor">#d93f3c</option>
        <option name="horseshoe_meter_app.horseshoe_meter.midRangeColor">#d93f3c</option>
        <option name="horseshoe_meter_app.horseshoe_meter.midRangeThreshold">80</option>
        <option name="horseshoe_meter_app.horseshoe_meter.maxRangeColor">#65a637</option>
        <option name="horseshoe_meter_app.horseshoe_meter.maxRangeThreshold">99.5</option>
        <option name="horseshoe_meter_app.horseshoe_meter.caption">SLA %</option>
      </viz>
    </panel>
    <panel>
      <viz type="horseshoe_meter_app.horseshoe_meter">
        <title>Disponibilidade Móvel</title>
        <search>
          <query>index=aternity_raw  USERNAME="$USERNAME$"   ACTIVITY_TYPE=Availability      (CONTAINER_NAME="Claro")    (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )  STATE="$STATE$"         | stats count(eval(VALUE_BASELINE=0.0)) as Disponivel count(eval(VALUE_BASELINE>0)) as Indisponivel   | eval percent=round((Disponivel*100)/(Disponivel+Indisponivel),2)  | eval percent=if(isnull(percent), "0.0", percent)  | fields percent</query>
          <earliest>0</earliest>
          <latest></latest>
        </search>
        <option name="horseshoe_meter_app.horseshoe_meter.backgroundColor">#FFF</option>
        <option name="horseshoe_meter_app.horseshoe_meter.dialColor">#555</option>
        <option name="horseshoe_meter_app.horseshoe_meter.valueColor">#555</option>
        <option name="horseshoe_meter_app.horseshoe_meter.minValue">0</option>
        <option name="horseshoe_meter_app.horseshoe_meter.maxValue">100</option>
        <option name="horseshoe_meter_app.horseshoe_meter.useRangemap">true</option>
        <option name="horseshoe_meter_app.horseshoe_meter.thresholdStyle">percentage</option>
        <option name="horseshoe_meter_app.horseshoe_meter.minRangeColor">#d93f3c</option>
        <option name="horseshoe_meter_app.horseshoe_meter.midRangeColor">#65a637</option>
        <option name="horseshoe_meter_app.horseshoe_meter.midRangeThreshold">80</option>
        <option name="horseshoe_meter_app.horseshoe_meter.maxRangeColor">#65a637</option>
        <option name="horseshoe_meter_app.horseshoe_meter.maxRangeThreshold">99.5</option>
        <option name="horseshoe_meter_app.horseshoe_meter.caption">SLA %</option>
      </viz>
    </panel>
    <panel>
      <viz type="horseshoe_meter_app.horseshoe_meter">
        <title>Disponibilidade Geral</title>
        <search>
          <query>index=aternity_raw  USERNAME="$USERNAME$"   ACTIVITY_TYPE=Availability      (CONTAINER_NAME="*")    (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )  STATE="$STATE$"         | stats count(eval(VALUE_BASELINE=0.0)) as Disponivel count(eval(VALUE_BASELINE>0)) as Indisponivel   | eval percent=round((Disponivel*100)/(Disponivel+Indisponivel),2)  | eval percent=if(isnull(percent), "0.0", percent)  | fields percent</query>
          <earliest>0</earliest>
          <latest></latest>
        </search>
        <option name="horseshoe_meter_app.horseshoe_meter.backgroundColor">#FFF</option>
        <option name="horseshoe_meter_app.horseshoe_meter.dialColor">#555</option>
        <option name="horseshoe_meter_app.horseshoe_meter.valueColor">#555</option>
        <option name="horseshoe_meter_app.horseshoe_meter.minValue">0</option>
        <option name="horseshoe_meter_app.horseshoe_meter.maxValue">100</option>
        <option name="horseshoe_meter_app.horseshoe_meter.useRangemap">true</option>
        <option name="horseshoe_meter_app.horseshoe_meter.thresholdStyle">percentage</option>
        <option name="horseshoe_meter_app.horseshoe_meter.minRangeColor">#d93f3c</option>
        <option name="horseshoe_meter_app.horseshoe_meter.midRangeColor">#d93f3c</option>
        <option name="horseshoe_meter_app.horseshoe_meter.midRangeThreshold">80</option>
        <option name="horseshoe_meter_app.horseshoe_meter.maxRangeColor">#65a637</option>
        <option name="horseshoe_meter_app.horseshoe_meter.maxRangeThreshold">99.5</option>
        <option name="horseshoe_meter_app.horseshoe_meter.caption">SLA %</option>
      </viz>
    </panel>
  </row>
  <row>
    <panel>
      <viz type="horseshoe_meter_app.horseshoe_meter">
        <title>Performance CABO</title>
        <search>
          <query>index=aternity_raw  USERNAME="$USERNAME$"    (CONTAINER_NAME="NetSMS")        (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="Activity Response"  $TRANSACTION_NAME$   | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE by ID_TRANSACAO | eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | top controle | search controle="Severidade Normal" | eval percent=round(percent,2)   | fields percent</query>
          <earliest>0</earliest>
          <latest></latest>
        </search>
        <option name="charting.chart">radialGauge</option>
        <option name="horseshoe_meter_app.horseshoe_meter.backgroundColor">#FFF</option>
        <option name="horseshoe_meter_app.horseshoe_meter.dialColor">#d0d5d9</option>
        <option name="horseshoe_meter_app.horseshoe_meter.valueColor">#555</option>
        <option name="horseshoe_meter_app.horseshoe_meter.minValue">0</option>
        <option name="horseshoe_meter_app.horseshoe_meter.maxValue">100</option>
        <option name="horseshoe_meter_app.horseshoe_meter.useRangemap">true</option>
        <option name="horseshoe_meter_app.horseshoe_meter.thresholdStyle">realValue</option>
        <option name="horseshoe_meter_app.horseshoe_meter.minRangeColor">#d93f3c</option>
        <option name="horseshoe_meter_app.horseshoe_meter.midRangeColor">#f7bc38</option>
        <option name="horseshoe_meter_app.horseshoe_meter.midRangeThreshold">80.1</option>
        <option name="horseshoe_meter_app.horseshoe_meter.maxRangeColor">#65a637</option>
        <option name="horseshoe_meter_app.horseshoe_meter.maxRangeThreshold">90.1</option>
        <option name="horseshoe_meter_app.horseshoe_meter.caption">SLA %</option>
      </viz>
    </panel>
    <panel>
      <viz type="horseshoe_meter_app.horseshoe_meter">
        <title>Performance DTH</title>
        <search>
          <query>index=aternity_raw  USERNAME="$USERNAME$"    (CONTAINER_NAME="VSMS")        (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="Activity Response"  $TRANSACTION_NAME$   | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE by ID_TRANSACAO | eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | top controle | search controle="Severidade Normal" | eval percent=round(percent,2)   | fields percent</query>
          <earliest>0</earliest>
          <latest></latest>
        </search>
        <option name="charting.chart">radialGauge</option>
        <option name="horseshoe_meter_app.horseshoe_meter.backgroundColor">#FFF</option>
        <option name="horseshoe_meter_app.horseshoe_meter.dialColor">#d0d5d9</option>
        <option name="horseshoe_meter_app.horseshoe_meter.valueColor">#555</option>
        <option name="horseshoe_meter_app.horseshoe_meter.minValue">0</option>
        <option name="horseshoe_meter_app.horseshoe_meter.maxValue">100</option>
        <option name="horseshoe_meter_app.horseshoe_meter.useRangemap">true</option>
        <option name="horseshoe_meter_app.horseshoe_meter.thresholdStyle">realValue</option>
        <option name="horseshoe_meter_app.horseshoe_meter.minRangeColor">#d93f3c</option>
        <option name="horseshoe_meter_app.horseshoe_meter.midRangeColor">#fbcd2f</option>
        <option name="horseshoe_meter_app.horseshoe_meter.midRangeThreshold">80.1</option>
        <option name="horseshoe_meter_app.horseshoe_meter.maxRangeColor">#65a637</option>
        <option name="horseshoe_meter_app.horseshoe_meter.maxRangeThreshold">90.1</option>
        <option name="horseshoe_meter_app.horseshoe_meter.caption">SLA %</option>
      </viz>
    </panel>
    <panel>
      <viz type="horseshoe_meter_app.horseshoe_meter">
        <title>Performance Móvel</title>
        <search>
          <query>index=aternity_raw  USERNAME="$USERNAME$"    (CONTAINER_NAME="Claro" )       (LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="Activity Response"  $TRANSACTION_NAME$   | stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE by ID_TRANSACAO | eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | top controle | search controle="Severidade Normal" | eval percent=round(percent,2)   | fields percent</query>
          <earliest>0</earliest>
          <latest></latest>
        </search>
        <option name="charting.chart">radialGauge</option>
        <option name="horseshoe_meter_app.horseshoe_meter.backgroundColor">#FFF</option>
        <option name="horseshoe_meter_app.horseshoe_meter.dialColor">#d0d5d9</option>
        <option name="horseshoe_meter_app.horseshoe_meter.valueColor">#555</option>
        <option name="horseshoe_meter_app.horseshoe_meter.minValue">0</option>
        <option name="horseshoe_meter_app.horseshoe_meter.maxValue">100</option>
        <option name="horseshoe_meter_app.horseshoe_meter.useRangemap">true</option>
        <option name="horseshoe_meter_app.horseshoe_meter.thresholdStyle">realValue</option>
        <option name="horseshoe_meter_app.horseshoe_meter.minRangeColor">#d93f3c</option>
        <option name="horseshoe_meter_app.horseshoe_meter.midRangeColor">#fbcd2f</option>
        <option name="horseshoe_meter_app.horseshoe_meter.midRangeThreshold">80.1</option>
        <option name="horseshoe_meter_app.horseshoe_meter.maxRangeColor">#65a637</option>
        <option name="horseshoe_meter_app.horseshoe_meter.maxRangeThreshold">90.1</option>
        <option name="horseshoe_meter_app.horseshoe_meter.caption">SLA %</option>
      </viz>
    </panel>
    <panel>
      <viz type="horseshoe_meter_app.horseshoe_meter">
        <title>Performance Geral</title>
        <search>
          <query>index=aternity_raw  USERNAME="$USERNAME$"  

(CONTAINER_NAME="*")    



(LOCATION="$LOCATION$" AND LOCATION$LOCATION2$ )    STATE="$STATE$"  ACTIVITY_TYPE="Activity Response"  $TRANSACTION_NAME$


| stats sum(VALUE_BASELINE) as VALUE_BASELINE sum(MINOR_BASELINE) as MINOR_BASELINE sum(MAJOR_BASELINE) as MAJOR_BASELINE by ID_TRANSACAO
| eval controle=case(VALUE_BASELINE < MINOR_BASELINE, "Severidade Normal", VALUE_BASELINE > MAJOR_BASELINE,"Severidade Major", VALUE_BASELINE > MINOR_BASELINE, "Severidade Minor") | top controle | search controle="Severidade Normal"
| eval percent=round(percent,2)

 | fields percent</query>
          <earliest>0</earliest>
          <latest></latest>
        </search>
        <option name="charting.chart">radialGauge</option>
        <option name="horseshoe_meter_app.horseshoe_meter.backgroundColor">#FFF</option>
        <option name="horseshoe_meter_app.horseshoe_meter.dialColor">#d0d5d9</option>
        <option name="horseshoe_meter_app.horseshoe_meter.valueColor">#555</option>
        <option name="horseshoe_meter_app.horseshoe_meter.minValue">0</option>
        <option name="horseshoe_meter_app.horseshoe_meter.maxValue">100</option>
        <option name="horseshoe_meter_app.horseshoe_meter.useRangemap">true</option>
        <option name="horseshoe_meter_app.horseshoe_meter.thresholdStyle">realValue</option>
        <option name="horseshoe_meter_app.horseshoe_meter.minRangeColor">#d93f3c</option>
        <option name="horseshoe_meter_app.horseshoe_meter.midRangeColor">#fbcd2f</option>
        <option name="horseshoe_meter_app.horseshoe_meter.midRangeThreshold">80.1</option>
        <option name="horseshoe_meter_app.horseshoe_meter.maxRangeColor">#65a637</option>
        <option name="horseshoe_meter_app.horseshoe_meter.maxRangeThreshold">90.1</option>
        <option name="horseshoe_meter_app.horseshoe_meter.caption">SLA %</option>
      </viz>
    </panel>
  </row>
</form>

Thanks!!!

0 Karma