A Data Analyst has the following chart that shows the number of song downloads per year since the release of the song.
The required result is a cumulative progression of downloads across the years.
Which quick table calculation should the analyst use?
You have a Tableau Prep flow that joins a dataset named Global Indicators to a dataset named Price Indices.
In which step can you transform rows of monthly data into rows of yearly data ' '
In a dataset, a Data Analyst has a string field named Category that contains unnecessary trailing spaces.
Which function should the analyst use to remove the trailing spaces from the Category field?
You are creating a new dashboard.
You need to add a button to the dashboard that allows users to export the dashboard as an image.
Which type of object should you use?
You have a dataset that contains sates data. The following is a sample of the data.
You need to return a value of true if a month has sales greater than $50 000. otherwise the formula must return a value of false.
Which two formulas achieve the goal Choose two
You need to change the values of a dimension without creating a new field.
What should you do?
You have the following view.
You want to filter the view lo show only records that have a movie name starting with the word. " The " . You must achieve the goal without writing any formulas.
Which type of filter should you use?
A Data Analyst has a data source that contains the following columns:
he analyst has the following FIXED Level of Detail (LOD) expression called Region Sales:
{ FIXED [Region] : SUM([Sales] ) }
The analyst has a view that has a dimension filter on the State column to exclude five states.
What should the analyst do to ensure the five states are also excluded from the LOD expression?
A Data Analyst at a coffee company has the following visualization already built.
The analyst wants to make this more visually appealing by coloring the bars based on whether they are above or below the Average Sales within each Product Type.
Which calculation should the analyst use to calculate the Average Sales for each Product Type?
A Data Analyst has the following dataset:
The analyst wants to create a new calculated dimension field named Category that meets the following conditions:
When Subject is Computer Science or Science, the Category must be Sciences.
When Subject is English or Social Studies, the Category must be Humanities.
Which two logical functions achieve this goal? (Choose two.)
