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.

6 Likes
3

Hi @irinaaaaa,

Just checking back in since we haven’t heard from you in a bit. I wanted to see if the guidance shared earlier helped resolve your question, or if you found a solution in the meantime.

If you still have any additional questions related to your initial post, feel free to share them. Otherwise, any update you’re able to provide within the next 3 business days would be helpful for the community.

Thank you

4

Hi @irinaaaaa ,

Since I haven’t received any further updates from you, I’ll treat this inquiry as complete for now. If you have any additional questions, feel free to create a new post in the community and link this discussion for context.

Thank you