Pivot table year / quarter / month

Get Help
1

Hello, I want to make a pivot table from a delivery list.

I have 3 fields: sdhnum (delivery slip number), xexpdat (shipping date, bptnum (carrier identifier).

I want to be able to browse the table filtering by carrier and display data by year / month and count the number of deliveries for each set.

Example of my data:

image
image286×537 38.9 KB

Example of the expected result with Excel

image

I cannot create the year / quarter / month detail in the same view.

Is this possible without having to click on each element to go down in detail?

I'm use Metabase 0.39.3

Thank you in advance.

2

Hi @flipflip
You would have to return the column multiple times (with different names), either via SQL or a View.
https://github.com/metabase/metabase/issues/4726 - upvote by clicking :+1: on the first post
Otherwise you would only be able to have a single granularity.