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

 

    Difference between date of inc to current date in years

     

  • State the difference in years
  • Right click on dimensions and create CALCULATED FIELD

    •  

     

  • To remove the decimals use below mentioned formula
  • Converted into INTEGERS

    •  

    int(DATEDIFF('day',[Date Of Inc],TODAY())/365)

     

    Year Wise Bifurcation across Items

     

     

    Required Period Vs Remaining Periods

     

  • Compare between Selected Period to Remaining Periods

    •  

     

    Apply Conditional Formatting on Pricing