Forum Discussion

OliverC's avatar
OliverC
Regular Visitor
6 years ago

How to show activity count by account

Hi all

 

I want to show activity type and count, by account, in a chart in Sales Analytics. I'm inspired by this chart, which shows activity type by day, which is perfect, but I want to see it by Account. 

 

 

However, when I try to create a stacked chart with the Axis as the Account Name, with the Legend as Activity Type and the Value as Activity Count, every record appears to be the same. Where-as each account has a different number of activity records, the chart shows them all to be the same. 

 

 

Any idea how I can create the chart I want? 

 

Olly

Need Help

6 Replies

  • ibarrau's avatar
    ibarrau
    Icon for Super User rankSuper User
    6 years ago

    Hi, can you share the data model? this is usually a problem of using two columns from two tables that are not related.

    Regards,

    • OliverC's avatar
      OliverC
      Regular Visitor
      6 years ago

      Thanks Ibarrau

       

      Im afraid I'm not sure what you mean. 

       

      If it helps, I'm using the Sales Analytics app within PowerBI to connect to Dynamics 365. 

       

      Does that help?

       

      Olly

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi OliverC,

    It is hard to troubleshoot your scenario without any data. You can copy data from your pbix file and paste it to an excel file. After these steps, you can reference the copied data structure to create some dummy data for share.

    How to Get Your Question Answered Quickly 

    Regards,

    Xiaoxin Sheng