How to merge repeated values in table cells?

Get Help
1

How can I prevent values from repeating in the 'From' and 'To' columns of my table? I want to display the data like this:

image

As you can see in the example above, instead of repeating 'XXXX' multiple times in the 'From' column, it appears only once. Same for 'YYYY' in the 'To' column. This creates a cleaner look where repeated values are merged into a single cell.

Currently, my table shows the same values repeated in every row. How can I achieve this merged cell effect?

2

Use a pivot table.

3

When i try to create a pivot table I get this

image

4

You'll need to do some sort of summary. Max or Min normally do the trick if there's just one record per cell.

5

What exactly do i need to do?

My table already has that because it's calculating an average. I tried throwing in a MAX in the final select and I get the same message.

6

My query for reference

with competitor as (
SELECT 
        DATE(timestamp) as date, 
        id_name as Competitor,
        source_chain as Source,
        destination_chain as Destination,
        asset as Token,
        transaction_amount as Amount,
        AVG(fee_amount) as AVG_FEE
    FROM `database.table_name`
WHERE {{Date}}
and {{From}}
and {{To}}
and {{Competitor}}
and {{Amount}}
and competitor != "COMPANY_A"
group by date, Competitor, Source, Destination, asset, transaction_amount
),
data AS (
    SELECT 
        DATE(timestamp) as date,
        'COMPANY_A' as Competitor,
        source_chain as Source,
        destination_chain as Destination,
        asset as Token,
        transaction_amount as Amount,
        AVG(fee_amount) as AVG_FEE
    FROM `database.table_name`
    WHERE {{Date}}
        AND {{From}}
        AND {{To}}
        AND {{Amount}}
        AND id_name = "COMPANY_A"
    GROUP BY date, Competitor, Source, Destination, Token, Amount
)
SELECT 
    c.*,
    r.AVG_FEE as COMPANY_A_FEE,
    (c.AVG_FEE - r.AVG_FEE) as FEE_DIFFERENCE,
    ROUND(((c.AVG_FEE - r.AVG_FEE) / r.AVG_FEE), 2) as PERCENTAGE_DIFFERENCE
FROM competitor c
LEFT JOIN data r 
    ON c.date = r.date 
    AND c.Source = r.Source 
    AND c.Destination = r.Destination 
    AND c.Token = r.Token 
    AND c.Amount = r.Amount;
7

You need to do the aggregation in the 'Metabase' side of things rather than in the SQL query (I didn't realise you were using SQL).
As far as Metabase is concerned, that SQL just generates a resultset, there's no aggregation for Metabase to do.

8

What do you mean by aggregation on metabase side of things?

9

Create the SQL query without the filters or summary.
Save as a question.
Create a new question based upon the original question. Do the summary and filtering in this new question.