Display pivot table like chart on SharePoint page

%3CLINGO-SUB%20id%3D%22lingo-sub-1999341%22%20slang%3D%22en-US%22%3EDisplay%20pivot%20table%20like%20chart%20on%20SharePoint%20page%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1999341%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20in%20advance%20for%20your%20help.%3C%2FP%3E%3CP%3EI%20have%20a%20list%20with%202%20date%20and%20time%20columns%20along%20with%20a%20user%20column%20that%20I%20use%20to%20collect%20when%20paperwork%20was%20turned%20in.%20I%20have%20a%20calculated%20column%20that%20subtracts%20when%20it%20should%20have%20been%20turned%20in%20and%20when%20it%20was%20to%20give%20me%20how%20long%20it%20took%20them.%20Our%20goal%20is%204%20hours%20or%20less%20so%20I%20have%20a%20view%20that%20shows%20the%20last%2030%20days%20based%20on%20user.%20In%20the%20view%20I%20have%20it%20grouped%20by%20user%20and%20have%20Totals%20set%20to%20show%20the%20average%20of%20a%20column%20that%20is%20simply%20a%20mirror%20of%20the%20calculated%20column%20(because%20you%20can't%20do%20totals%20on%20a%20calculated%20columns.%20I%20use%20Power%20Automate%20to%20mirror%20them).%3C%2FP%3E%3CP%3EIn%20the%20view%20if%20I%20press%20the%20%2B%20next%20to%20the%20user%20I%20can%20see%20there%20average%20which%20is%20the%20number%20I%20want%20but%20I%20would%20like%20a%20way%20to%20not%20have%20to%20press%20the%20%2B%20and%20just%20show%20the%20user%20and%20next%20to%20them%20there%2030%20day%20average.%20Is%20that%20possible%20in%20some%20easy%20way%3F%20We%20are%20currently%20using%20ColabCharts%20but%20I%20would%20simply%20like%20it%20in%20a%20table%20form.%20Also%20as%20a%20bonus%20I%20would%20really%20like%20it%20to%20turn%20red%20should%20they%20be%20over%20the%204%20hours.%3C%2FP%3E%3CP%3EI've%20tried%20Power%20BI%20and%20I%20can%20get%20the%20chart%20but%20we%20are%20not%20licensed%20for%20my%20users%20to%20see%20it%20and%20the%20cost%20is%20a%20bit%20high%20for%20us%20to%20implement.%3C%2FP%3E%3CP%3EThanks%20again%20for%20your%20help%3C%2FP%3E%3CP%3ESean%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1999341%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

Thank you in advance for your help.

I have a list with 2 date and time columns along with a user column that I use to collect when paperwork was turned in. I have a calculated column that subtracts when it should have been turned in and when it was to give me how long it took them. Our goal is 4 hours or less so I have a view that shows the last 30 days based on user. In the view I have it grouped by user and have Totals set to show the average of a column that is simply a mirror of the calculated column (because you can't do totals on a calculated columns. I use Power Automate to mirror them).

In the view if I press the + next to the user I can see there average which is the number I want but I would like a way to not have to press the + and just show the user and next to them there 30 day average. Is that possible in some easy way? We are currently using ColabCharts but I would simply like it in a table form. Also as a bonus I would really like it to turn red should they be over the 4 hours.

I've tried Power BI and I can get the chart but we are not licensed for my users to see it and the cost is a bit high for us to implement.

Thanks again for your help

Sean

0 Replies