You can toggle SELECT and SELECT DISTINCT in a reports SQL by clicking the 'Show Duplicate Records' option in the Report Builder:
Off (Default) = SELECT DISTINCT
On = SELECT
Related Articles
- How do I create Sub Tabs on a dashboard?
- My charts have suddenly disappeared or are not displaying at all?
- Can YF reports display Row Numbers like in MS Excel?
- How do I secure or hide a YF Report?
- Where does the report description date and time come from within Yellowfin?
- Why is the time series not showing gaps in data on reports?
- Dashboard displayed wrong result when using the browser back button?
- Can you assign multiple values to an access filter?
- Can I create a report that queries data from multiple data sources?
- How does the new v7.1 drill through functionality work?
- What is the criteria around how often and when a report on a dashboard tab is refreshed?
- Is there a way to set the Auto Refresh functionality for views and reports to OFF by default?
- Why can't I see the Drill Down option in my report builder?
- Is there a way to assume NULL = 0?
- How do I create a report and utilize the Ring charts as seen below in the Monitor dashboard?
- Our dashboards and reports do not seem to load well in IE8, does Yellowfin work with Internet Explorer? (IE8 IE9)
- Can I create a two field drill downs from the same hierarchy within the same report?
- How do I change the width of my dashboards?
- What is the best way to connect two databases, that have different data, but I need to join the data into a report?
- Can annotations be applied to any other data type than dates?
- What is the data type Integer and how does it connect to the Field Type options?
- How do you create a time based distribution using time dimensions?
- How do I sum a quantity relating to a specific end date within a range of dates?
- Where can I find Geo Polygon data or other Geo Pack details that I can use within Yellowfin?
- Does Yellowfin plan to support non-additive measures in the future?
- How do I format negative numbers in Yellowfin?
- GIS Resources
- How To: Create a KPI Scorecard
- turn off validation of calculated fields when saving
- How to perform comparative analysis within chart builder using set analysis.
- How to create calculated fields using the variance function.
- How can I setup customer colors for my metrics?
- How to use chart-level aggregation to change things like Sum, Average, Min, Max, Count, and Count Distinct.
- What has changed in the content creation canvas?
- Header & Column Lock not working? Check whether CUSTOMDASHBOARDSCROLLBARS is ON or OFF in Configuration
- Cached Values On Demand / Custom Query Cached On Demand
- 7.3 Set Analysis Feature
- Aggregate vs Group By in Custom Functions
- How to Add a Font to Yellowfin
- Tips to code and debug a JavaScript Chart in Yellowfin
- JavaScript Charting Libraries - Ski Team Examples
- What is a .YFX file?
- Calculated Field showing wrong value, incorrect result
- Multichart Canvas
- Big Number Charts
- Dashboard Filters
- Dashboard Sub Tabs
- Saving Dashboards
- Saving dashboards
- Dashboard Series Selection
- Dashboard Series Selection
- Dashboard help
- Calculated fields
- Advanced Functions
- Filters
- Use Prompt Filters
- Bookmarks and Snapshots
- Summaries and Sub totals
- Googlemaps
- Toggling map types
- Loading CSV
- Report Editing
- Report Editing
- Basic cross tab report
- How to create Co-Display Reports
- Section Reports
- How do I use a logo as a Axis tick label on a Bar Chart?
- Where can I find some D3 visualization examples?
- How to get barcode fonts working in your report tables.
- How to hide a Column Heading (i.e. how to have a blank column heading)
- Getting started with Yellowfin
- Creating your own Conditional Formatting customised icons (for developers)
- Creating your own Conditional Formatting customised icons (for non-developers)
- The 101 guide to designing beautiful analytics
- "invalid field name" or "multipart identifier <xxx> could not be bound" on calculated field insert
- How to Toggle SELECT and SELECT DISTINCT in Report Builders' SQL
- Differences Between Simple and Freehand SQL Calculated Fields
- How Report Sections work
- How Drill Down and Drill Anywhere work at the SQL level
- How arithmetic and aggregations interact in Calculated Fields
- How do the new Cached Filter options work in 9.5
Properties
Author
Mike Sheehan