How to combine output from 2 different Applications in one table.

[Maminuli]

Hello Community,

We've encountered a performance challenge while working on a data visualization project. Our goal is to create a single table visual with over 90 columns, but we've noticed significant performance issues when attempting to display all these columns in a single table visual. To mitigate this, we've temporarily split the table into two different dashboards. However, we're now exploring a way to streamline the process.

Is there a method to pass the filters applied in one application to another application and subsequently combine the tables present in both dashboards into a single table as the output? We're open to any insights or solutions that can help us optimize performance and achieve our goal of a comprehensive table visual.

Your expertise and suggestions are highly appreciated. Thank you in advance for your assistance!

[Abhishekb]

Hi @Maminuli ,

Do you want to  pass the filters applied in one sheet to another sheet or pass the filters applied in one application to another application.

Because for filtering multiple sheets you can use the alternate state option but I never heard about multiple apps filter.

-Abhishekb

[Maminuli]

We want to combine two different tables output from two different applications in one one table after passing filters.

[Tanish]

Hi @Maminuli ,

There are several ways to optimize the Application, may be you tried that as well but still highlighting some options for your reference.

1. Default Filters -

This is one of the Best option when we have Heavy Visual.

For example - You can use Year and Month Filter as default filter. If you have option you drill down more Like with Customer.

2. Three tier or Four tier Application.

Having Transformation and visualization in the same application also effect the Optimization and response time. You can separate each step into different application.

3. Creating table at backend 

If possible you can try creating the same table at Backend(Load Editor). This may increase the Reload time but can decrease the Response time also if not full table you can try creating partial at backend rest at front end.

4. Decrease the use of Set Analysis and If

If Possible don't use If condition and Set Analysis also Aggr function.

5. Load less duration data

If Possible decrease the amount of data in the application.

These are some ways you can try, Hope these can help.

Thanks,

Tanish

[Maminuli]

Hi Tanish,

We have already done the optimization of the application  and and client wants the data of all the years since inception so no point in reducing the data also there is only one master  table which is used so there are joins in it.

Because the Data is huge and it is impacting our Applications performance we have split the application in 2 Different apps but we want the outcome of both of these apps in one table.