u/Loorde_

Hello team,

Last week, we encountered a very unusual issue: every COALESCE applied between fields from tables within a blend is being flagged as an invalid formula.

Sample blend:

https://preview.redd.it/romq5yhbdktg1.png?width=775&format=png&auto=webp&s=6f3a416169cd4501efe824df61ac306de2c127cd

Error:

https://preview.redd.it/ddwk10medktg1.png?width=306&format=png&auto=webp&s=91671de3cc00d1dabd54e898cf390b0a7dd510cf

Additionally, although the COALESCE function does return a value, all results are coming through as unformatted timestamps.

https://preview.redd.it/5kdgg01jdktg1.png?width=348&format=png&auto=webp&s=98d67723b1eef2cf96baf15d1488ffb7851d9680

It’s worth noting that this function was working correctly last week. I’m not sure if this behavior is related to a recent update.

Thank you in advance.

Hello team,

I have a quick question: how can I create a calculated field that references columns from more than one table in a blended data source?

I know this can be done at the chart (visualization) level, but I need to filter based on that field. Because of that, the formula would need to exist at the data source level, in the blend.

Thank you in advance.