PARAMETER ACTION + SHEET ACTION
Parameter Action + Sheet Action: Extended Tableau Interactivity
Tableau has included lots of sought-after features into its latest release, Tableau 2019.2. If you’ve been eagerly looking forward to the release of the latest Tableau version to try out the whole new Parameter Actions, well – the wait is over!
In our previous blog post about Tableau 2019.2, we had already covered some of the major features of the release. In this blog, we will be diving deep into ‘parameter action’ and the combination of Parameter Action + Sheet Action with a simple example using Sample-Superstore dataset.
What are Parameter Actions?
Parameters are constant values created by a user to perform certain functions in Tableau and can be used in calculations, reference lines and some other analytic scenarios. A parameter can be a set of strings, numbers, etc. With parameter, the user can able to select only one value at a time.
With parameter actions, users have the option to control the parameter values dynamically when clicking or hovering on certain elements on a viz. We can use parameter actions in a worksheet or a dashboard which extends the interactive ability of Tableau. This enables the users to visually change the parameter value with few interactions, which is cool. Parameter action can unleash the possibilities for designers to come up with new levels of interactivity to the dashboards.
Steps to achieve Parameter Action + Sheet Action:
1. First, create the sheets of required KPIs. We have created 4 sheets;
- Sales Trend
- Number of Customers
- Sales by Segment
- Quantity Vs. Sales




2. Create a Year calc from ‘Order Date’ field.
3. Create a parameter using ‘Year’ calculated field. (This parameter is used in Parameter Action)
4. Create a calculated field ‘Parameter Calc’ which is used to color/highlight the selected year.
5. Drag the ‘Parameter Calc’ to Color and Size in marks shelf.
6. If you apply ‘Parameter Calc’ to the created sheet, it will look something like this. The selected year in ‘Year Parameter’ will be highlighted with the color and size.
7. Now, we need a toggle to switch between years. So, we have to create a sheet like below,
(Like before, drag the ‘Parameter Calc’ to color and size in marks shelf)
8. Arrange the sheets in a dashboard. Give a header and format the texts, fonts, colors if required.
9. How to create ‘Parameter Action’
- Select Dashboard > Actions.
- In the Actions dialog box, click Add Action and then select Change Parameter.
- Select ‘Year Toggle’ as Source sheet and choose ‘Select’ in Run action on:
- Select ‘Year Parameter’ as Target Parameter.
- Now, if you select a year, the parts in the sheet corresponding to the selected year will get highlighted in color and other parts are grayed out.
10. How to create ‘Sheet Action’
- Select Dashboard > Actions.
- In the Actions dialog box, click Add Action and then select Filter.
- Select ‘Year Toggle’ as Source sheet and all the sheets in the dashboard as Target Sheets
- Choose ‘Select’ in Run action on and choose ‘Show all values’ in Clearing the selection will
Now, we have set both Parameter Action and Sheet Action for ‘Year Toggle’ sheet.
If we single click on the year, it will highlight (Parameter Action) the year throughout the dashboard and if we double click on the year, it will filter out (Sheet Action) that particular year throughout the dashboard.
Beinex is a digital transformation organization en-rooted with ideas, innovation and unparalleled customer service. Our mission is to transform the way individuals and the organizations work with the data through innovation and experience.
If you are interested in learning more about the latest Tableau parameter actions and use cases, please contact us at training@beinex.com/ info@beinex.com
and we would be happy to schedule a Tableau demo or training for you and your company.
Related Articles
Tableau Cloud Manager
Tableau Cloud Manager is an enhancement to Tableau Cloud that allows customers to create and manage multiple Tableau sites with centralized management of licenses and users. Tableau Cloud Manager simplifies the expansion and administration of your cloud analytics environment, helps ensure you meet governance and data residency requirements and introduces new administrative efficiencies. The highlights of Tableau Cloud Manager are: 1. Expand analytics across your organization with multiple Tableau Cloud sites Tableau Cloud Manager enables Tableau Cloud customers to create and manage multiple sites in a single deployment. Additionally, Tableau Cloud Admins can deploy these sites in the regions of their choice. This functionality is particularly beneficial for global organizations with geographically dispersed teams. By allowing for the establishment of region-specific sites, Tableau Cloud Manager enables tailored analytics experiences that cater to the unique needs and compliance requirements of every team in your organization. Your Tableau Cloud edition determines site limits: • Tableau Cloud (standard): up to 3 sites • Tableau Cloud Enterprise: up to 10 sites • Tableau+: up to 50 sites 2. Effectively manage multi-site deployments Tableau Cloud Manager acts as a layer atop your Tableau Cloud sites, offering centralized management features that help you scale your analytics operations. Customers who deploy multiple sites can manage sites and license users in one place, including granting users access to multiple sites without requiring distinct licenses for each site. 3. Enhance governance with a new Cloud Admin role Tableau Cloud Manager also introduces a new Cloud Admin role, a level above the traditional Site Admin. This allows for more flexibility in how your organization manages and governs your analytics environment based on your unique needs. A smaller organization may employ the same person as a Cloud Admin and a Site Admin. For larger organizations, your Cloud Admin could be someone in IT using higher-level administrative capabilities to implement more control and coordination across your Tableau Cloud sites.
Multiple External Identity Providers on a Site
You can now enable up to 20 identity providers on a single Tableau Cloud site. This feature allows administrators to offer secure access to external users, internal users, and partners. By using multiple identity providers, you can achieve site consolidation and simplify access for both internal and external users throughout the organization.
Table Viz Extension
Transform traditional reporting into visual analytics while addressing your users' needs. Tables are essential visualizations for analysts, allowing them to examine data as text and convey detailed information at a granular level. The Table Viz Extension, developed and maintained by Tableau, enables you to incorporate detailed tables and grid views into your dashboards for users who favor traditional reporting formats. You can load this new visualization type into your marks card, configure new columns by dragging fields onto the card, and interact with the table directly for customization.
Spatial Parameters
Tableau 2024.3 introduces the full Tableau experience for geospatial data with the support of Spatial Parameters. In addition to the standard parameter types (such as string and integer), authors can now choose a “Spatial” type. These parameters create rich, interactive dashboards that allow you to ask and answer questions about geospatial information. The Spatial type enables the parameter to capture spatial geometries—points, lines, and polygons representing locations, paths, and regions. With Spatial Parameters, end users can select individual points, which are then passed as input into calculations, facilitating dynamic behavior based on their selections. This functionality is similar to existing parameter behavior but is now extended to include spatial objects. Read more about spatial parameters: https://beinex.com/topics/spatial-parameters-enhancing-geospatial-analysis-and-adding-interactivity-to-your-maps/
Display Data Model for Published Data Sources
Gain a visual understanding of how tables within your data model are related to Published Data Sources. You can view the relationships between tables and fields in Tableau by simply clicking on the Data Source pane in a Tableau workbook. By enabling analysts to see and comprehend how tables in the data model are interconnected in Published Data Sources, they can confidently create accurate visualizations with a clear understanding of the data model's semantics.
Tableau Cloud App for Microsoft Teams
The new Tableau Cloud App for Microsoft Teams allows users to seamlessly integrate data-driven insights into their daily workflows, resulting in faster and more efficient decision-making. This integration enables real-time data sharing, making it easy for users to share their favorite Tableau dashboards and Pulse metrics without leaving Teams—in personal apps, messages, channels, and meetings. From there, they can analyze and share their insights in a message or channel. Pinned channel content is also available to explore in Teams meetings, providing a fully interactive experience. This promotes a more data-driven culture by ensuring everyone can collaborate effectively with access to the same data and analytics.
Image source: https://www.tableau.com/products/new-features
How Beinex Can Assist You
Beinex, a premier Tableau partner, offers sustainable analytics solutions to organizations and enhances their internal data visualization capabilities through customized training programs. Our team of Tableau-certified consultants consists of experienced Tableau business users who are passionate about the platform and committed to delivering an exceptional experience. Connect with us to embrace transformation: https://www.beinex.com/free-tableau-software/


. A farmer must be knowledgeable about soil, climate, and market. If something goes wrong with any of these areas the result will be devastating. This is where one of mankind’s biggest inventions, the Internet, offers the most reliable assistance. The Internet of Things has a plethora of devices that can make the work of a farmer far easier and more productive.
Smart Sensors
Smart sensors are the number one in a huge list of IoT devices being used in agriculture. These devices can be used to gather data about various aspects of agriculture like the humidity, acidity or mineral contents of the soil. Earlier these kinds of knowledge were something that farmers were supposed to gain after many years of experiences of both gain and loss. Or they had to depend on time taking and distant laboratories. But even a lab test had a limited chance of being hundred percent accurate as the soil’s quality could change in the blink of an eye. Smart sensors can provide the farmer with accurate data in real time. The data collected can precisely calculate and predict many changing or evolving aspects like the humidity content of the soil. These data can help decide:
- The crops to be planted
- The manures to be used
- The amount and timing of watering
- The market price for the final product
Drones
Next in the line is the use of drones. These can be used to:
- Observe vast areas and collect important information that can help decide the most efficient methods of cultivation.
- Provide the farmer with a bird’s eye view, thereby reducing the time and effort wasted in surveying the land personally.
- Assist in remote application of pesticides and herbicides.
- Track the cattle or scrutinize their health.
The data collected by sensors and drones can be used to create a plan through which the farmers can guarantee a good output with minimum input and loss. This will reduce a great percentage of both financial and manual investment. Besides, instead of depending on one’s gut feelings, a farmer can take a multitude of important decisions with scientifically backed technology. IoT devices can be easily operated by the farmers by connecting it to a laptop or mobile phone. There are various apps that are already very popular for providing agricultural data. There are also various government backed projects aimed at collection of data, providing online solutions and even arranging financial support for the smart framer.
Smart Greenhouses
Another IoT contribution is Smart Greenhouses. Greenhouses always contain plants which are out of their natural habitat and therefore need extra care. IoT enabled greenhouses can help:
- Monitor the procedures of watering
- Adjust the humidity inside
- Analyse and provide proper lighting
- Ensure proper balance in delicate matters like the level of carbon dioxide, temperature, etc.
- In disease control by providing a close watch on all the plants’ vitals.
Such precise and high level of attention makes sure that there is no contamination in the greenhouse environment that could lead to spread of diseases. It can also help in detection or prevention of theft, which is a big risk especially if the plants are of rare or protected species.
Livestock Management
IoT in livestock management is bringing about revolutionary changes. With the spread of COVID-19, it is now a very crucial requirement that the livestock are healthy throughout their life. Even a small disease in the animal could turn out to be dangerous for the human who finally consumes it. Also spread of diseases in small animals like poultry can lead to devastatingly large loss for the farmer. Smart devices can help:
- Track the vitals of each animal or bird through devices which are wearable.
- Alert the farmer of even slight variations in the vitals via SMS, notifications, etc.
- Administer medicines at the correct time, to any number of animals without having to keep manual tabs
All these crucial routines help in keeping diseases in check and thus reduce livestock loss.
There are many more IoT powered devices that are revolutionizing the field of livestock management like Geo-tagging and Geo-fencing.
- Geo-tagging: It is used to locate the cattle that has strayed away from the herd or gone missing. Geo-tags are especially useful in case of natural calamities like flood, tsunami, landslide, etc. For example, the farmers of Kerala in South India used geo-tags to locate their animals that had either gone missing or died in the flood of 2018.
- Geo-fencing: It is another popular method and it uses GPS to monitor and keep the cattle within a boundary without actual fencing. This can help in detecting cattle theft or even wild animal attacks on the livestock.
The Limitations and Solutions
IoT is already here to stay in the fields of agriculture, and there is more to come. But like anything else IoT in agriculture has certain cons. These limitations can thankfully be eliminated.
| Limitations | Solutions |
|---|---|
| The data that is being collected by the various devices is stored on cloud. So the farmers are required to have a basic know-how of data analyzing and even device maintenance. |
|
| IoT devices need a lot of investment and the farmers might find it difficult to find funds for them. |
|
| Another area that requires improvement is the availability of fast internet connectivity. Internet is still something expensive or even unavailable in many parts of the world. There are places too remote to have net access. | These limitations are being dealt with and hopefully can be improved with the help of technologies like space-based internet systems. |
The Future
The agriculture IoT market is estimated to grow from USD 11.4 billion in 2021 to USD 18.1 billion by 2026 at a CAGR of 9.8% during 2021-2026, as per ResearchAndMarkets.com.
A few insights can be:
- Precision Aquaculture: The agriculture IoT market for the precision aquaculture application segment is projected to register the higher CAGR during the forecast period, by application. Increasing demand for real-time tracking of fishing activity is the major reason behind the high growth of the agriculture IoT market in aquaculture farm monitoring applications.
- Production Planning: The production planning stage segment of the agriculture IoT market is estimated to register the largest market share in 2026, by the farm production planning stage.
- Small Farm Segment: The agriculture IoT market for small farm segment is projected to register the higher CAGR during the forecast period, by farm size. Small farms are expected to adopt automation and other advanced technologies at the highest rate in the coming years due to the reducing cost of farm automation equipment and advancements in technology that make it more feasible to deploy automation tools even on smaller farms to achieve high returns on investments.
- Automation & Control Systems: The automation and control systems for the precision farming hardware segment of the agriculture IoT market is estimated to register the largest market share in 2026, by hardware type. The increasing demand for drones/unmanned aerial vehicles (UAVs) is a major reason behind the high growth of the market for automation and control systems.
APAC is likely to be the fastest-growing agriculture IoT market during the forecast period. Agriculture IoT techniques are expected to be adopted at a high rate in the region. This region consists of emerging countries such as India, China, and countries in Southeast Asia. Rapidly growing population, availability of arable land, and strong government support for farmers through subsidies in these regions are the major factors driving the adoption of agriculture IoT technologies in APAC.
These projections show that IoT based agriculture is here to make a big splash and is a boon of science.

The concept of a sovereign cloud is not novel at all. Due to shifts in the geopolitical landscape and new legislations that have affected data control, it has recently become a hot topic. In a sense, the sovereign cloud offers a clever answer to a global conflict over digital sovereignty. Let’s delve a little further into it
The need for cloud sovereignty has, in turn, initiated the idea of digital sovereignty. This is all about data: who controls it, where it resides, and where it flows to. These inquiries are crucial in the modern data economy, where data is the new currency. Cloud services inevitably receive attention. They serve as the data economy's driving force.
The rules set for data sovereignty have been in place for several years in many nations, and new privacy laws like the General Data Protection Regulation (GDPR) emphasise their importance. For instance, countries like Russia, China, Germany, France, Indonesia, and Vietnam demand that citizen data be kept on servers within the country. The justification is that protecting citizens' personal information from misuse is in their best interests, especially outside a country's jurisdiction.
According to reports, global spending on cloud services is anticipated to reach $1.3 trillion by 2025, representing a growth rate of almost 17% annually. The pandemic's push to move more operations to the cloud to accommodate an increase in the demand for remote work is undoubtedly accelerating this growth.
But lately, cloud sovereignty is under closer scrutiny as enterprises and governments work to reduce their external exposure and maintain control over crucial resources in the light of escalating international conflicts, evolving data protection laws, and the dominance of certain cloud operators.
What can decision-makers do to manage this complex issue? Reports suggest a four-point plan; define, assess, align, and develop: 1. Define: Examine cloud service providers from the perspective of sovereignty, considering data sovereignty (for data residency, controls, transparency, storage, backups, etc.), operational sovereignty (for security, compliance, and operational resilience), and technical sovereignty (to evaluate integration, migration features, and a straightforward exit policy/ process). 2. Assess: Set up your cloud infrastructure to be flexible: choose the most practical of use cases and sensitive workloads; think about crucial management solutions and end-to-end encryption. 3. Align: Analyse hybrid options simultaneously and prepare for a multi-cloud architecture by being aware of its advantages and disadvantages. 4. Develop: Explore the value proposition of sovereign cloud in terms of trust, security, and cooperation through ecosystem engagement to maximise its potential.Data sovereignty in the cloud reveals a complex environment; thus, it is wise for businesses to be informed and compliant. Here are three strategies or approaches for doing this.
1.Focus on the cloudMaybe the answer to data sovereignty is in the cloud itself! Data sovereignty is an essential factor, even while the major cloud providers, such as AWS, Microsoft, and others, credit adoption rates based on customers' focus on price, availability, and flexibility. Most IaaS providers have local data centres, allowing for the fulfilment of the first condition. Additionally, crucial features like encryption and other available security-as-a-service choices enable users to adhere to regional laws.
One critical note of caution: It is crucial that the appropriate enterprise stakeholder comprehends the data protection laws of each country and evaluates and applies the required management tools provided by each supplier to comply with these laws.With the rise of the Chief Data Officer (CDO), the company now has a responsible individual who must make sure the cloud provider has responses to the following questions in the contract:
- Regulations governing privacy compliance being followed
- Optionality for data location and recommendations based on performance, cost, and compliance; and
- Methods for data encryption, key management, backups, and recovery
Businesses should consistently follow even the most burdensome of regulations. Maintaining compliance with the data sovereignty regulations of each region in which an organisation conducts business is a constant problem for organisations with a worldwide presence.
The strongest of these regulations should be applied uniformly throughout all regions, regardless of what other areas require, as this will help to decrease complexity. In this, the cloud can be helpful. Choose a cloud provider that offers these features; often, the more prominent providers and those that concentrate on specific business verticals are the best.
Even the tightest restrictions cannot guarantee data security due to the growing instances of data incursions caused by breaches by third parties, such as partners, contractors, and software libraries.
Governing systems adhering to legal requirements and open to continuous policy modifications are crucial.
3.Use the cloud to implement data governanceAlthough the cloud provider might offer capabilities for data sovereignty, applying and updating policies on top of the tightest laws help limit risk. A thorough data governance strategy ensures adherence, ongoing risk assessment, and risk mitigation are always maintained. To do that, follow these five steps:
Discoverability: Define and control your cloud data. Quality control: Make sure domain and data sharing are followed. Compliance: Update policies on top of stringent regulations to help limit risk. Access: Access to administrators is monitored, automated, and managed; prompt customer, partner, and compliance responses are given. Lifecycle administration: Control the generation, distribution, storage, and deletion of data.Laws and regulations governing data sovereignty are expanding in scope and complexity daily. The use of cloud infrastructure is multiplying, and the data deluge remains unabated. Together, these three provide some significant obstacles. However, businesses can advance and maintain their lead with a small initial investment and continual process implementations.
In the future, the CDO's responsibilities will continue to change and converge with those of the CIO, CISO, chief privacy officer, legal, and other roles. The organisation will be less vulnerable to risks if it can adapt by staying ahead of the data sovereignty regulations and developing robust data governance frameworks for the cloud.
Benefits of AWS Cost Optimization
Optimizing AWS costs is a vital part of effectively utilizing AWS services. Businesses can leverage the wide array of AWS services and pricing models to learn how to optimize costs and save considerable amounts of money. AWS Cost Optimization offers several key benefits to organizations looking to manage and reduce cloud expenses while maximizing efficiency. Let's take a look at the benefits of cost optimization with AWS: Enhanced flexibility: AWS offers flexible and cost-effective purchase plans like Reserved Instances or Amazon EC2 Spot Instances, enabling businesses to select the suitable pricing models that best fit their requirements. Boosted efficiency in resource utilization: Allocate resources effectively by rightsizing your instances, identifying the optimal size for your compute workloads, selecting the right data storage and transfer options, and eliminating unused resources. This prevents overprovisioning and ensures optimal usage of available services. Increased cost savings: AWS identifies unused resources and helps businesses scale down their infrastructure, reducing cloud costs and saving big. AWS cost optimization also ensures that you pay only for what you need, enhancing the efficiency of your cloud operations. Improved budgeting and forecasting: AWS Cost Optimization gives businesses greater visibility into spending patterns, enabling them to forecast costs and create accurate and realistic budgets based on seasonal trends, historical usage patterns, and business growth projections. Increased scalability: By employing cost optimization strategies, businesses can seamlessly scale resources on demand and pay for the requirement only when needed. Optimizing costs for seasonal fluctuations, changing workloads, and business growth ensures scalability in your AWS environment.
A Quick Look into AWS Cloud Cost Optimization Tools
AWS Cost Explorer: A tool that offers insights into the cost and usage of AWS services by giving a detailed picture of AWS spending. Its benefits include: • Identifying areas where costs are optimized • Forecasting future costs • Planning and budgeting AWS costs AWS Budgets: A tool that allows users to create custom cost and usage budgets for AWS services. It enables users to take corrective action by sending alerts when cost and usage thresholds exceed. Its benefits include: • Handling AWS spend by setting and monitoring budgets • Avoiding unforeseen expenses and cost overruns • Providing suggestions for cost optimization AWS Trusted Advisor: A tool offering tailored recommendations for optimizing AWS costs, performance, and security. It is free of charge for all AWS users. Its benefits include: • Delivering actionable insights from usage data • Offering personalized recommendations from usage data • Identifying areas where costs can be lowered AWS Pricing Calculator: A tool that helps users get estimates before choosing a service and enables the assessment of calculations based on the estimates. Its benefits include: • Identifying possible areas for cost-saving • Planning budget effectively • Providing insights into the costs you expect for a service
Optimizing Cloud Costs with AWS Cost Explorer
A robust tool that enables users to visualize, analyze, and monitor AWS costs, AWS Cost Explorer offers a granular view of your AWS spending and usage. It allows you to track your spending over time, detect cost trends, and investigate specific resources to understand where the money is spent. Cost Explorer provides a detailed report on cost, usage, and Reserved Instances and a main graph that helps you drill down into costs and usage. Users can access data for up to the last thirteen months, get suggestions for RI purchases, and predict expenses for the next twelve months. Besides, Cost Explorer offers insights into user spending by identifying areas for examination. Users can also set up preconfigured views to track overall cost trends while customizing views to align with user requirements. AWS Cost Explorer has some incredible features that assist you in comprehending and managing your spending. Data Exploration: Access AWS Cost Explorer directly from the Billing and Cost Management console. With the ability to filter and group data by dimensions such as service, usage type, region, and tags, you can dive deep into specific areas and identify key cost drivers. Report Generation: Build custom reports to monitor your costs and usage trends over time. These reports can be saved and scheduled for regular updates, offering continuous insights into your spending patterns. Costs Forecasting: Leverage Cost Explorer's forecasting feature to predict future expenses based on historical data. The predictive faculty supports better budget planning and more efficient resource allocation. Businesses that do not optimize costs can face higher costs, inefficient use wastage of resources, and severe impact on profit. Therefore, AWS cost optimization is essential for utilizing cloud resources efficiently and cost-effectively, potentially saving money for businesses in the long run. The benefits of cost optimization include lowering costs, offering predictability, preventing unforeseen expenses and cost overruns, and enhancing resource utilization, which drives business growth and sustainability.













