Question

How to show a chart with only a part of the dimension/measure value. I want to plot a graph of sales for the first 100 orders in each region. Later i put all sheets in one dashboard and compare it. The order is a alpha numerical value with country code-shop-code-order-id. How to plot?

Answer 1

Hi Nithin,

Follow below steps:

1. Create a calculative field like below to split the order-id to get only order count.

2. Add region into filter shelf.

3. Now add this into filter shelf and edit the filter as below to get top 100. Change to maximum and sales to get top 100 orders with maximum sales.

3. Now add the field id and other measures into graph and sort the id field to get top 100 id in order.

Hope this helps you.