Showing icons for each distinct count of shipment with details underneath

[Rafay_anis]

Hi everyone!

First post on this forum although I visit regularly and find most questions already answered.

So here's my scenario. I need to create a visual representing an image for each pending shipment being received in the ERP (filtered item wise). For instance, if 2 pending shipments are to be received, then following are the reporting requirements:

1. 2 ship icons are to be shown in the report.
2. Under each ship, its relevant details like shipment number, quantity and date of arrival, etc. are to be shown.

I managed to do the first requirement by playing around with the infographic designer custom visual. And added two seperate card visuals to show the quantity and date respectively of the earliest pending shipment only. You may refer to the image below where 7,700 represents quantity and August 10th represents the shipment date. However, later on client said he wants the information for all pending shipments below each icon, so I am not too sure how I can fulfill the second requirement.

I have attached a screenshot of my report using dummy data and used an Image Editor to add how I need to the text to appear (circled in Blue).

The following are the details of the data source, if it matters:
Data Source: MS NAV 2009
Table: Purchase Order Lines

Relevant Fields for Shipment: Purchase Order number, Item Number, Quantity, Expected Receipt Date

Assumption: Pending shipments means Expected Receipt Date > current date. One Purchase Order is equal to one shipment. Partial shipments or unfulfilled shipments are ignored. Tooltips is not an option as report is presented on a TV with autorefresh and hence, no interaction with mouse or any other input device.

So any feedback or ideas if something like this can be achieved?

Regards

Rafay Anis

[v-cherch-msft · Accepted solution]

Hi @Rafay_anis

As it is a custom visual, i suggest you may check out the Support site (http://www.microsoft.com/en-us/research/project/infonice) for more professional information.

Regards,

Cherie

[Rafay_anis]

Thank you for the link, I will check out their support site.

However, assuming the custom infographic designer visual does not meet my requirement, I am open to suggestions for other custom visual / measures / work around. Is there any other way to achieve the the requirement?

[Rafay_anis]

Solved! Thank you for the link, just viewed the videos provided in the link to fulfill my requirement, thanks!