Converter 1
LangChain Hub prompt: lee-create-calc/converter_1
You are given a screenshot taken from a BI tool and the semantic model of the query. please fill the requested fields based on the image.
"the semantic model is comprised of 2 separate lists of columns: 1) Model Attributes 2) Model Measures.Never make up measures and attributes that do not appear in this list!\nthe following is the list of available Model Attributes and their metadata where each line on the list is formatted as \n'(attribute_name, the one needed as result to functions)': [caption->(member caption, as a user will call it),category->(type of attribute)]\nif a synonym is used, treat it as the user talked about its matching attribute_name\nStart of Model Attributes List\n'[customerProfile].[Marital Status]': caption->'Marital Status'\n'[customerProfile].[Gender]': caption->'Gender'\n'[customerProfile].[Education]': caption->'Education'\n'[customerProfile].[Occupation]': caption->'Occupation'\n'[customerProfile].[Home Owner]': caption->'Home Owner'\n'[customerProfile].[Commute Distance]': caption->'Commute Distance'\n'[customerProfile].[Purchased Bike]': caption->'Purchased Bike'\n'[customers].[FirstName]': caption->'FirstName'\n'[customers].[LastName]': caption->'LastName'\n'[customers].[Address]': caption->'Address', category->'GeoAddress'\n'[customers].[City]': caption->'City', category->'GeoCity'\n'[customers].[County]': caption->'County', category->'GeoCounty'\n'[customers].[State]': caption->'State', category->'GeoState'\n'[customers].⟨ZIP⟩': caption->'ZIP', category->'GeoZip'\n'[customers].[Phone]': caption->'Phone'\n'[customers].[Email]': caption->'Email'\n'[customers].[Country]': caption->'Country', category->'GeoCountry'\n'[customers].[wiki]': caption->'wiki', category->'Url'\n'[distribution].[user]': caption->'user'\n'[distribution].[email]': caption->'email'\n'[manufacturer details].[Manufacturer Grouping]': caption->'Manufacturer Grouping'\n'[manufacturer details].[Market]': caption->'Market'\n'[manufacturers].[Manufacturer]': caption->'Manufacturer'\n'[products].[Product]': caption->'Product'\n'[products].[Product Sub Category]': caption->'Product Sub Category'\n'[products].[Product Category]': caption->'Product Category'\n'[products].[Color]': caption->'Color'\n'[products].[Size]': caption->'Size'\n'[products].[Weight]': caption->'Weight'\n'[products].[Class]': caption->'Class'\n'[products].[Style]': caption->'Style'\n'[products].[ModelName]': caption->'ModelName'\n'[products].[StandardCost]': caption->'StandardCost'\n'[products].^[products Hierarchy]': caption->'products Hierarchy'\n'[promotions].[Promotion]': caption->'Promotion'\n'[promotions].[Promotion Category]': caption->'Promotion Category'\n'[promotions].[Promotion Type]': caption->'Promotion Type'\n'[regions].[Region]': caption->'Region'\n'[transactions].[transactionID]': caption->'transactionID'\n'[transactions].[Date]': caption->'Date', category->'DateTime', data type->'DateTime'\n'[transactions].[Date year]': caption->'Date year', category->'Date'\n'[transactions].[Date full quarter]': caption->'Date full quarter'\n'[transactions].[Date full quarter start date]': caption->'Date full quarter start date', category->'DateTime', data type->'DateTime'\n'[transactions].[Date full month name]': caption->'Date full month name'\n'[transactions].[Date full month start date]': caption->'Date full month start date', category->'DateTime', data type->'DateTime'\n'[transactions].[Date full week]': caption->'Date full week'\n'[transactions].[Date full week start date]': caption->'Date full week start date', category->'DateTime', data type->'DateTime'\n'[transactions].[Date month name]': caption->'Date month name'\n'[transactions].[Date weekday name]': caption->'Date weekday name'\n'[transactions].[Date time]': caption->'Date time', category->'DateTime', data type->'DateTime'\n'[transactions].[Date date]': caption->'Date date', category->'DateTime', data type->'DateTime'\n'[transactions].[Kmeans Clusters]': caption->'Kmeans Clusters'\n'[transactions].^[Date Hierarchy]': caption->'Date Hierarchy'\nEnd of Model Attributes List\n\nthe following is the list of available Model Measures and their metadata where each row on the list is formatted as '': [''->'', ...]:\nStart of Model Measures List\n'[measures].[transactions happiness]': caption->'happiness'\n'[measures].[transactions Quantity]': caption->'Quantity'\n'[measures].[transactions returns]': caption->'returns'\n'[measures].[transactions Sales]': caption->'Sales'\n'[measures].[transactions Expenses]': caption->'Expenses'\n
'[measures].[transactions cost]': caption->'Cost'\n
End of Model Measures List\n"
This prompt contains variables shown as ⟨variable_name⟩. Replace them with your own values before using.
How to Use
Use with LangChain: hub.pull("lee-create-calc/converter_1")
Related Prompts
More prompts in Creative & Design
Midjourney Prompt Generator
Outputs four extremely detailed midjourney prompts for your keyword.
Convert Your Small And Lazy Prompt Into A Detailed And Better Prompts With This Template.
Convert your small and lazy prompt into a detailed and better prompts with this template.
One Click Personalized Workout and Diet Plan
With just one click, create a personalized diet and exercise plan. Just enter the information.
learning new skill
Looking to learn or improve a specific skill but have no prior experience? Here's a 30-day learning plan designed specifically for beginners like you. Whether you're interested in coding, cooking, photography, or anything in between, this plan will help you build a solid foundation and make steady progress towards your goal. Each day, you'll have a specific task or activity to complete, ranging from watching instructional videos to practising hands-on exercises. The plan is designed to gradually increase in complexity as you build your knowledge and skills, so you can start with the basics and steadily work your way up. By the end of the 30 days, you should have a solid understanding of the fundamentals of your chosen skill, as well as a set of practical techniques and strategies to help you continue improving in the future. So, whether you're looking to learn a new hobby or develop a new professional skill, this 30-day learning plan is the perfect place to start.
FitnessGPT v2: One-Click Personal Trainer
An upgraded version of DigitalJeff's original 'One Click Personal Trainer' prompt.
MoneyMindGPT - Your AI-Powered Personal Financial Advisor
MoneyMindGPT is an AI-powered financial advisor that offers personalized guidance to improve your financial health. It helps you with budgeting, saving, investing, and debt reduction by creating custom plans based on your unique needs. Accessible and easy to use, MoneyMindGPT supports you on your journey to financial success.