Treat two values as the same

user93 — Mon, 08 Jun 2020 04:25:09 GMT

Hi,

I have a scenario that is rare for me and I need help.

I have had an object receive a change to its ID value, so now it has two IDs that mean the same object. Before, I made a report just including both IDs, but now I need to deliver a report that includes other related objects with their IDs.

I want to combine the IDs so they appear as a single combined column in the table delivered with the report.

productID=abc or
productID=def or
productID=ghi OR
productID=jkl OR
productID=mno
|chart dc(person) over company by productionID

Table:

company abc , def , ghi , jkl , mno

comp1 1 3 0 5 1
comp2 2 4 0 0 0
comp3 0 0 0 0 1
comp4 4 0 0 0 1

I want the output of my table to combine productID, ghi and jkl, so that they only have one productId and it still counts the others individually.

This is the only case I do this, so I don't need a complicated lookup, I just need it to work for this one table this one time.

Re: Treat two values as the same

jpolvino — Tue, 14 Apr 2020 23:19:36 GMT

So if you want to combine productID ghi and jkl together as one, and treat the others individually, try this:

(your search)
| eval prodType=if(productID=="ghi" OR productID=="jkl","combined",productID)
| chart dc(person) AS dcPersonCount over company by prodType
| xyseries company,prodType,dcPersonCount

topic Treat two values as the same in Reporting

Treat two values as the same

Re: Treat two values as the same