Hi, I want to generate some custom reports that can be emailed and used for other imports (using the csv or xlsx report).
For some demands they need to contain a fixed column. I have used SQL previously, but most of our colleagues have a hard time using this, so want to merge these reports to the notebook/UI setup.
Tried adding a custom column using "Value" or 'Value' as fixed value, but the page crashed as soon as I leave the expression field:
Metabase has always had trouble with this. I can't reproduce your exact issue, mine isn't crashing the screen but the custom expression simply doesn't "stick" and it immediately disappears (v0.49.7 & v0.50.11).
You can work around it by doing some sort of operation with you constant value:
I use =concat("", "X") for strings and =0 + X for numbers.
That is shit. I'm trying to get the organisation off SQL queries, because they tend to be created by people who have no clue. So they already have the hurdle of moving to a UI they don't know, so all workaround make it more difficult.
Is this the best place to report this or should I try to file a bug report around this?
An issue already exists, go give it a thumbs up Custom Expression: Literals · Issue #34580 · metabase/metabase · GitHub
It hasn't got much love so far though.
Thanks @notrom I didn't find that because it is not using terms i would use. Unfortunate that this is not on the agenda to 'fix'.
