A colleague provides you with access to a folder that contains the following files:• Sales.csv• Book1.json• Sales.tds• Export.mdbWhich file contains an extract?
HOTSPOT-You have the following chart.You want to calculate the percentage change of sales by using 2017 as the reference year to create the following chart.How should you configure the quick table calculation?
You have a sales dataset that contains the following fields.You need to analyze the average revenue per product in different regions over timeWhich two fields should be measures? (Choose two.)
In a dataset you have a string field named Name that contains unnecessary semicolons.Which function should you use to remove the semicolons from the Name field?
You have the following line chart that shows the average sales by month.Which month had the biggest increase in average sales compared to the previous month in 2019?
You have the following dashboard.Currently, the map is used as a filter that affects the data on the other sheets of the dashboard.You need to configure the dashboard to ensure that selecting a data point on the map only filters the Detail table.What should you do?
