Dynamic Values in Amazon QuickSight for Personalized Visualizations and Reports

Introduction

Amazon QuickSight is a powerful business intelligence (BI) tool that allows users to create interactive visualizations and reports. One of its key features is the ability to use dynamic values, enabling real-time updates and personalized user experiences. This blog will explore the concept of dynamic values in Amazon QuickSight and discuss how they can enhance your analytics and reporting capabilities.

Dynamic values and it’s Benefits

Dynamic values refer to the ability to change the content or behavior of a visualization or report based on certain conditions or inputs. These conditions can include user selections, parameter values, or data changes. By using dynamic values, you can create highly interactive and responsive visualizations that adapt to the context and needs of your users.

There are many benefits of using Dynamic values, such as

• It improves the user experience as it allows users to interact and choose the inputs according to their requirements
• It helps to work on the most updated information for the user
• It provides the Real-Time Dashboard, and user can work on data or any incident as they occur
• It improves the user experience by helping to create personalized reports.

Prerequisite

• AWS Account
• Amazon QuickSight Account

How to Achieve Dynamic Input in Amazon QuickSight?

To achieve Dynamic Input in Amazon QuickSight, we will use Parameters. The parameter is a feature to achieve dynamic values in SQL visuals. It consists of four Data types: String, Integer, Datetime, and Number. It also supports Multiple values along with a single value.

Step-by-Step Guide

Step 1 – Creating Parameters

Sign in to your Amazon QuickSight account, navigate to “Datasets”, and enter the dataset where you want to add the parameters.

On the left pane, there is an option for parameters. Select that, and there you will get an option to “create one” Click on that.

Give your parameter an appropriate name, choose the desired data type according to your requirement, and give the default value to it. Once all the configuration is done, click on the Create button.

Once parameters are created now, we need to use them inside the query so that they can be used. Replace the hard coded value from your query with the parameter value. Below is the syntax for declaring the parameter inside the query.

(<<$parameter_name>>)

Note: Here, we are using timestamp as a dynamic input.

Now apply the changes and save, publish, or visualize your dataset.

Now we will move to the analysis for further implementation to use it to give the dynamic values.

Step 2 – Using parameters in Visualization

Under analysis, go to the Parameters, click on three dots under the parameters we created in the above steps, and click on Create new under map parameter.

In the popup box, give an appropriate name, and select time granularity. Here, you can select a fixed or relative date as a static input.

In relative date, you can use the Filter condition to customize the static date and time to be more dynamic according to your requirements.

Click on Create after filling in all the conditions.

Now to allow the user to add dynamically or inputs the value, we need to add control over the analysis. Once parameters are created, select it and click on Add control.

Now give an appropriate name to display over the analysis under control, select style and format and click on Add.

Now you can see the controls over the analysis.

Now it will display the result for the selected timeframe from the controls.

Precaution

The user must remain cautious while giving the input as if the inputs are not aligned properly, and it can show invalid inputs or no data found errors.

Conclusion

Amazon QuickSight’s Dynamic Values are one of the most powerful features provided by Amazon QuickSight. It revolutionizes how users interact with data and enhances personalization, Interactiveness and improves the responsiveness of the visualizations.

Drop a query if you have any questions regarding Amazon QuickSight and we will get back to you quickly.

About CloudThat