Issue after removing joint table - visuals and calculated fields broken

Q&A
, , , , , , , , ,
1

Dear All,

I am facing frustrating issue and would really appreciate your guidance

scenario:

  1. I had a master table play in my data set
  2. I performed left joint from table B and table C to A
  3. Then also performed left joint from table D to table B
  4. Using this setup ,I created several visuals and calculated fields that referenced from table D
  5. 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.

image
image1321×572 40.3 KB

Best,
Vaibhav Narwade.

2

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.

image
image465×194 10.6 KB

Regards,
Giri

3

Hello @Giridhar.Prabhu,

I have tried this option but unable to publish the History.

Best,
Vaibhav Narwade.

4

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
5

Hello @WLS-D @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