lock_openFree sampleCreate Contentmedium
An analyst wants a reference line on a profit chart to follow whichever bar a viewer selects, so the chosen bar's profit becomes the reference value. The viewer should be able to click any single bar and have the reference line jump to that bar's profit. Which action configuration captures the selected bar's profit so a calculation can drive the reference line?
- AA highlight action run on Select that emphasises the chosen bar and dims the other bars on the profit chart
- BA filter action that targets the same profit chart and keeps only the selected bar after each click
- CA parameter action run on Select that passes the bar's aggregated profit into a numeric parameter the reference line usescheck_circle Correct
- DA set action that adds the selected bar to a set which a Boolean calculation then tests for membership
Understand that a parameter action passes a selected mark's value into a parameter, letting that parameter drive calculations such as a reference line. Parameter actions update a parameter with a value from the selected mark, including an aggregated measure; binding a reference line to that parameter makes the line track whatever bar the viewer selects.
Why A is wrong: A highlight action only changes mark prominence; it never stores the selected value anywhere, so a reference line calculation would have nothing to read from.
Why B is wrong: Filtering the sheet to one bar removes the other bars and still does not write the profit into a parameter, so the reference line would lose its comparison context and have no captured value.
Why C is correct: A parameter action writes the selected mark's aggregated profit into a parameter on selection, and the reference line can be defined on that parameter so it moves to the chosen bar's value.
Why D is wrong: A set action toggles set membership rather than capturing an aggregated profit number, so it cannot supply the single numeric value a reference line needs.
lock_openFree sampleCreate Contentmedium
A designer is building a dashboard where a sales map should keep a fixed size and sit on top of a worksheet, deliberately overlapping it to act as an inset. The rest of the dashboard must reflow automatically as sheets are resized. Which approach to placing the map meets this requirement?
- AAdd the map as a tiled object so it snaps into the dashboard grid alongside the other sheets.
- BPlace every sheet, including the map, inside a single horizontal tiled container so they share space.
- CAdd the map as a floating object positioned over the worksheet, leaving the remaining sheets tiled.check_circle Correct
- DSet the dashboard sizing to Automatic so the map floats above the worksheet when space runs out.
Recognise that floating objects allow fixed-position overlapping placement while tiled objects reflow within a non-overlapping grid. Tiled and floating are the two layout modes on a dashboard. Tiled items occupy a shared non-overlapping grid and resize with the layout, whereas floating items hold explicit position and size coordinates on a separate layer above the tiled content, which is the only way to overlap one sheet on another deliberately.
Why A is wrong: Tiled objects snap into a single non-overlapping grid and resize with the layout, so the map cannot overlap a worksheet or hold a fixed independent size.
Why B is wrong: A horizontal tiled container divides space side by side without overlap, so the map would push the worksheet aside rather than sit on top of it.
Why C is correct: Floating objects are placed at fixed coordinates above the tiled layer and can overlap other sheets, while the tiled sheets keep reflowing, which is exactly the inset behaviour required.
Why D is wrong: Automatic sizing only adjusts the dashboard to the window dimensions; it never converts a tiled sheet into a floating overlay, so the inset effect would not occur.
lock_openFree sampleCreate Contentmedium
A workbook contains an Overview dashboard and a Detail dashboard. A designer wants a single click on an object in the Overview to take the viewer straight to the Detail dashboard, without writing any URL and without depending on the viewer first selecting a mark. Which object should the designer add to the Overview to achieve this?
- AA navigation button object configured to open the Detail dashboardcheck_circle Correct
- BA URL action that links to the Detail dashboard's web address
- CA filter action that targets the Detail dashboard on selection
- DA show/hide button that reveals the Detail dashboard as a floating layer
Identify the navigation button as the dashboard object that moves a viewer to another sheet or dashboard on a single click without a URL. Navigation buttons are configured with a target sheet or dashboard and switch the displayed view on click, which is exactly inter-dashboard navigation that needs no URL and no prior mark selection.
Why A is correct: A navigation button is purpose-built to move the viewer to a chosen sheet or dashboard on a single click, with no URL and no mark selection needed.
Why B is wrong: A URL action requires an address to be entered and opens content in a browser context, so it is heavier than needed and does not navigate within the workbook cleanly the way a navigation button does.
Why C is wrong: A filter action passes selected values between sheets but does not change which dashboard is shown, and it would require the viewer to select a mark first, so it cannot perform the navigation.
Why D is wrong: A show/hide button toggles the visibility of a layout container on the same dashboard rather than switching to a different dashboard, so it does not take the viewer to the Detail dashboard.
lock_openFree sampleCreate Contentmedium
A designer uses dynamic zone visibility so that a detailed commentary container appears only when a viewer turns on a Show notes toggle backed by a Boolean parameter. The container currently never appears regardless of the toggle. Which condition must be true for dynamic zone visibility to drive the container's appearance from that parameter?
- AThe container must be set to a floating layout, because dynamic zone visibility ignores tiled objects
- BThe controlling parameter must be a string parameter holding the words show or hide
- CA navigation button must be added to the zone so the control has something to act on
- DThe controlling field must be a Boolean field or parameter that returns true or falsecheck_circle Correct
Know that dynamic zone visibility requires a Boolean field or parameter as its control, showing the zone when that control evaluates to true. Dynamic zone visibility binds an object's display to a Boolean control: the zone is shown when the chosen field or parameter is true and hidden when it is false, so a non-Boolean control cannot be used.
Why A is wrong: Dynamic zone visibility works for both tiled and floating objects, so floating is not the requirement; this confuses zone visibility with unrelated layout positioning rules.
Why B is wrong: A string parameter cannot be selected as the visibility control because the feature requires a Boolean value, even though show and hide strings sound like a natural toggle.
Why C is wrong: Navigation buttons move between dashboards and play no part in zone visibility, so adding one would not connect the toggle parameter to the container's appearance.
Why D is correct: Dynamic zone visibility is driven by a Boolean field or parameter, and the zone shows when that control evaluates to true, so a true or false control is exactly what is required.
lock_openFree sampleCreate Contenteasy
An analyst has a list of individual customer order values and wants to see how those values cluster into ranges such as 0 to 50, 50 to 100, and 100 to 150, with the height of each bar showing how many orders fall in each range. Which chart should the analyst build?
- AA pie chart with one slice per order value
- BA histogram built on binned order valuescheck_circle Correct
- CA scatter plot of order value against customer name
- DA standard bar chart with one bar per individual order
Identify the histogram as the chart that shows the frequency distribution of a continuous measure across binned ranges. A histogram converts a continuous measure into discrete bins of equal width and counts the records in each bin, so the bar heights reveal where values concentrate rather than listing individual records.
Why A is wrong: A pie chart would create one slice per order and show parts of a whole, not the frequency of values grouped into ranges.
Why B is correct: A histogram groups a continuous measure into equal-width bins and counts how many records fall in each, which is exactly the distribution of order values across ranges described.
Why C is wrong: A scatter plot shows the relationship between two measures as points and would not summarise how many orders fall within each value range.
Why D is wrong: A plain bar chart per order is a near miss because it also uses bars, but it shows each order separately rather than counting orders within grouped value ranges.