topic Re: When using different inputs in the same dashboard, why am I getting the following error? : "duplicate values causing conflict" in Dashboards & Visualizations

When using different inputs in the same dashboard, why am I getting the following error? : "duplicate values causing conflict"

pranay04 — Tue, 05 Feb 2019 17:04:39 GMT

I need to use two different inputs in one dashboard to filter the source. One for Apache and another for JBoss:

Apache :
      <input type="dropdown" token="WebAppTok" searchWhenChanged="true">
        <label>Apache Application</label>
        <fieldForLabel>count</fieldForLabel>
        <fieldForValue>source</fieldForValue>
Jboss:
     <input type="dropdown" token="jBossAppTok" searchWhenChanged="true">
        <label>jBoss Application</label>
        <fieldForLabel>count</fieldForLabel>
        <fieldForValue>source</fieldForValue>

Both the inputs work if I use them in separate dashboards, but I want to use it in the same dashboards, but I'm getting an error saying "duplicate values causing conflict".

Anyway I can get around that?

Re: When using different inputs in the same dashboard, why am I getting the following error? : "duplicate values causing conflict"

Vijeta — Tue, 05 Feb 2019 17:10:28 GMT

Can you type your query to populate the input. Is it a dropdown?

Re: When using different inputs in the same dashboard, why am I getting the following error? : "duplicate values causing conflict"

pranay04 — Tue, 29 Sep 2020 23:05:17 GMT

It is a drop down. Below is what I am using for the inputs for apache and jboss

Apache :

Apache Application
count
source

index=apache host=xxx source=*
| search access_request!="xxx"
| WHERE NOT ( cidrmatch("10.0.0.0/8",clientip) OR cidrmatch("172.16.0.0/12",clientip) OR cidrmatch("128.121.245.0/28",clientip) OR clientip="168.143.160.133" OR clientip="168.143.160.178" OR match(access_request, "(?i).(?:jpg|gif|png|js|css|swf|ico|bmp|pdf|xml)[\?# ]") ) | replace /logs/* with * in source | replace */access.log with * in source | dedup clientip | dedup source
| table source
-15m
now

abc

jBoss:

    <label>jBoss Application</label>
    <fieldForLabel>count</fieldForLabel>
    <fieldForValue>source</fieldForValue>
    <search>
      <query>index=jboss host=*ch*prd* source= a OR source= b OR source= c

| replace /logs/* with * in source | replace */server.log with * in source | dedup source
| table sourcee
-15m
now

xyz

Re: When using different inputs in the same dashboard, why am I getting the following error? : "duplicate values causing conflict"

chrisyounger — Tue, 05 Feb 2019 18:35:09 GMT

On your search that is used to populate the dropdown, add |dedup FIELD so the search doesn't return duplicate values.

Re: When using different inputs in the same dashboard, why am I getting the following error? : "duplicate values causing conflict"

pranay04 — Tue, 05 Feb 2019 18:38:16 GMT

For both the inputs?

Re: When using different inputs in the same dashboard, why am I getting the following error? : "duplicate values causing conflict"

chrisyounger — Tue, 05 Feb 2019 18:56:56 GMT

yep thats correct

Re: When using different inputs in the same dashboard, why am I getting the following error? : "duplicate values causing conflict"

Vijeta — Tue, 05 Feb 2019 20:00:29 GMT

@chrisyoungerjds -His search queries for each dropdown show dedup source, in the comment section in question.