Subitem totaling for dashboard graphs

Platform discussions
,
1

I am trying to create a graph based on the total values of the subitems. I have 5 different subitems and when i try to make a graph, the 5 subitems dont total together, they are all their own x value. Any ideas on how to add up subitem values that are similar?

2

Hi @erekson33 - it should work. What is the subitem column type you are trying to group?
Mark

1 Like
3

hey mark! thanks for the response

for example:
i have 4 different items, our company offers many different services. item 1 only wants 1 service (lets say window washing) and item 2 wants 3 services we offer (window washing, concrete wash, new paint). etc… Is there a way to total item 1 subitem of window washing with subitem 2 window washing, not the other 2 services. Each service is their own subitem

Then create a graph based on each subitem total?

Does that make sense?

4

Hey @erekson33 - this should be possible. I mocked up something quick and used a Status column to identify the service on the subitem:

image
image664Ă—769 52.8 KB

From there its just setting up your settings properly on the graph:
X-Axis:
image

Y-Axis:
image

And the final graph will group by subitem count:

image
image1070Ă—479 8.26 KB

Hope this helps!
Mark

1 Like
5

Thanks for helping me out mark!!

That is almost how it is set up. New paint should be moved to number 1, and then add a cost column. I’m wanting to add up the cost column but it is just totaling how many of window washings i am doing.

6

Hi @erekson33 - you can just change the Y Axis to the cost column:

image

Then change the X Axis the Name rather than a Status column:
image

image
image1084Ă—482 13.2 KB

7

Thank you so much!!!

8

hey @mark.anley i have another question – is it possible to change the color of the bar graphs?

9

Hi @erekson33 - if you change the graph type to a Stacked Bar graph and choose to stack it by the same “cost” column it will change the colors for you. You cannot manually choose the colors, however.

Mark

1 Like
10

I am trying to create charts based on the status of subitems but it just doesnt work for me. I even tried copying the example given above however when I try change the x-axis to status of the subitems I get no results

image
image1782Ă—936 70.2 KB

x-axis

image
image871Ă—628 16.7 KB

y-axis

image
image887Ă—717 23.9 KB

Any idea what I am doing wrong here? Trying to plot charts based on sub-items and I just can’t get it working correctly