Forum Discussion

user900's avatar
user900
Helper 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.

user900's avatar
user900
Helper 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
Super User
3 years ago

How are the status related with the line of business 

  • user900's avatar
    user900
    Helper 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.