Use Market mode

Owned by Helen Gosper
Last updated: Feb 14, 2023 by Denise McGettigan
3 min read

You must select a dimension to activate this mode; it is not available in Summary view. This mode cannot be charted.

Impact on performance: Market mode can have a major impact on performance, especially on large databases. While it can be used effectively on general queries, caution should be used when using this option on a collection of dashboard widgets, as the compound impact on performance can be severe.

Market mode counts the number of entities (such as customers) in one column (the market*) and a subset of entities in another column (the segment), then compares the results in a third column. You can use Market mode to compare a market segment to the overall market, in other words, to calculate and display the market penetration.

Looking at the first line in the image below, the total market in Greater London is 455 customers but only 57 of those customers are buying this segment (the selected product groups), giving a market penetration of 12.53%. This example uses a count measure but other measures, such as value or quantity, can also be used.  

* The market only includes selections that have activity in the period.

The following example shows the number of customers (market) who bought downlights and transformers products (segment).

  1. Select the market: Click the Country dimension, select the UK country, then click the Focus button. The grid displays columns for the active properties (such as Code and Name) for that dimension, a Total column, and a column for each time unit in the current period.

  2. Select the mode: Click Mode > Market. The selections you made above display next to the word Market in the status bar. They function in a similar way to the lock selections functionality (they no longer displays on the dimension button). The grid updates to display the following new columns for each measure: Market, Segment and % of Market.

  3. Select the segment: Click the Product Sub Class dimension, select the DL Downlights and TR Transformers (TR) products, then click the Focus button. The selections you made display next to the word Segment in the status bar. The data updates in the Segment and the % of Market columns.

  4. Define the market (select what you want to count): From the orange dropdown box, select the Customer Ship To dimension, so the number of customers defines the market.

  5. Prepare the grid for analysis:

    1. Click the Territory dimension.

    2. Change the measures: Select None, to remove columns and simplify the grid.

  6. Viewing and analyze the results. For example, you can see that of the 109 customers in Essex, only 16 are purchasing in the selected segments (downlights and transformers).

While still in market mode, you can make changes to your segment by clearing current selections and selecting/focusing on other data. The 'Segment' status bar will update accordingly. However, you can't change the market. To set a different market, you need to start again.