Need to fetch values from a line item based on another line item value in the same module

What are the dimensions in the Target Module? It'd help if you share a screenshot of Target Module and Line Item also

filip.sypniewski

Hi @praba71,

what exactly are you trying to achieve? do you only need to show the lines which are empty? you can filter your 'config' line item to show the lines which are empty. You can save the view, publish on the dashboard.

Hi @filip.sypniewski @Nagaraju

Thanks for the response.

I have three modules - Module A, Module B,Module C. All of them have items and config mapped as shown in the screen shot. Some of the items in these modules may not have mapping and I want to capture those items and show them in a dashboard (sort of Exceptions Dashboard) so that Business users can add the missing mapping. The target dashboard will have Items, Item Descriptions, Source Module Name (ex. Module A ).

Can you suggest the setups to meet this requirement?

Thanks in advance

Prabakaran

Hi @praba71

You may publish the module in the Dashboard directly, and apply filter to just show the blanks.

To apply a filter, click on the left arrow, go to Data -> Filter -> select Line Item should be blank.

Thanks @Nagaraju , as I mentioned, I want to show the exception items from three modules in one separate dashboard.

I am looking for any suggestions to achieve that objective.

Regards

Prabakaran

By Exceptions, you mean the BLANK items in "Config" Line Item right?

You can publish all the 3 modules in a single separate Dashboard. You have to apply filters on all the 3 modules in the Dashboard so that only BLANK items appear on the screen for the Customer. Finally save the changes you have done.

Hope it helps!

Hi @Nagaraju The three modules will be published into three separate dashboards as per the requirement. My idea was to set up a module (Exception. module) to capture the records having blank Config in all the three modules and then publish the Exception module to a dashboard. Any suggestion on how to do this?

Thanks

Regards

Prabakaran

I see no point in creating an extra module for the task at hand. Even though you create a different module, you have to publish it 3 times and apply relevant filters for each Line Item at hand.

Instead, just publish the existing modules and show only the necessary items. At least, that is how I understood the requirement. If there is something else, please explain in detail.

Thanks

Hi @Nagaraju

Please find attached the columns that I am planning to have in the Exception dashboard. The items in this dashboard are the ones having blank value for Config in either of the 3 source modules. The third column is the name of the source module.

Thanks

Regards

Prabakaran

filip.sypniewski

the 3 modules have different dimensions?

Anyway, you can simply publish 3 grids on exception dashboard with filter showing only the blanks. No need to create additional modules.

Thanks @filip.sypniewski for the suggestion..

The three modules may have some item values for the blanks. So, instead of showing the same values in the three grids in exception dashboard,I want to show the unique values in the dashboard. Any suggestion for this?

Regards

Prabakaran

Kanishq17