Hi All,
I have two tables. Table-1 which stores property id & property name. Table-2 which stores details about document by referencing id (from table-1) as foreign key in table-2 (column prop_id).
Using this data I need to generate a bar chart which will show top 5 documents with likeCount. So, X axis will show name of the document and Y-axis will show the likeCount.
Please share your inputs or link to post where similar use case is already addressed on how I can achieve this use case. Thank you in advance for your inputs.
Table-1:
| id | local_name |
| 1 | name |
| 2 | file_size |
| 3 | likeCount |
| 4 | country |
| 5 | city |
| 6 | pincode |
Table-2:
| id | prop_id | string_value | long_value |
| 1 | 1 | abc.docx | null |
| 1 | 2 | null | 5 |
| 1 | 3 | null | 10 |
| 1 | 4 | India | null |
| 1 | 5 | Bangalore | null |
| 1 | 6 | null | 560099 |
| 2 | 1 | test_abc.docx | null |
| 2 | 2 | null | 3 |
| 2 | 3 | null | 15 |
| 2 | 4 | India | null |
| 2 | 5 | Bangalore | null |
| 2 | 6 | null | 560099 |
Thank you.
