I have the following custom column expression: concat(floor([Duration, days] / 91) * 3, ".."). I want to get duration grouped per 3 months and show “0…2”, “3…5” etc. (I’ve omitted the bit after “…” for now). However, it gives me the following error message:
Value does not match schema: {:query {:expressions {:Duration, mnth. (named [nil (named (named (not (some-matching-condition? a-clojure.lang.PersistentVector)) "Must be a valid instance of one of these clauses: :field-id, :field-literal, :joined-field, :fk->, :datetime-field, :expression, :binning-strategy") "a") nil] "Must be a valid instance of one of these clauses: :substring, :trim, :ltrim, :rtrim, :replace, :lower, :upper, :concat, :regex-match-first, :coalesce")}}}
I suppose, there is no casting from number to string?
Hi!
I am using version 0.49.7 and I tried following the suggestions in the issue. I also tried creating custom columns with just the number, then concatenating those custom columns with strings.
However, the solutions I've found keep giving me an error saying that concatenation can only be done with strings. Is there another way to concatenate integers with strings? ~