Calculated Column and filter autocomplete

[Smile for La Poste]

Hello,

In a table i have imported to Magento BI, i've created a column of type 'One to many'.

I succefully create a metric and report with it.

But in my report builder, when I use the filters on one of my metrics, I don't have any autocomplete help for this column, but all my other column have.

I don't see what i'm missing.

Thank you in advance for your help

Pierre

[chris_schmid · Accepted solution]

Hi Pierre,

Most likely you did everything correctly here. Assuming you're working on MBI's new architecture, the auto-complete filter and group by drop-downs are only populated for native columns. Due to the way calculated fields are compiled, it isn't currently possible to display cached values for calculated fields.

If you are unsure of the specific formatting for a particular string text that you are attempting to filtering for, I recommend you first group by the column and show all results. From there you can copy the string and apply it to a filter for a metric.

Best,

Chris

[Smile for La Poste]

Thank you for these precisions