Thank you for the video and valuable content. I'm interested in exploring the opportunity to generate charts for SharePoint usage, activity, and file storage using JSON. Could you please provide guidance on how to proceed? Your advice is appreciated.
Hi, Many thanks for following my videos. Check this article which explains where to read all these info learn.microsoft.com/en-us/microsoft-365/admin/activity-reports/sharepoint-site-usage-ww?view=o365-worldwide
Is there any way to make a chart with rows form a list vs. columns like in this example? This example looks like it is just one row w. multiple columns. I'd like to do one chart for multiple rows. right now, when applying this json, you get a chart for every row.
I have the same need as @danyell12345. It's not another chart that is of use here. It is to make each row a new bar in the one chart. Hence the code mustgo from field to row. But I guess that is at pretty different code? :) @@DeLucaGiulian
Great efforts by the creator! ❤👏👏Very handy and i really like it. Thanka for sharing this!! Just that, it has its limitations like number of bars can't be more and works good for static data, we cant have data updates automatically and expect the charts to be refreshed. But, must say, great work by creator, atleast we can have something visual from the SharePoint lists, this must be basic actually developed by Microsoft already.
Great video... very creative I must say. just wanted to check if the list get refreshed with new data, does the charts also get refreshed?. Many thanks..
@@DeLucaGiulian Thanks for the quick response. Your page have very good content.I have a small request if you dont mind. It would be great if you can create a video on your journey to become an MVP, how you achieved it and any advises for any apsiring MVPs here. Thanks
Is there a way to display amounts of something? For example: A list with 3 columns and 5 rows. Columns: Name, Status, and Location. Rows: Name = (1,2,3,4,5), Status (Good, Good, Good, Good, Bad), and Location = (a, a, b, c, b). Bar chart for status: 2 bars, good and bad. Pie Chart for location, a, b, and c.
Hi, The inline editing function update immediately the value of the field in the list, you can't pullout previous values. Eventually you can use the version history function to restore previous values in the list.
Oh sorry missed that! My goal is to make roadmap-view based on a horizontal stacked bar chart. This requires that the bars/timeslots is based on a new row and not by column. But if I add a second row I get a second bar chart. Any idea on how this could be managed? @DeLucaGiulian
![Digital Circus Episode 4 [TRAILER]](http://i.ytimg.com/vi/abZtsmMUbJo/mqdefault.jpg)
how did you create the chart view in the list .. I am not getting that view option to switch from All Documents please explain ...
It was a lot of content and great work from the creator of the formatting.
Thanks, very impressive, all in JSON without going through PowerBI to get graphics.
Glad I could help!
Thank you for the video and valuable content. I'm interested in exploring the opportunity to generate charts for SharePoint usage, activity, and file storage using JSON. Could you please provide guidance on how to proceed? Your advice is appreciated.
Hi,
Many thanks for following my videos.
Check this article which explains where to read all these info
learn.microsoft.com/en-us/microsoft-365/admin/activity-reports/sharepoint-site-usage-ww?view=o365-worldwide
Is there any way to make a chart with rows form a list vs. columns like in this example? This example looks like it is just one row w. multiple columns. I'd like to do one chart for multiple rows. right now, when applying this json, you get a chart for every row.
Hi,
Just add a new row with different values for instance and you should see another chart showing up
I have the same need as @danyell12345. It's not another chart that is of use here. It is to make each row a new bar in the one chart. Hence the code mustgo from field to row. But I guess that is at pretty different code? :) @@DeLucaGiulian
Great efforts by the creator! ❤👏👏Very handy and i really like it. Thanka for sharing this!! Just that, it has its limitations like number of bars can't be more and works good for static data, we cant have data updates automatically and expect the charts to be refreshed. But, must say, great work by creator, atleast we can have something visual from the SharePoint lists, this must be basic actually developed by Microsoft already.
Thanks for sharing your feedback
Great video... very creative I must say. just wanted to check if the list get refreshed with new data, does the charts also get refreshed?. Many thanks..
Hi,
Thanks for watching, yes the chart gets refreshed.
@@DeLucaGiulian Thanks for the quick response. Your page have very good content.I have a small request if you dont mind. It would be great if you can create a video on your journey to become an MVP, how you achieved it and any advises for any apsiring MVPs here. Thanks
Thanks very nice tip I'm going to do that
Is there a way to display amounts of something? For example: A list with 3 columns and 5 rows. Columns: Name, Status, and Location. Rows: Name = (1,2,3,4,5), Status (Good, Good, Good, Good, Bad), and Location = (a, a, b, c, b). Bar chart for status: 2 bars, good and bad. Pie Chart for location, a, b, and c.
I see the option for editing the values manually on the list page but can this be autopopulated by pulling in data from a previous list or query?
Hi,
The inline editing function update immediately the value of the field in the list, you can't pullout previous values.
Eventually you can use the version history function to restore previous values in the list.
Great material :) Does anyone know if it's possible to make a horizontal bar chart?
Hi,
Yes, you can have a look here:
github.com/pnp/List-Formatting/tree/master/view-samples/custom-charts
Oh sorry missed that! My goal is to make roadmap-view based on a horizontal stacked bar chart. This requires that the bars/timeslots is based on a new row and not by column. But if I add a second row I get a second bar chart.
Any idea on how this could be managed? @DeLucaGiulian
It works already in this way, if you add a second row you'll get a second corresponding chart
Super handy and easy, thanks!
Thanks 😉
Wow that’s clever!
Thanks
Wow thank you ❤🎉
@@shadowflare99 thanks
Is there any way to stop viewers of the charts from editing the values in the charts?
Hi,
Viewers with only read permission can't edit values, if they can, it means they have write permission on the list.
My "All Items" on my list page doesn't have the chart or pie view listed
Hi you can change the default view with yours view
@@DeLucaGiulian Hello! Could you please explain this further?
This kind of view not appear to me