How to set automatic refresh when filter is updated to new value

Hi All,

As I was building the UX Pages and came across on roadblock wherein each time when I change country and segment in field card I had to refresh the page again to get new country and segment values.

Please requesting for inputs on how to set automatic refresh when I change the filter to new country and segment

Below is screenshot where I have changed My country? = Mexico

but both the grids are still showing US value. please need inputs on how automate this

Accepted answers

SriNitya

@Karthik31
Hi,
After every selection for the data to get updated automatically, you can try this with below steps
Create boolean Line item which is always marked as TRUE

then publish Action Card in UX , Select Create→ Data Write

On Clicking Data write it appears as below then select the module, line item and cell value as True and create the Action.

Then Refresh action appears, so after every selection by running the refresh action the data gets updated.

Regards,
Sri Nitya

rob_marshall

@Karthik31

The reason it is not refreshing is that the filters you are changing are more transactional data (line items) versus structural data (lists). A potential solution is to have Country and Segment as selectors which will also make the results unique for every user.

When you are changing transactional data, you will need to be careful so the results are what you are actually filtering on. To get around this, you may have to dimensionalize the filters as well as the results by the Users list which could **** up your cell size.

All comments

SriNitya

@Karthik31
Hi,
After every selection for the data to get updated automatically, you can try this with below steps
Create boolean Line item which is always marked as TRUE

then publish Action Card in UX , Select Create→ Data Write

On Clicking Data write it appears as below then select the module, line item and cell value as True and create the Action.

Then Refresh action appears, so after every selection by running the refresh action the data gets updated.

Regards,
Sri Nitya

rob_marshall

@Karthik31

Bennjamin

Thank you, I was also having the same problem and solved it

Quick Links

Can you help?

Unanswered questions

Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…