Creating a chart from grouped data

ahmadofatfat · 2024-10-13T07:34:07.486Z

Hello,

I have a datatype called Locations which contains simply a list of Reviews (also a datatype). Reviews contains a list of Google Reviews. One of the columns of this data is called meal type (where people who posted a google review would mention if they had dinner, lunch, etc).

I want to create a chart which simply shows me a bar chart of how many reviews included dinner versus the ones that included lunch etc…

Sample of the review datatype:

Row 1:
Review:
the food was spectacular

Meal Type:
Dinner

Row 2:

Review:
The restaurant is not kid friendly

Meal Type:
Lunch

I’m not being able to generate a good chart, it is looking messed up (by the way I’m using the data just fine, the rest of the elements I’ve created from the data all look fine, the only problem is this chart) so there must be a problem with my data source, or value expression or label expression… Any help?

anon79941647 · 2024-10-13T08:28:15.908Z

Can you send me a message?

ahmadofatfat · 2024-10-13T08:59:09.546Z

I don’t understand, how?

kirsnvartem · 2024-10-13T20:00:35.385Z

@ahmadofatfat Hi! I might miss some details since I can’t see your app structure. For each Google review, create a review in your database linked to the Google review. I don’t think you need a separate data type for “review” and “Google review” — it’s better to store the Google review link as a field on the review data type. You can also automatically create a new review entry in your app whenever a new Google review is added.

You have Locations and Reviews. For each review, you have a meal type and a score. Everything seems pretty straightforward here. Pick a nice chart plugin, and you’re good to go!

ahmadofatfat · 2024-10-14T05:26:57.144Z

Hey @kirsnvartem
There are no separate data types. Just one review data type.
The issue I’m posting about is not related to managing the data in any way. It’s about creating the chart in itself. I’m talking about the Line/Bar chart element and how to populate its data:

Data Source
Value Expression
Label Expression

system · 2024-12-22T07:34:23.103Z

This topic was automatically closed after 70 days. New replies are no longer allowed.