Hello,
I want to make a rule- if “attendance rate” (integer) is null the hide the visual, if not then display.
How can I convert the field to a parameter? or maybe there is other way?
Thanks
Hello there,
I am looking into your query and will revert.
Regards,
Hello InbalK
With conditional rule, you can create a conditional statement that will hide or show a visual when a specific condition is met. See details about conditional rules here- Setting a conditional rule - Amazon QuickSight
You can pass value from a field to a parameter using parameter control.
Regards,
Hi @Adedolapo ,
I know the conditional rule, but I don’t know how to use a field as a parameter so i can use this conditional rule.. Because it seems like I can’t use fields for this conditional rule..
So how can i convert a field to a parameter? So if the field is null then use some parameter to hiding the visual with the conditional rule
Thanks!
Hello
Yes, you need a parameter for conditional rule.
Parameters are named variables that can transfer a value for use by an action or an object.
In this case you want to use the parameter to transfer a value that will render a visual based on a field.
To achieve this, you need to create a parameter and pass the value of the field to the parameter using the parameter control (Link to a dataset field).
Please note that you cannot use a null value with the conditional rule hence you need to preprocess and convert it.
Thanks,
Hi @Adedolapo ,
Is it possible to filter the parameter? I want to use data for a specific entity in the parameter, which depends on the filter.
Thanks
Hello,
Yes, you can add control to the parameter (Parameters > click the three dots > Add control).
You can use the Dropdown control style which allows you to filter the value you want to pass to the parameter.
Regards,
Hi @Adedolapo ,
I will try to explain from the beginning:
I make reports per customer, for some customers there are sections that are not relevant (no data=null) so I want to hide them automatically somehow.
For example:
I thought maybe use the Rules feature but not sure how (for example, if some metric is null then hide)
What is the best approach?
Thanks