Expand my Community achievements bar.

The Community Ideas review for H1 2025 is out now, see which ideas our Product team prioritized and let us know your thoughts.

Best practice for structuring data

Avatar

Level 2

I have a team who is using a calendar to show tasks. They want to group the tasks using a field the field. Problem is the fields is a text field. Obviously this isn't going to work. I know I need to structure the field with a multi-select dropdown or checkbox group because the projects can be associated with more than one value in this field. I'm also fairly certain that I can create calculated fields for each value and have them populate so that I have them as discreet values - and build the calendar using these. However, I'm wondering what the best practice is when creating a report and grouping these, i.e. is there a way to show the totals of projects by these values other than making separate reports for each calculated field and showing them together on a dashboard? 

1 Reply

Avatar

Level 1

Hello , 

 

I would like to know more about it, Can you give me demo.