Skip to main content
kate_green
kate_green
Helper ⭐️⭐️
December 5, 2017
Solved

Chart Showing Yes/No (or True/False) Count For Multiple Fields

  • December 5, 2017
  • 11 replies
  • 3303 views
I have gathered information from various sources and compiled all values into an MDA table.  For example, how many times and account did X in a certain time period.  This table also contains a boolean field corresponding to each value field.  If the value is greater than 0, the boolean field is True, otherwise, False. 

I want to use this information to create a table that shows a count of all accounts and how many are either True or False for these fields.  An example mock up looks like this:



Each "Resource", as I'm calling them here, is a boolean field in the MDA table.  In this example, we have 2500 accounts and they all have either a True or False value for each field.  I can't figure out how to get a report that looks like this - is it possible?

Thanks for any help or suggestions! 
    Best answer by dan_ahrens
    Hi Kate, would something like this work where you have a row of data for each activity type & date combination?



    If so, here's how you'd do this:
    • Create a new MDA table to reflect the data above. 
    • Use a formula field for the third column and use the text concatenation formula (concat) to combine the date and activity into a single field - see this link.
    • The concatenation is required as you can only have a single field in the "By" area when reporting with an intent to use a stacked bar as the final visualization
    • Use a bionic rules transform task to sum (by counting with a filter) for Sum of Yes and Sum of No fields - see this link
    • Use a load to MDA setup action to write this aggregated data to your new MDA table
    • In the report, use the new MDA table as the source and add the concatenated date and activity field you created to the "By" area and the two new sum fields to the show me. This should give you a table of data that would allow you to create a stacked bar chart. 
    :)

    11 replies

    Show previous replies
    kate_green
    kate_greenAuthor
    Helper ⭐️⭐️
    December 11, 2017
    Here you go!  I have Count of Account Name in the aggregated Show me field and then Activity and Participated (yes/no) as the Group By fields.  I used a filter to show me last 90 days, so this will update with each release.

      Terms & ConditionsAccessibility statement