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

Highlighted
Contributor

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

Hi

Need help to get this requirement done.Please see the screenshot attached.I need to show the items which have blank value in the Config line item, in another module.(ex.HDD0037,HDD0037) 

Can you suggest the formula that I need to use in the target module?

 

Thanks

Regards

Prabakaran

 

13 REPLIES 13
Highlighted
Contributor

Re: 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

Highlighted
Super Contributor

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

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.

Highlighted
Contributor

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

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

Highlighted
Contributor

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

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.

Nagaraju_0-1594890721813.png

 

 

Highlighted
Contributor

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

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

 

Highlighted
Contributor

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

@praba71 

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!

 

Highlighted
Contributor

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

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 

Highlighted
Contributor

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

@praba71 

 

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

 

 

Highlighted
Contributor

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

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