Report Column of a Number Drop Down from a custom form | Community
Skip to main content
MattEl5
MattEl5
Level 3
October 17, 2024
Solved

Report Column of a Number Drop Down from a custom form

  • October 17, 2024
  • 2 replies
  • 671 views

Hi Folks, 

Here's what i have - Project details form with a custom field with numbers 1-10 in a drop down.
Name - ED Client Review Rounds,  Format - Number, Display - Single select dropdown.
When someone selects a number, I want that to reflect in a report column, and then a chart. 

So on the report i want it to group all the projects with 1 selected, all with 2 selected, etc etc. 
and then put that into a pie chart or a bar chart or whatever. 

Any help would be greatly appreciated! for sorting out a column thing and tips on generating a report! thanks! 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Srinija_N

Hello MattEl5,

 

you can add single-select dropdown field as the columns, grouping or chart like you would do with any other field and it should work fine. Adding sample screenshots how i did it. Hope this helps.

 

 

2 replies

MattEl5
MattEl5Author
Level 3
October 17, 2024

Srinija_N
Srinija_NAccepted solution
Level 7
October 18, 2024

Hello MattEl5,

 

you can add single-select dropdown field as the columns, grouping or chart like you would do with any other field and it should work fine. Adding sample screenshots how i did it. Hope this helps.

 

 

MattEl5
MattEl5Author
Level 3
October 18, 2024

Thank you! I think it was because i was trying to group by something else first! but the pictures really helped me follow it through. thanks again!

    Terms & ConditionsAccessibility statement

    Loading footer...