Im thinking of making a document libary with files that have a field "type_of_document" which gives the type of document e.g. "meeting notes". I wont make hem content types, just a column where multiple 'types' can be added for 1 file (in case the file contains multiple documents in one). Each of the documents is tied to a `collection´ number. The ´collection´ number is tied to multiple documents. I dont use document sets.
I now want to make a view where the content is categorized - ordered by that number.
Until so far that it is simple. But now: a certain amount of those 'type_of_document' will be required per 'collection number'. So now I want to place a percentage next to the 'collection number' based on the amount of 'type of document' entries matching the required list (this will probably be a workflow).
Would that be the best approach?