Export from a Saved View

Hi,

I am trying to create a process for export on a dashboard, facing few challenges in the data.

1. I created a saved view in a module where time is a dimension (time in Months)

2. Build an export action to run the export where Time is a selector and saved that export action and created a process from that and published to the dashboard

3. End user will be extracting Monthly data from that dashboard through the process. User will select the month from the selector on dashboard and accordingly the data will be refreshed, and if all looks good, user will run the process and have the data in excel.

Challenge:

When I created the export action from the saved view, lets say the time was selected as Jan'19. and completed other part of creating the process and publishing it to the dashboard. Now if I go to the dashboard and select March'19 and click the process the file again gets export for the month of Jan'19 and not for March'19. while the saved view is in sync and displays March'19. Where do I miss that the action gets in sync with saved view and should give the data per the month selected by the user.

Thanks.

Accepted answers

All comments

Misbah

@ShivankurSharma

You need to control it thru filter.

Step 1 - Create a module (Module A) and Insert one line item - Filter. This will be Time Formatted Line item

Step 2 - In your Saved View Create a Boolean Check Line item which will check what selection has been made in Step 1. Write the formula in Boolean Check Line item => Module A. Filter = ITEM(Time)

Step 3 - Apply this filter in the saved view and override your current saved view

Step 4 - Publish Module A on to the dashboard. You can also publish your saved view as well

Note: Users will have to refresh the dashboard once they make the selection in the pick lists before they hit the export.

ShivankurSharma

@Misbah But in that case I need to publish that line item from Module A to the dashboard for the User to select. While there is another table already present in the dashboard which is with Time dimension and user looks to the data in that table and then exports. In your approach the user will first select the Time from dimension and then over look the data and then select the time again in that line item and then exports. Which will be a length process for user to do multiple selections.

Misbah

@ShivankurSharma

Well you may want to bring/repivot time to your columns so that they don't have to make selections twice - one to see the data and another to pull the data. But as per me you will have to apply filters in order for you to get this working as per your requirement

Here is the screenshot of how it should look like

Hope it helps

Misbah

ShivankurSharma

I might need to add a refresh button as well to get the below table updated and then process the export action. But the solution helps, will check if have two buttons help, one to refresh and other to export.

Misbah

@ShivankurSharma

I would recommend using the native Refresh button and educate your users accordingly. It is not considered to be the best practice to have a Refresh button created on the dashboard.

Quick Links

Can you help?

Unanswered questions

How to create identical child items for multiple parents
The data I'm trying to import is as follows Parent-Code A B A C B D C D D E I want to generate the following list from this data: L1 L2 L3 L4 A A-B A-B-D A-B-D-E A A-C A-C-D A-C-D-E You can create up to L3.However, L4 has multiple parents for one row of data When I try to create L4 from D-E, only one list row is generated…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
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.…