Pyramid Open AI Evaluation

Fabian_Frank
11 mths ago
7replies
Answered

Hey there,

we are currently discussing the open ai integration in pyramid to integrate and therefore need to test that functionality upfront. I cant find the open ai integration in the pyramid explore server and the documentation is not clear about the exact features (where it can be used, what it can do etc..). Is there a way to test it somewhere? Or to get more details and examples about it?

Thank you,

Fabian

ChatGPT

- NPANS
- 11 mths ago
- Reported - view
If you go to online help, and search for "OpenAI" you'll find all the details you are after. It's pretty clear, explicit and enumerates every feature that is currently offered.
- Fabian_Frank
- 11 mths ago
- Reported - view
I dont think so, the only doc being a candidate like that is https://help.pyramidanalytics.com/Content/Root/Guides/AI/GenerativeAIintegration.htm?Highlight=openai in my opinion., But its lacking the description to query data in Tabulate or Discover, which I found out today is available?
- Nkhensani_Khoza
  
  11 mths ago
  
  Official response
  
  Reported - view
  Hey
  
  The document you reference explains where you can use OpenAI and where it is available for you to use. Yes OpenAI is also available in Tabulate and Discover. You can test it in the explore server, it is available there!
  
  You can also spot OpenAI by the chatGPT logo: The below examples are completed in the Explore server.
  
  1. in Discover here is an example in the Explore server.
  
  as stated in the help guide, it is also available in other areas in discover . These values generated by OpenAI can be used and integrated with your data
  
  2. In tabulate is available in generating scripts to build spreadsheet formulas
  
  Kind Regards
  
  Nkhensani Khoza
- Fabian_Frank
  
  10 mths ago
  
  Reported - view
  thanks for your help :)
- Fabian_Frank
- 10 mths ago
- Reported - view
can someone tell me how to use the discover function efficiently and refer to data? it seems that chatgpt does not have any clue about the data. Is that even possible?
- Fabian_Frank
  
  10 mths ago
  
  Reported - view
  An example use case would be "what is the highest population" and add that in a dataset.
  
  For example like in pandas alike:
  
  df["AI Driven Value Year (7)"] = df["Population"].max()
- imbarmarinescubar_pyram
  
  10 mths ago
  
  Reported - view
  The ChatGpt function within the Formula designer does not have any context that is not given to it directly.
  Also, like any other Formula, it is calculated in the scope of the datapoint that you are looking at.
  So, you can write something like this:
  
  chatGpt("what is the capital? for: " + [customers].[Country].currentmember.caption)
  
  Which will inject the country from the grid, producing:
  
  To do something like maximum population, use the Max function wrapping a chatGpt population question:
  
  max([customers].[Country].allmembers, chatGpt("What is the population size? for: " +[customers].[Country].currentmember.caption + ". Return result as a number"))
  
  (I have USA in the bottom of the grid)