Dashboards & Visualizations

"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

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

Influencer

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

State of Splunk Careers

Access the Splunk Careers Report to see real data that shows how Splunk mastery increases your value and job satisfaction.

Find out what your skills are worth!