Here is my calculated field
ifelse(
${SelectedTimespan} = ‘Day’, periodOverPeriodLastValue(sumIf({Inspection_Time},${Facility1}=Facility AND
${Modality1}=Modality AND ${Model1}={Device_Model_Name}), {date_time}, DAY, 0),
NULL
)
Modality , Facility and Device_Model_Name are fields in my dataset
The parameters are ${Modality1}, ${Facility1} and ${Model1} which are mapped with the above field
Now I am not getting “select all” option…
how it is possible…
Hide Select all option from the control values if the parameter has a default configure is untick
Hi @Edger, you can have a selection value called "All Facilities or Models,” maybe I’m not understanding the problem clearly, it should work as expected based on your description.
In case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and please create a new post, so we can look at it from a fresh perspective. (Details on using Arena can be found here - QuickSight Arena)
You could look to opening up a case with AWS and see if they can provide a solution.
Here are the steps to open a support case . If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf. Hope this helps!
Did my solution work for you, adding “all” as part of the selection value? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!
My question is I am not able to display data on selecting “select all” for a field “facility” in my data set on giving a control for a filter or a calculated field.
-----> 2
—> 1
In image 1 , I am able to display the count , when selecting facility1
whereas In image 2, when selecting “selecting all” option no data is displayed
-----> 2
—> 1