Its worked, great that learned mvmap and mvfind today, thanks alot ... View more

@ITWhisperer  , i discovered the solution not work correctly for below case. Product color description1 description2 phone blue location : loc_a date: date_a serial_no: serial_a extra_info_a:info_a extra_info_b:info_b location : loc_a date: date_q extra_info_a: info_c extra_info_b: info_d phone yellow location : loc_d date: date_e serial_no: serial_f location : loc_x date: date_y serial_no: serial_z     Current output: where there are mismatch of field Product color description1 description2 phone blue location : loc_a location : loc_a phone blue date:date_a date: date_q phone blue serial_no: serial_a extra_info_a: info_c phone  blue extra_info_a:info_a extra_info_b: info_d phone blue extra_info_b:info_b   phone yellow location : loc_d location : loc_x phone yellow date: date_e date: date_y phone yellow serial_no: serial_f serial_no: serial_z   Cannot figure out how to do that, would appreciate if there a clear procedure/solution i can do, thanks ... View more

Great one thanks ... View more

Nevermind, I thinks it's okay, just asking if there is a way to hide the prev_tag from line chart. If no, its still worked perfectly when i click on the point(line chart) it do 'token' the "tag_click_current_row" and "tag_click_previous_row" Thanks. ... View more

@bowesmana  One question, how do i unshow  the prev_tag when i display the table as line chart. Using syntax (<fields>["tag","score"]</fields>) do hide the prev_tag as table but actually i plan to display the table as line chart. The drilldown do function perfectly just if there any method to remove prev_tag when display it as line chart     ... View more

Great, thanks for the solution, appreciate that ... View more

@ITWhisperer  It's ok, i'm okay to edit the query | eval same=if('row 1'=='row 2' AND 'row 1' != "phone" AND 'row 1' != "blue","same","different") able to get expected outcome (1), Thanks alot ... View more

Great one, any idea to exclude product and color from the matching? or re-append product and color after the matching. ... View more

great effort but I don't get desired outcome, description1-description4 is just example, which the values are randomize, my real data have like 70 + description. btw thanks for the reply ... View more

Great one KV, one more addition question,  how do i display the product_tag i search and the one previous of it. For example: my search... | stats values(product_tag*) as product_tag* values(*) as * by product,color,product_tag |  search product_tag=abc_3  Outcome product color product_tag description phone red abc_3 blabla3   Desired outcome t color product_tag description phone red abc_2 blabla2 phone red abc_3 blabla3   really appreciate your help. ... View more

Get it, thanks for the quick reply and  great solution, really appreciate it. ... View more

hi,  for  ...... | eval _raw="product product_tag product1 A_tag1 product1 A_tag2 product1 B_tag1 product2 C_tag1 product3 D_tag1 product3 D_tag2" ...... actually my data contain of thousands of product & product tag, what should i replace this with? my table command? ... View more

ya, found a way to replace the null value with 0 and follow up with eval function, that worked too. Thanks! ... View more

Great one, really appreciate your solution. Quick and easy ... View more