QuickSight does not capture tags into the visuals

Question & Answer
1

Hi team,

I’m an AWS CS employee working on a POC for my team using QuickSight as the most feasible solution for the POC. While working with the code and trying to pull/capture data into the visuals through tags, there is something not being captured correctly leading to the data/visual being inaccurate. I’m not really familiar with all of the Quicksight capabilities and specifics, so I’m trying to understand if there is something wrong with the code of the service.

Happy to provide the details of the code if needed.

Thanks,

2

Can you give some examples of how it is off?

3

Hi Max,

Thanks for taking a look into this inquiry, please see the details below and the image attached for reference.

Reference 1
Reference 1906×430 23 KB

This is the code I’m using to capture the tags:

ifelse(locate({Tags},“CANADA”)>0,“CANADA”,

ifelse(locate({Tags},“CANADA SUP”)>0,“CANADA SUP”,

ifelse(locate({Tags},“DNB”)>0,“DNB”,

ifelse(locate({Tags},“GAMES”)>0,“GAMES”,

ifelse(locate({Tags},“ISV”)>0,“ISV”,

ifelse(locate({Tags},“LATAM”)>0,“LATAM”,

ifelse(locate({Tags},“LATAM SUP”)>0,“LATAM SUP”,

ifelse(locate({Tags},“SMB”)>0,“SMB”,

ifelse(locate({Tags},“US CENTRAL”)>0,“US CENTRAL”,

ifelse(locate({Tags},“US EAST”)>0,“US EAST”,

ifelse(locate({Tags},“US GF”)>0,“US GF”,

ifelse(locate({Tags},“US SUP1”)>0,“US SUP1”,

ifelse(locate({Tags},“US SUP2”)>0,“US SUP2”,

ifelse(locate({Tags},“US SUPGF”)>0,“US SUPGF”,

ifelse(locate({Tags},“US WEST”)>0,“US WEST”,

ifelse(locate({Tags},“ANZ”)>0,“ANZ”,

ifelse(locate({Tags},“ASEAN”)>0,“ASEAN”,

ifelse(locate({Tags},“INDIA”)>0,“INDIA”,

ifelse(locate({Tags},“KOREA”)>0,“KOREA”,

ifelse(locate({Tags},“BENELUS”)>0,“BENELUX”,

ifelse(locate({Tags},“CEE”)>0,“CEE”,

ifelse(locate({Tags},“DACH”)>0,“DACH”,

ifelse(locate({Tags},“FR”)>0,“FR”,

ifelse(locate({Tags},“IBERIA”)>0,“IBERIA”,

ifelse(locate({Tags},“ISRAEL”)>0,“ISRAEL”,

ifelse(locate({Tags},“ITALY”)>0,“ITALY”,

ifelse(locate({Tags},“MENAT”)>0,“MENAT”,

ifelse(locate({Tags},“NORDICS”)>0,“NORDICS”,

ifelse(locate({Tags},“SSA”)>0,“SSA”,

ifelse(locate({Tags},“UKIR”)>0,“UKIR”,

ifelse(locate({Tags},“AUTOMFG”)>0,“AUTOMFG”,

ifelse(locate({Tags},“ENERGY”)>0,“ENERGY”,

ifelse(locate({Tags},“GFS”)>0,“GFS”,

ifelse(locate({Tags},“GLOBAL”)>0,“GLOBAL”,

ifelse(locate({Tags},“GSI”)>0,“GSI”,

ifelse(locate({Tags},“HOUSE”)>0,“HOUSE”,

ifelse(locate({Tags},“LSC”)>0,“LSC”,

ifelse(locate({Tags},“STRATEGIC”)>0,“STRATEGIC”,

ifelse(locate({Tags},“TELCO”)>0,“TELCO”,

ifelse(locate({Tags},“JAPN”)>0,“JAPN”,

ifelse(locate({Tags},“CHINA”)>0,“CHINA”,“EDIT”

)))))))))))))))))))))))))))))))))))))))))

4

And you tags field has all of these tags?

Also something to note,

ifelse(locate({Tags},“CANADA”)>0,“CANADA”,

ifelse(locate({Tags},“CANADA SUP”)>0,“CANADA SUP”,

Will always return CANADA because the first expression finds CANADA in both and an ifelse goes in order.

What exactly is off? Is it that the groupings are not correct?

Can you just put in {Tags} as your color instead of this ifelse statement.