I have a page in Business Central that displays all the food records I’ve submitted for our company. For testing purposes, I created five food types — BURGER, NOODLES, STEAK, PASTA, and FRIED CHICKEN — and entered records spanning a full year. Additionally, I added three extra months of entries for two of the food types (BURGER and NOODLES), resulting in approximately 66 records in total (12 per food type, plus 6 extra).
Now, I’d like to visualize this data using built-in tools or controls available within Business Central. Right now, the list of food entries is too long and difficult to interpret at a glance, particularly for company executives. A visual representation would make the data much easier to understand and present.
All the data is stored in a table, which includes a field called Food Name, containing values such as BURGER, NOODLES, STEAK, PASTA, and FRIED CHICKEN. I want to visualize the contents of this table on a Card or List page, ideally in the form of charts or graphs.
