Dear All,
I am facing frustrating issue and would really appreciate your guidance
scenario:
- I had a master table play in my data set
- I performed left joint from table B and table C to A
- Then also performed left joint from table D to table B
- Using this setup ,I created several visuals and calculated fields that referenced from table D
- lately I decided to table D from the dataset
Problem:
I started seeing this error :
field{{fieldname}} in {{expression}} does not exists
it appered that visuals and calculated fields using from table D are now broken and now unable to delete or fix them easily
what is the solution now to clean up my dataset
and visuals without breaking things further.
Please find the snapshot for the reference.
Best,
Vaibhav Narwade.
Hi @Vaibhav.narwade
Since the issue is in the dataset have you tried reverting back to a previous version of the dataset?
Click on the Manage button the Edit Dataset page and click on Publishing History. There you should be able to select a prior version of the dataset.
Regards,
Giri
Hello @Giridhar.Prabhu,
I have tried this option but unable to publish the History.
Best,
Vaibhav Narwade.
Hello @Vaibhav.narwade
Were you able to find a solution or are you still working on this? You could be hitting a permissions issue for republishing the the dataset from the history.
Have you tried recreating the join in the current dataset and republishing?
If you removed fields from your dataset that were being used in your dashboard this error would happen regardless. I always recommend testing dataset changes by creating duplicates of datasets and analyses to create a test environment prior to making any final changes.
1 Like
Hello @duncan @Giridhar.Prabhu ,
I addressed all calculated fields that I had created individually, and this approach successfully resolved the issue. Although the process was time-consuming, it proved effective for my situation. I appreciate your prompt response and valuable guidance.
Thank you.
Best regards,
Vaibhav.
1 Like
