Table as a KB
# 🤝helpp
purple-dream-91712
02/15/2024, 8:15 AMI am having problems with KB understanding my table. It has some trending stories' titles, descriptions, conversation sizes, dates, cities, and supporting URLs. But I have been trying to make use of it for the past week and changed the formatting of the table multiple times with no luck. What should I do?
(Report ID: 71520428-0e35-42d5-b12b-a34a08b3847a)
f
flat-plumber-75402
02/16/2024, 3:39 PMHello @purple-dream-91712 can you walk me through your use case please?
p
purple-dream-91712
02/18/2024, 8:32 AMHello Sara! I am trying to use to in order to archive/update trending stories and news alerts over a period of time. Then retrieve the most trending via the chatbot using queries like what's the most trending story in 2023..
f
flat-plumber-75402
02/23/2024, 6:36 PMHow are quantifying trending?
p
purple-dream-91712
03/03/2024, 9:15 AMThere is a number of "trending" (200K) ..
f
flat-plumber-75402
03/04/2024, 9:07 PMCan you send me a screenshot of the table please?
p
purple-dream-91712
03/06/2024, 8:21 AMHere is a part of it. I tried deleting _2 but it did not work
f
flat-plumber-75402
03/06/2024, 9:04 PMSo Trending is being pulled from an API?
p
purple-dream-91712
03/10/2024, 11:24 AMNo its a number
f
flat-plumber-75402
03/11/2024, 8:08 PMHow is the number the being created?
p
purple-dream-91712
03/12/2024, 8:09 AMits a static number that is imported from a table
purple-dream-91712
03/12/2024, 9:02 AMMy problem is that I tried importing the same dataset into another table in another bot and it just showed null.
f
flat-plumber-75402
03/12/2024, 8:21 PMOkay so I am looking back at your screenshot from 6 March The trending column is not set to be searchable. How I know is the 123 next to Trending is not blue. Try making the column searchable, click on the 123 next to the name, toggle searchable to true, and click confirm, and let me know if you are still having the same problem.
p
purple-dream-91712
03/13/2024, 8:37 AMThanks a lot! Will try it
purple-dream-91712
03/13/2024, 8:45 AMIt worked but still, there is a problem with it sorting the stories based on trend or conversation size. when asked about most trending story in 2023 for example, it just pulls a random number. Is there any way to get it to understand the ranks and the trends?
f
flat-plumber-75402
03/13/2024, 5:55 PMHave you added descriptions to the columns in your table? Click on the symbol next to the name of the column and you can add in a description.
flat-plumber-75402
03/13/2024, 5:57 PMThe other thing you can also do is work with Knowledge base query card and specify what to look at when here is a brief example of what I did that was listing all the topics in a table for a demo
p
purple-dream-91712
03/14/2024, 9:16 AMThanks a lot for these tips! They are super helpful, but there is a weird thing because it says "an interaction rate of 0.141", instead of the number in the coloumn
purple-dream-91712
03/14/2024, 9:31 AMI think that's what is making sorting inaccurate
purple-dream-91712
03/14/2024, 9:32 AMbecause the main problem is the random choice of stories although the numbers show how big is it
f
flat-plumber-75402
03/14/2024, 12:25 PMhmmmm have you tried creating a selector and then calling the data from that selector?
https://botpress.com/docs/cloud/studio/tables/#query-selector
https://botpress.com/docs/cloud/studio/tables/#re-using-filters-selectors
p
purple-dream-91712
03/17/2024, 12:40 PMI am trying to implement that, but I am not sure I fully understand how will this serve the purpose. Because I need it to perform a relative comparison between stories at a given date.
f
flat-plumber-75402
03/18/2024, 7:12 PMThe selector will be filter on your table so you can set the selector for a given date. It will in turn only return the pertinent rows and return that information. You can then use an AI task to run on the data returned from the selector.