Round down the average number when using Summarize

Hi, I'd like to ask if there is any way to round down the average number when using Summarize
as shown here I used Summarize to group by the vendor name and then calculate the Average number of days , I tried to set the "Minimum number of decimal places" to 0 but it round it the number up , Thank you

Hi @Lina
Rounding of 6.5 = 7
If you want to control it more granular, then you'll need to use Custom Expression floor():
https://www.metabase.com/docs/latest/questions/query-builder/expressions-list#floor

Hi, I can only view Custom Expression in Filter section but not in Summarize section
and my database is mongodb ,so does it support Custom Expression ?

@Lina There's currently no support for Custom Expressions on Mongo:
https://github.com/metabase/metabase/issues/7097 - upvote by clicking :+1: on the first post