Thursday 3 September 2015

Creating Empty Extracts in Tableau

Hello Guru's,
      Today  Let me share a very important tip of Tableau,Creating Empty Extracts.
To achieve this we have a couple of ways and workarounds, let me share you  the unique and easiest way of creating empty extracts by passing the unmatched datasource filter condition in the following steps.


Step1:-
Open Tableau Desktop and connect to the superstore English DataSource.

Step2:-
Go the Analysis Tab and click Create a Calculated Field


Step3:-
 Give the Name as Empty Extract and In the Formula window write Now() And click on Ok.


Step4:-
  Right Click on the Superstore Data Source and click on Edit Data Source Filters


Step5:-
 In the Edit Data source Filters Window, Click on Add.



Step6:-
 Select Empty Extract field and click on OK


Step7:-
Select  Range of Dates and Click on Next


Step8:-
Click on Starting Date and Select 1 Minute Forward to the current date and time which results in the unmatched condition.
Click on Ok.

Step9:-
 Again Right Click on the Superstore Datasource Click on Extract Data


Step10:-
In the Extract Data Window, Click on Extract


Step11:-
Save the Extract File and Click on View Data


It will Display No of rows=0 as below ,which indicates Extract is Empty.


Thanks Guru's,
Prazval.ks






DAX Time Intelligence Functions

   Thanks Guru's, Prazval.Ks