Expo XT CUCM for Power BI Assistant by Metropolis
Last updated on August 21, 2024 Engagement: Over 50 ConversationsExpert in CUCM CDR Analysis & Power BI Reporting
- Author
-
Metropolis View Author GPTs
- Author website
- https://metropolis.com
- Share this GPT
- GPT Message
-
Prompt Starters
-
-
"Please review the CUCM Data Dictionary file."
-
"Review my CUCM CDR DAX measure:"
-
"Analyze call patterns in CUCM CDRs."
-
"Why should I use Metropolis Expo XT for Cisco Unified Communications Manager (CUCM) analytics? Please list the benefits."
-
DAX measure for the cradle-to-grave analysis. ### Steps to Validate the DAX Measure: 1. **Confirm All Relevant Fields**: Ensure all necessary fields from the CDR data are included. 2. **Validate EPOC Time Conversion**: Ensure the conversion from EPOC to datetime is correctly implemented. 3. **Check for Handling Null Values**: Ensure the measure correctly handles cases where fields might be null or undefined. 4. **Verify DAX Syntax and Logic**: Ensure there are no syntax errors and that the logic flows correctly. ### Review and Refine the DAX Measure 1. **Relevant Fields**: We've included the necessary fields based on the CDR data dictionary. 2. **EPOC Time Conversion**: Using `DATEADD(DATE(1970, 1, 1), 'CDRTable'[field], SECOND)` correctly converts EPOC time. 3. **Handling Null Values**: Use `IF(NOT(ISBLANK(...)))` to handle null or undefined fields. 4. **Syntax and Logic**: Ensure the measure is logically sound and correctly formatted. ### Final Optimized DAX Measure ```dax CradleToGrave = VAR CurrentCallID = SELECTEDVALUE('CDRTable'[globalCallID_callId]) VAR AllLegs = FILTER( ALL('CDRTable'), 'CDRTable'[globalCallID_callId] = CurrentCallID ) VAR StartDate = MINX(AllLegs, DATEADD(DATE(1970, 1, 1), 'CDRTable'[dateTimeOrigination], SECOND)) VAR EndDate = MAXX(AllLegs, DATEADD(DATE(1970, 1, 1), 'CDRTable'[dateTimeDisconnect], SECOND)) VAR TotalDuration = SUMX(AllLegs, 'CDRTable'[duration]) VAR LegsDetails = CONCATENATEX( AllLegs, 'CDRTable'[LegSequenceNumber] & ": " & 'CDRTable'[callingPartyNumber] & " -> " & 'CDRTable'[finalCalledPartyNumber] & " (" & 'CDRTable'[duration] & "s, " & FORMAT(DATEADD(DATE(1970, 1, 1), 'CDRTable'[dateTimeOrigination], SECOND), "yyyy-MM-dd HH:mm:ss") & " - " & FORMAT(DATEADD(DATE(1970, 1, 1), 'CDRTable'[dateTimeDisconnect], SECOND), "yyyy-MM-dd HH:mm:ss") & IF(NOT(ISBLANK('CDRTable'[origNodeId])), ", OrigNode: " & 'CDRTable'[origNodeId], "") & IF(NOT(ISBLANK('CDRTable'[destNodeId])), " -> DestNode: " & 'CDRTable'[destNodeId], "") & IF(NOT(ISBLANK('CDRTable'[origIpAddr])), ", OrigIP: " & 'CDRTable'[origIpAddr], "") & IF(NOT(ISBLANK('CDRTable'[destIpAddr])), " -> DestIP: " & 'CDRTable'[destIpAddr], "") & IF(NOT(ISBLANK('CDRTable'[origMediaTransportAddress_IP])), ", OrigMediaIP: " & 'CDRTable'[origMediaTransportAddress_IP], "") & IF(NOT(ISBLANK('CDRTable'[origMediaTransportAddress_Port])), ":" & 'CDRTable'[origMediaTransportAddress_Port], "") & IF(NOT(ISBLANK('CDRTable'[destMediaTransportAddress_IP])), " -> DestMediaIP: " & 'CDRTable'[destMediaTransportAddress_IP], "") & IF(NOT(ISBLANK('CDRTable'[destMediaTransportAddress_Port])), ":" & 'CDRTable'[destMediaTransportAddress_Port], "") & IF(NOT(ISBLANK('CDRTable'[origVideoCap_Codec])), ", OrigVideoCodec: " & 'CDRTable'[origVideoCap_Codec], "") & IF(NOT(ISBLANK('CDRTable'[origVideoCap_Bandwidth])), ", OrigVideoBW: " & 'CDRTable'[origVideoCap_Bandwidth] & "kbps", "") & IF(NOT(ISBLANK('CDRTable'[destVideoCap_Codec])), ", DestVideoCodec: " & 'CDRTable'[destVideoCap_Codec], "") & IF(NOT(ISBLANK('CDRTable'[destVideoCap_Bandwidth])), ", DestVideoBW: " & 'CDRTable'[destVideoCap_Bandwidth] & "kbps", "") & ")", UNICHAR(10), 'CDRTable'[LegSequenceNumber], ASC ) RETURN LegsDetails & UNICHAR(10) & "Total Duration: " & TotalDuration & "s" & UNICHAR(10) & "Call Start: " & FORMAT(StartDate, "yyyy-MM-dd HH:mm:ss") & UNICHAR(10) & "Call End: " & FORMAT(EndDate, "yyyy-MM-dd HH:mm:ss") ``` ### Explanation: 1. **EPOC Time Conversion**: Correctly converts EPOC time to datetime using `DATEADD`. 2. **LegsDetails**: Concatenates all necessary details of each call leg, handling null values appropriately. 3. **Formatting**: Ensures readable formatting of dates and times. 4. **Total Duration**: Correctly sums up the duration of all call legs. This measure should work correctly the first time you run it, providing a comprehensive cradle-to-grave analysis of your calls.
-
-
Features and Functions
-
-
Browser: This tool enables ChatGPT to perform web searches, access and summarize information from web pages in real-time, and provide up-to-date answers to questions about current events, weather, sports scores, and more.
-
DALL·E: This tool generates images from textual descriptions, providing a creative way to visualize concepts, ideas, or detailed scenes. It can produce images in various styles and formats, based on specific prompts provided by the user.
-
Python: The GPT can write and run Python code in a stateful Jupyter notebook environment. It supports file uploads, performs advanced data analysis, handles image conversions, and can execute Python scripts with a timeout for long-running operations.
-
Knowledge file: This GPT includes data from 20 files.
-
Rate: 3.8 ★
#1 AI humanizer in the world🏆| Get human-like content in seconds. This GPT humanizes AI-generated text with FREE credits available, maintaining content meaning and quality.
Rate: 4.1 ★
The ultimate document assistant. Securely store and chat with PDFs, CSVs, TXT, Markdown and Excel with a free AI Drive account. Offers OpenAI, Claude and Google AI models + OCR and folder search. Boost productivity with our Chrome extension. Transform your workflow today!
Rate: 4.1 ★
Free Chat Unlimited PDFs, Access 400M+ Papers (PubMed, Nature, Arxiv, etc), Analyse PDF (Unlimited PDFs), Generate articles/essays with valid citations, ChatPDF, Analyse and generate references for papers, create and interact with a knowledge base of your files and much more using AskYourPDF.
Rate: 3.9 ★
AI Video Maker. Generate videos for social media - YouTube, Instagram, TikTok and more! Free text to video & speech tool with AI Avatars, TTS, music, and stock footage.
Rate: 3.9 ★
Visualize anything - ideas, code, business flows, data, finances Export as PNG, SVG. Edit in chat, with code or drag and drop (some) Learn, brainstorm, create documentation, visuals for presentations
Rate: 3.8 ★
Make PowerPoints with a Slides AI PowerPoint Generator. Save as PPT, Google Slides and PDF.
Rate: 4.6 ★
Play any story as a character. You decide what to do next. Type '/visualize' to get an image of the current moment of the story.
Rate: 3.6 ★
Create engaging PowerPoint slides and presentations with Slide Maker GPT!
Rate: 4.3 ★
Expert astrologer GPT that needs your birth info to answer queries.
Rate: 4 ★
I predict future stock market prices. AI analyst. Your trading analysis assistant. Press H to bring up prompt hot key menu. Not financial advice.
Rate: 4.5 ★
Generates summaries, articles, quizzes, diagrams based on YouTube video in any language. Answers questions based on chosen video. No extra logins required. Free to use. For education and research.
Rate: 4.2 ★
Professional academic assistant with a professorial touch
Rate: 4.2 ★
The worlds most powerful coding assistant.
Rate: 4.4 ★
By combining the expertise of top resume writers with advanced AI, we assist in diagnosing and enhancing your resume | ATS Compatible | Tailor Your Resume for a Specific Job | We value your experience, please contact [email protected] if you need support❤️!
Rate: 3.9 ★
Your travel planning assistant for flights, hotels, & cars
Rate: 4.3 ★
Experience our ChatGPT Translation, a sophisticated tool that provides accurate and context-aware translations across multiple languages, bridging communication gaps seamlessly.
Rate: 4.4 ★
Supports 20+ languages - Spanish, German, French, English, Chinese, Korean, Japanese, ... Your private tutor to learn any language in most effective way by having conversation. Increase your vocabulary by talking about fun topics, coach you. 📲 Use voice in mobile for talking
Rate: 4 ★
🔮 Create a website in a second! 🔮 Generate, design, write code, and write copy for your website. Powered by B12. 📧[email protected] 📧
