Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SAMPLE has made me sad, please help #625

Open
rahmad010 opened this issue Dec 30, 2022 · 3 comments
Open

SAMPLE has made me sad, please help #625

rahmad010 opened this issue Dec 30, 2022 · 3 comments
Labels
🐞 Bug Issue with one of the samples

Comments

@rahmad010
Copy link

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.
image

@rahmad010 rahmad010 added the 🐞 Bug Issue with one of the samples label Dec 30, 2022
@rahmad010
Copy link
Author

Can someone please help me out here

@Fedes365
Copy link
Contributor

Fedes365 commented Jan 3, 2023

@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
Copy link
Author

@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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
🐞 Bug Issue with one of the samples
Projects
None yet
Development

No branches or pull requests

2 participants