We are using Logbook’s “Other” category to log data (name, date, team, comments) on our projects. We would like to be able to have a view showing ALL comments in one place...rather than having to go to each project and open the Logbook tab to see if there are any comments.
I am using the Logbook Template V1.2.pbit to try and create a view showing all Work items that have a Logbook entry associated with them. In Power BI I’m trying to create a Matrix where the Rows are the Work item data and Logbook entry “name” (EntityAssociations: EntityID & EntityAssociations:EntityName, LogbookItems: Name), the Columns are the CustomAttributesConfigs: Name and the Values are the CustomAttributes: Value.value
When I try to use the CustomAttributeConfigs fields with the EntityAssociations fields in the same visual, I get an error - “Can’t determine relationships between the fields”. I get this error when I try to use these in the same visual. I can put them in separate visuals (list projects in one box with the name of the logbook item. Click on the logbook item name and show the detail information in a box below), but it doesn’t create the view I would like to see.
Has anyone done anything similar and had success? We are currently only in the sandbox, but hope to release Logbook use in the next month.
Thank you in advance.
Sonia