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