Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Kritika_Dhanbhar
Contributor II
Contributor II

How to create Stacked bar chart using different columns?

I am trying to create a stacked bar chart that shows the distribution of expenses (Over budget amount,Under budget amount,team costs and expenses).I have different columns in my datasource for team costs,expenses,budget and Remaining budget.Will I have to reorganize my data set and add a column that categories various values as teamcosts or expenses to get the stacked bar chart?My dataset and objective is:

Kritika_Dhanbhar_0-1676975855942.png

 

Kritika_Dhanbhar_0-1676975724999.png

Is there any other workaround?

Thankyou so much!

 

 

Labels (1)
1 Solution

Accepted Solutions
Kritika_Dhanbhar
Contributor II
Contributor II
Author

I found the solution!

I did this by Pivoting the table in data set like:

Kritika_Dhanbhar_0-1677005367476.png

I have aggregated all the expenses,teamCosts,Remaining budget values for each client by pivoting it.And then transformed it as shown.

Hope this helps someone. 🙂

View solution in original post

1 Reply
Kritika_Dhanbhar
Contributor II
Contributor II
Author

I found the solution!

I did this by Pivoting the table in data set like:

Kritika_Dhanbhar_0-1677005367476.png

I have aggregated all the expenses,teamCosts,Remaining budget values for each client by pivoting it.And then transformed it as shown.

Hope this helps someone. 🙂