Company Counting

[BotBot1]

Hi,

I have the below clustered bar chart visual. I have a table called ApprovalLog with [Actions] as my y-axis ("accept" or "reject"), count of [CompanyId] as my x-axis and a Small Multiple of [Section] which is 4 sections that companies go through acceptance/rejection of ("a", "b", "c" and "d"). 

It is currently counting companies where they have had an action in any of the sections, but I need the count of the CompanyId's to be the by the latest date of each section. E.g. If a company has had an Action of "accept" from section a and a "reject" from section a also, but the accept is more recent, i need the company excluded from section a "reject" in the visual. Please see the below example:

For example, for this company, I would like the company counted for the top 4 rows but not the bottom one as the DateCreated was earlier than the more recent section a (earlier in the day in this example). 

Please let me know if you need any other information/clarification, thank you.

[lbendlin · Accepted solution]

You can use a calculated table to implement that grouping logic. Then feed the visual off that table.

[BotBot1]

Yep thought so, going to have to! Thank you