SAMPLE has made me sad, please help

[rahmad010]

Hi Community

Sample (which sample are you having trouble with)

I am trying to repurpose/enhance formatting jason posted here - https://github.com/pnp/list-formatting/tree/master/view-samples/column-graph

What Should Happen

I am working on creating dynamic column graph format out of my Microsoft list, wanting to see status (bar graph) of open position (my MS list has a column named status that has different status including fulfilled, new, open, in-progress etc.) for different role types (PM, developer etc.) by count or assignee.

What Actually Happens

Reaching out to get your help in modifying existing jason to get the expected bar graph (than curent #views/blog).

Can you please suggest changes or share updated jason to achieve bar graph to show count of status type by role type OR count of status by value.
Attaching the list for reference.

[rahmad010]

Can someone please help me out here

[Fedes365]

@rahmad010
If I got it right, you want to create a bar chart where each bar is related to a status total count.
Example:

In progress = 50 (people)
Fulfilled = 110 (people)
New = 24 (people)
Closed = 89 (people)

In this case, I don't think it's possible to achieve that only by using JSON formatting, because JSON of Microsoft Lists is designed to fetch data within other columns of the same raw (with some exceptions related to grouping, which is not meant for creating charts).

In the sample you are referring to, as far I can see, those numbers (of views) are added manually to create that bar chart, so they won't update automatically nor a corresponding bar will update itself. Everything is done manually and the JSON code does the "magic" of getting that bar chart.

Anyway, I could also be wrong. Maybe, other experts could add some useful piece of knowledge about this case.

[rahmad010]

@Fedes365
Yes, I am wanting to see bar graph or any graph to summarize the data as you quoted above out of list.
In progress = 50 (people)
Fulfilled = 110 (people)
New = 24 (people)
Closed = 89 (people)

I also figured out the jason I am referring has no grouping logic but to display a few rows without grouping on a bar chart.
Was hoping to avoid using licensed tools like power BI and explore some native way or jason to achieve the same.
Thanks