This must be straightforward, but for the life of me I haven’t found the answer. My dataset involves store sales of different products. I want to show graphs of sales for different types of products in different stores. Stores are identified by a store id, and have a store name. Products are iden…

If you modify the dataset to add a new dataset(id to name mapping) and configure left join, it will work the same as lookup only.

Welp. The only solution I found in my timeframe was to modify the original query so that it used the store name (instead of id) as parameter. Same for products. It’s not ideal, nor efficient, but for now it’ll do.

Where do you have product ID and product name mapping available?

They’re both fields in the main product table, but the name is not a primary key field. I also tried creating a separate dataset that just had the product id and product name, but that didn’t help much with the control, because I couldn’t find a way to tell the graph, hey when this name is selected…

Control/Update graph with non-key field

Q&A

sunnynacho March 3, 2024, 11:30pm 2

Similar to this question but that one doesn’t have an answer

Topic		Replies	Views
Give control dropdown a pseudonym based on another field Q&A filters , feature-request , quick-sight , filters-controls-and-parameters , Business-Intelligence-Engineer	4	194	June 14, 2024
Dataset Parameter not propagating to dataset in filter controls Q&A developer , quick-sight , qls-community	8	128	July 22, 2024
Numeric Fields As Filter/Parameter Q&A parameters , quick-sight , filters-controls-and-parameters , calculations , Business-Intelligence-Engineer	4	119	June 13, 2024
Add control for a group filter Q&A analysis , filters , quick-sight , visuals , filters-controls-and-parameters , Business-Intelligence-Engineer	4	97	July 1, 2024
How to use a control value as a field legend name Q&A charts , quick-sight , Business-Intelligence-Engineer	11	136	August 12, 2024

Control/Update graph with non-key field

Related topics