Analysis-level Calculated Fields lost when replacing multiple datasets by one dataset

Q&A
, ,
1

The Problem: I am consolidating an Analysis by replacing three original datasets (D1, D2, D3) with one new “Super-Dataset” (D4).

Context:

  • Replaced D1, D2, D3 individually with D4 are all successful and no broken analysis chart

Steps & Failure:

  1. Swap 1: Replaced D3 with D4. Calculated fields were preserved, and visuals worked.
  2. Swap 2: Replaced D2 with D4.
  3. The Result: All Analysis-level calculated fields from the first swap (D3) were immediately deleted, breaking my visuals.

Question:

  • What is the approach to achieve my goal here while ensuring all the calculated fields are preserved from D1, D2, and D3 after the replacement by D4?
  • Is there a way to “commit” the first mapping so it isn’t wiped by the second?
1 Like
2

Hello @irinaaaaa, from my experience, this type of data replacement is not possible in Quick Suite. When managing datasets in an analysis, you are only able to swap 1 of the current datasets with a single, new dataset.

The one thing I can think of to try, which I have not tested, would be to create all of the calculated fields, matching name and everything, from D2 and D1 on D4 after replacing D3. You can see if that makes any difference when swapping the 2nd dataset.

Unfortunately, the most likely solution here, will be to replace the most utilized dataset or the dataset with the most complex calculated fields/filters, with D4, then manually update the rest of the visuals/filters connected to the remaining datasets. Once you are finished replacing everything, you can delete the unused datasets from the analysis. That is going to be the only way you can guarantee none of the calculated fields are broken during the replacement process.