Quick Help! Complex Issue - Quick Chart, Lookup (Count Related), and a Number Column

%3CLINGO-SUB%20id%3D%22lingo-sub-3290957%22%20slang%3D%22en-US%22%3EQuick%20Help!%20Complex%20Issue%20-%20Quick%20Chart%2C%20Lookup%20(Count%20Related)%2C%20and%20a%20Number%20Column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3290957%22%20slang%3D%22en-US%22%3E%3CP%3ELooking%20for%20some%20quick%20advice%20please!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20list%20of%2C%20essentially%2C%20individual%20projects%20with%20data.%20I%20need%20to%20be%20able%20to%20count%20the%20number%20of%20projects%20associated%20with%20each%20Department.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ZachJayy_0-1650486556937.png%22%20style%3D%22width%3A%20521px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F365662i41DA50ACFF0B17AF%2Fimage-dimensions%2F521x138%3Fv%3Dv2%22%20width%3D%22521%22%20height%3D%22138%22%20role%3D%22button%22%20title%3D%22ZachJayy_0-1650486556937.png%22%20alt%3D%22ZachJayy_0-1650486556937.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20done%20this%20by%20making%20a%20second%20list%20of%20departments%20with%20an%20associated%20Lookup%20(Count%20Related)%20column.%20Now%2C%20my%20issue%20is%20that%20I%20want%20to%20pull%20the%20data%20of%20this%20second%20list%20(Departments%20and%20Counts)%20into%20a%20Quick%20Chart%20web%20part%20on%20the%20homepage.%20The%20values%20of%20the%20Lookup%20column%20aren't%20available%20to%20select%20for%20the%20Quick%20Chart%2C%20presumably%20because%20they%20aren't%20numbers.%20So%20I%20created%20an%20additional%20column%20and%20used%20column%20formatting%20to%20set%20it%20equal%20to%20that%20lookup%20value%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ZachJayy_1-1650486798033.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F365663iE86E585102171BCA%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22ZachJayy_1-1650486798033.png%22%20alt%3D%22ZachJayy_1-1650486798033.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ZachJayy_2-1650486858731.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F365665iB6FDDF3EEFCB0B34%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22ZachJayy_2-1650486858731.png%22%20alt%3D%22ZachJayy_2-1650486858731.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUsing%20this%20JSON%3A%3C%2FP%3E%3CDIV%3E%3CDIV%3E%3CSPAN%3E%7B%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%22%24schema%22%3C%2FSPAN%3E%3CSPAN%3E%3A%3C%2FSPAN%3E%20%3CSPAN%3E%22%3CA%20href%3D%22https%3A%2F%2Fdeveloper.microsoft.com%2Fjson-schemas%2Fsp%2Fv2%2Fcolumn-formatting.schema.json%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdeveloper.microsoft.com%2Fjson-schemas%2Fsp%2Fv2%2Fcolumn-formatting.schema.json%3C%2FA%3E%22%3C%2FSPAN%3E%3CSPAN%3E%2C%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%22elmType%22%3C%2FSPAN%3E%3CSPAN%3E%3A%3C%2FSPAN%3E%20%3CSPAN%3E%22div%22%3C%2FSPAN%3E%3CSPAN%3E%2C%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%22txtContent%22%3C%2FSPAN%3E%3CSPAN%3E%3A%3C%2FSPAN%3E%20%3CSPAN%3E%22%3DNumber(%5B%24Count%5D)%22%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7D%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3EThis%20new%20column%20is%20correctly%20mirroring%20the%20lookup%20column.%20It's%20set%20up%20as%20a%20%22Number%22%20column.%20And%20it%20is%20available%20in%20the%20Quick%20Chart%20configuration%20for%20selection.%20However%2C%20when%20I%20select%20it%20for%20the%20Quick%20Chart%2C%20the%20chart%20is%20pulling%20zeros%20all%20the%20way%20across%20despite%20there%20being%201s%20and%202s%20in%20that%20column%20as%20a%20result%20of%20the%20lookup.%26nbsp%3B%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%3CSPAN%3EWhen%20I%20open%20a%20specific%20item%2C%20though%2C%20there%20is%20no%20value%20in%20this%20column%20despite%20the%20column%20formatting%20populating%20a%20value%3A%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ZachJayy_0-1650518626838.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F365746i54381CA30AD93347%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22ZachJayy_0-1650518626838.png%22%20alt%3D%22ZachJayy_0-1650518626838.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ZachJayy_1-1650518647797.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F365747i3F51F45E87197287%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22ZachJayy_1-1650518647797.png%22%20alt%3D%22ZachJayy_1-1650518647797.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3EWhy%20is%20this%20happening%3F%3C%2FP%3E%3CSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3290957%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Looking for some quick advice please!

 

I have a list of, essentially, individual projects with data. I need to be able to count the number of projects associated with each Department.

ZachJayy_0-1650486556937.png

 

I have done this by making a second list of departments with an associated Lookup (Count Related) column. Now, my issue is that I want to pull the data of this second list (Departments and Counts) into a Quick Chart web part on the homepage. The values of the Lookup column aren't available to select for the Quick Chart, presumably because they aren't numbers. So I created an additional column and used column formatting to set it equal to that lookup value:

ZachJayy_1-1650486798033.png

ZachJayy_2-1650486858731.png

 

Using this JSON:

{
"elmType": "div",
"txtContent": "=Number([$Count])"
}
 
This new column is correctly mirroring the lookup column. It's set up as a "Number" column. And it is available in the Quick Chart configuration for selection. However, when I select it for the Quick Chart, the chart is pulling zeros all the way across despite there being 1s and 2s in that column as a result of the lookup. 
 
When I open a specific item, though, there is no value in this column despite the column formatting populating a value:
ZachJayy_0-1650518626838.pngZachJayy_1-1650518647797.png

Why is this happening?



 

0 Replies