I’m trying to add a calculated field in my dashboard as a filter and i get the visual_calc_reference_missing error. Even when all the fields that are in my calculated field are in the table it still doesn’t work. How can I avoid this? Thanks!
could you please share some more details (calculated field, filter definition, table)?
BR
Hi Erik!
Thanks so much for your response. The calculated field is called “Best Seller?” and is as follows:
ifelse({% of vendor revenue}<0.05,“Low Seller”,{% of vendor revenue}<0.3,“Medium Seller”,“Top Seller”)
The % of vendor revenue is also a calculated field, as follows:
sum({p_rev_t12w})/sumOver(sum({p_rev_t12w}),[{company_vendor_code},{marketplace_id}])
These are normal metrics, not calculated fields.
What I want to do is add the “Best Seller?” calculated field as a filter on top of the dashboard table so people can filter it by “Top Seller”, “Medium Seller”, “Low Seller”. When I add the metric as a filter I get the error “visual_calc_reference_missing error”. I tried including all metrics included in the calculated fields in the table and it still happens. I even tried creating a new calculated field that is just “Best Seller?” so it is equal to that one but is not a calculation and it also doesnt work.
The weird thing is I managed to add another calculated field as a filter.
You can also reach out to me via Chime if thats easier: @cavdc . Thanks!!
Hi @Cristina_Aviles_de_C
i just was to finish my sentence and had a final idea.
Key was the “custom filter list”
Could you try so create the filter for “Best Seller”, change it to “Custom filter list”,
add to sheet and define the “specific values”
BR
1 Like
Did @ErikG 's solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the Quick Sight Community Q&A Forum!
1 Like