Error with a calculated aggregate field

1

Hi all,

I have a table with payments. The table includes the payment provider, the processed payment amount, and the fees for that payment.

I want to create a pivot, showing the total processed amount, the total fees, and the overall fee percent for each provider by month.

But I keep getting errors. The results show when I first create the question, but then when I reopen the question or add it to a dashboard I get an error.

Any ideas?

image
image993×519 20.7 KB

image
image766×1177 47 KB

image

Thanks!

2

troubleshooting info?

3

Hi @Luiggi ,
I only see the "Error running query" message.
Is there a way to see a more detailed error?

Thanks!