> ## Documentation Index > Fetch the complete documentation index at: https://docs.omni.co/llms.txt > Use this file to discover all available pages before exploring further. ## Submitting Feedback If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback: POST https://docs.omni.co/feedback ```json { "path": "/guides/patterns/simple-cohort-analysis-pivot", "feedback": "Description of the issue" } ``` Only submit feedback when you have something specific and actionable to report. # Building a basic cohort analysis with pivots > Build a cohort analysis using pivots in Omni to track user retention, engagement, and behavior over time. export const categoryIcons = { 'administration': 'lock', 'api': 'terminal', 'connections': 'database', 'dashboards': 'table-columns', 'embed': 'code', 'errors': 'exclamation', 'modeling': 'wrench', 'patterns': 'plus', 'schedules & alerts': 'envelope', 'visualizations': 'chart-column', 'workbooks': 'book' }; export const GuideSidebar = ({category, relatedLinks, updatedDate}) => { const [progress, setProgress] = React.useState(0); React.useEffect(() => { const sidebar = document.querySelector('.guide-sidebar'); if (!sidebar) return; let container = sidebar.parentElement; while (container && !container.querySelector('.guide-header')) { container = container.parentElement; } if (container && !container.classList.contains('guide-page-layout')) { container.classList.add('guide-page-layout'); } }, []); React.useEffect(() => { const handleScroll = () => { const scrollTop = window.scrollY; const docHeight = document.documentElement.scrollHeight - window.innerHeight; const scrollPercent = docHeight > 0 ? scrollTop / docHeight * 100 : 0; setProgress(Math.min(100, Math.max(0, scrollPercent))); }; window.addEventListener('scroll', handleScroll, { passive: true }); handleScroll(); return () => window.removeEventListener('scroll', handleScroll); }, []); const icon = category ? categoryIcons[category.toLowerCase()] || 'book' : 'book'; return ; }; export const GuideTitle = ({title}) => { return

{title}

; }; Create a cohort analysis to understand how specific groups of users behave over time. By comparing different cohorts, you can identify patterns in retention, engagement, or purchasing behavior. To build your initial cohort, follow these steps: 1. Choose a fixed dimension, such as the date a user was created. This date acts as your cohort identifier and should be placed on the X-axis. Cohort date field selected in the Omni query builder 2. Choose the date representing the behavior or activity you want to track. 3. [Pivot](/analyze-explore/point-click-queries) the activity date to see how activity changes over subsequent periods. Activity date pivoted in the Omni query builder 4. Choose a measure that reflects the behavior you are analyzing, such as a **Count** or **Count Distinct** of a specific action. Selected fields in the Omni query builder 5. Review the results. Omni automatically generates the "cohort triangle" visualization based on these selections. Cohort triangle results in Omni You can make your analysis more readable by applying a color scale to the table: 1. In the **Visualizations** tab, select the **Table** visualization. 2. Click the [**Conditional Formatting** tab](/visualize-present/visualizations/types/table#conditional-formatting-options) in the **Chart Options** panel. 3. For **Rule type**, select **Color Scale**. 4. In **Apply to**, select the measure to apply the scale against. This visually highlights how each cohort is performing relative to others. Table visualization with color scale applied to cohort data **Use a sequential color scale** (e.g., light to dark) to quickly identify where retention or engagement drops off across different time periods. ## Video walkthrough