Dynamic columns

Question & Answer
, ,
1

I would like to know if anyone has created a dynamic calculation model before. Let me explain my situation. I have a process that automatically creates datasets based on the files provided. The problem is that the column names can change, so I don’t know which column will be summed.

For example, I have a measure like Measure01 = SUM(ColumnA), but ColumnA might not exist. I would like to use parameters to dynamically change the column name in the calculation. Essentially, I want to dynamically replace the part of the item highlighted in yellow.

Does anyone know if this is possible? Just to clarify, I don’t know the columns that will come in, and I will pass this information through a parameter in the dashboard.

image
image1035×229 11.9 KB

2

Hello @woliveiras !

I’m not sure this is possible. Are you entirely changing your datasets or are the datasets changing when they refresh?

3

Hello @woliveiras !

Are you still working on this or were you able to find a solution?

4

We change the entire content of the dataset dynamically. We have implemented the concept of a template, and when we run our process, it generates a dataset with unknown content. The dataset’s content depends on what has been created in our datasource. What I want is to create a generic measure and be able to open a filter containing the columns available in our dataset, allowing me to select the columns I want to sum up.

1 Like
5

Hello @woliveiras !

I’m sorry about the late reply. Ultimately I think the problem you will run into is that your analysis template will expect specific fields from specific datasets. Our team has done work with templates in QuickSight, and it has gotten better/easier, but we still run into issues with data fields needing to be absolutely consistent.

I’m not sure how this would be affected by using parameter values. Have you tested this process yet and received any errors?

1 Like
6

Hi @woliveiras,
It’s been awhile since we last heard from you. Did you have any additional questions regarding your initial topic?
If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

7

Hi @woliveiras,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for any relevant information that may be needed.

Thank you!