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.
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?
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.
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?
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.