Index Pages
Introduction
Dimension Vs Measure
Data Formatting
Bins
Filters
Sets
Data Blending
Group
Hierarchies
Parameters
Calculated Field
Saving and Exporting
Sorting
Functions
Functions Classifications
Aggregate Functions
IF Function
Case Function
Date Functions
Date Format
Actions
Filter Actions
Highlight Actions
URL Actions
Annotations
Mark
Point
Area
Classification of Charts
Classification of Charts
DashBoards
Story Line
Table Calculations
Custom SQL
Analytics
Faqs

 

    Create SET - first letter with P

     

  • We can apply sets on only on DIMENTIONS
  • Dimentions also termed as COLUMNS
  • SETS will be created on columns only

    •  

     

     

    SETS Creation Method

     

  • Manual: Manaully we can select to create set
  • Created SET by selecting A & C Companies

    • Header levle: By selecting headers\dimensoions

    Data view level: By selecting visualisation fileds

  • Drag the set into filter
  • Right click on filter, select show IN\OUT of set
  • Select SHOW FILTER

    •  

    Computed sets:

     

  • LEFT([Item],1)='p'

    •  

    Note: Combined set possible if we created two sets on same column\Data item

     

     

     

    Creation of SET through selection

     

     

     

    Creation of SET - Sum of QTY>1500

     

     

     

    Creation of SET - Right Function