step1: Spend_SupplierName_Country_Risk_Mgmt_Scope=sumOver(sum({total_invoice_spend_usd}),[{normalized_supplier_name},country,Risk,{Management Scope}])
step2: Supplier_Spend_Bucket= ifelse(
{Spend_SupplierName_Country_Risk_Mgmt_Scope}<=10000,‘<$10k’,
{Spend_SupplierName_Country_Risk_Mgmt_Scope}>10000 AND {Spend_SupplierName_Country_Risk_Mgmt_Scope}<=500000,‘$10k-$500k’,
{Spend_SupplierName_Country_Risk_Mgmt_Scope}>500000 AND {Spend_SupplierName_Country_Risk_Mgmt_Scope}<=1000000,‘$500k-$1m’,
{Spend_SupplierName_Country_Risk_Mgmt_Scope}>=1000000,‘>$1m’,‘Undefined’
)
step3: created a filter on Supplier_Spend_Bucket and visualization has all fields used in step1 and step2. But, the filter is not refreshing the data.
Here is the error message I see: VISUAL_CALC_REFERENCE_MISSING
Table calculation attribute reference(s) are missing in field wells
Please help how to resolve this issue to allow users to see all 5 values in the drop down filter list and chose any value(s)
It’s been awhile since last communication took place on this thread, are you still encountering the same issues or were you able to implement a work around in the interim?
When you receive a message like visual calc. reference missing; it’s normally linked to the table missing a field that’s being utilized in your calculated field in some way. I would suggest adding those additional fields to your table; if you don’t want them to show, you can ‘hide’ those fields from the visual.
Let us know if you have any additional questions. If we do not hear back within the next 3 business days, I’ll close out this topic.
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.