Subscribing is a smart move!
You can subscribe to this board after you log in or create your free account.
Invite a Co-worker
Send a co-worker an invite to the portal.Just enter their email address and we'll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
Solved
Go to Solution
Link copied. Please paste this link to share this article on your social media post.
Accepted Solutions
Link copied. Please paste this link to share this article on your social media post.
Hello Valentin.
Ok, I admit your question made me think about how to do what you're asking. So I did a little research, I pasted a section of the Insight view of the Inventory report below. You can certainly create a joined dataset with the existing inventorytags dataset and a new custom properties dataset to join rows to custom properties.
But as I think you already stated in this ticket this means you'd get a series of addition rows in your output, one for each custom property assigned to the device (right?).
So, I think you need to create a group in each section... the group would be based on name and location perhaps? Then you'd want to move the data fields in the above detail rows to the group footer row, then change your new custom property field to an string field which you aggregate the custom property value from each returned row into a list. So the grouping will produce one row of output for each inventory item and location, then your list of custom properties would only be outputted on the footer.
Make sense? I think this would work.
GregS
Link copied. Please paste this link to share this article on your social media post.
Hello Valentin.
Ok, I admit your question made me think about how to do what you're asking. So I did a little research, I pasted a section of the Insight view of the Inventory report below. You can certainly create a joined dataset with the existing inventorytags dataset and a new custom properties dataset to join rows to custom properties.
But as I think you already stated in this ticket this means you'd get a series of addition rows in your output, one for each custom property assigned to the device (right?).
So, I think you need to create a group in each section... the group would be based on name and location perhaps? Then you'd want to move the data fields in the above detail rows to the group footer row, then change your new custom property field to an string field which you aggregate the custom property value from each returned row into a list. So the grouping will produce one row of output for each inventory item and location, then your list of custom properties would only be outputted on the footer.
Make sense? I think this would work.
GregS
Link copied. Please paste this link to share this article on your social media post.
Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.