Forum Discussion

user900's avatar
user900
Icon for Helper II rankHelper II
3 years ago
Solved

Chart Help

I have a data file that shows User Name, Status and Department. Using the stacked bar chart, I'm showing the Department on the Y-Axis, count of Users on the X-Axis and Status as legend.  I need to al...
Need Help
  • MFelix's avatar
    MFelix
    3 years ago

    HI user900 ,

     

    Delete this relationship and everything should work has you need.

MFelix's avatar
MFelix
Icon for Super User rankSuper User
3 years ago

HI user900 ,

 

Delete this relationship and everything should work has you need.

user900's avatar
user900
Icon for Helper II rankHelper II
3 years ago

I have another request to add a breakdown by the highest status. I created measures to get the counts for each of the 4 statuses. However without a relationship to the new Department table, it shows all the same results for all the departments. Can you help so that I can get the results by department, while still keeping Enterprise-Wide. 

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    3 years ago

    How are the status related with the line of business 

    • user900's avatar
      user900
      Icon for Helper II rankHelper II
      3 years ago

      Line of businesss is one table (you suggested I create a table and add a row for Enterprise-wide.) Status is in a seperate table with users.