Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Company Counting

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.

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

2 Replies

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

    • Anonymous's avatar
      Anonymous
      Not applicable

      Yep thought so, going to have to! Thank you