Hello Community!
I have a problem that I hope can be solved, I need to filter or create a parameter or control that ‘group’ the 6 fields that I present in the image framed or highlighted in blue, that if you observe correctly the sum of these 6 is the field ‘orders_qty_total’, my idea is to assemble a graph that only contains the values of ‘orders_qty_total’ and filter by those 6 fields. I hope my problem is solved, I look forward to your answers!
Hi @Juan,
I’m hoping to get a little further clarification on what you’re looking to achieve. Please correct if wrong, but you’re looking to create a graph that shows the overall ‘orders_qty_total’ but you want to be able to select/unselect one of the 6 variables and show how that affects your ‘orders_qty_total’ on the graph, correct?
So for example, Brazil; if you unselect the first column (which is $1,101,377, your ‘orders_qty_total’ on the graph will now show $844,257. Is that correct?
Additionally, what type of graph/visual would you like to utilize?
Thank you!
Hi @duncan
Thank you for replying!
Correct, as you suggest I am looking for the total to be modified by modifying those fields so I don’t have to use all 6 fields in a table/chart as they become very unreadable.
In the first instance I would like to try with a bar chart where I have the field ‘orders_qty_total’ let’s say in this case, following your example, that when selecting by the first column or field ‘orders_qty_delivery_inbound’ it is filtered by removing or adding this field. I would like to have a control or filter for the 6 fields, having that could generate a much more dynamic dashboard and could eliminate numerous tables.
Hi @Juan,
Thanks for the clarification! Quick Sight does not allow you to select other fields to use as control options but there is a work around that can be used here, please see below for the walkthrough:
First, you’ll need to create a parameter, feel free to name it whatever you’d prefer. Make sure you choose Multiple Values.
Second, Add a control to manage the selections. When listing the options, you can make it cleaner than the field names so that it’s easier for users to navigate
Now, we’ll need to make a calculated field that links your 6 options to the control:
ifelse(in('Delivery Inbound', ${OrderQuantityType}), orders_qty_delivery_inbound, 0)+ifelse(in('Delivery Outbound', ${OrderQuantityType}), orders_qty_delivery_outbound, 0)+ifelse(in('Onsite Inbound', ${OrderQuantityType}), orders_qty_onsite_inbound, 0)+ifelse(in('Onsite Outbound', ${OrderQuantityType}), orders_qty_onsite_outbound, 0)+ifelse(in('Takeaway Inbound', ${OrderQuantityType}), orders_qty_takeaway_inbound, 0)+ifelse(in('Takeaway Outbound', ${OrderQuantityType}), orders_qty_takeaway_outbound, 0)
Please note: The red will be your options created in the filter (so make sure spelling matches). The green will be your new parameter that was just created so make sure to use the name you use to create in case different from mine. The yellow will be each of your fields that already exist.
Last, you can use this new calculated field for your Value field on your desired graph.
Let me know if you have any additional questions or if this works for what you’re looking to accomplish.
Thank you!
1 Like
Hello @duncan
This works perfectly! I just modified the ifelse clause, so that instead of 0 the value is the field ‘orders_qty_total’, that way the control is complete. I appreciate the help, this will certainly help me to reorder my analysis and make them more synthesized and understandable.
1 Like