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 on the first post