Sunday, 13 September 2015

Table Calculations Adressing Options

Table Calculations are computations that are applied to the values in the entire table and are
often dependent on the table structure itself.

The most important factor in the Table Calculations are addressing and partitioning options.Addressing can be relative to the table structure (options beginning with Table, Pane, or Cell)
or to a specific field (such as Category, Order Date, or Region). 
Addressing options based on table structure.

The Different addressing options available are

1)Table Across:-
If we performs the computation across the Table horizontally,then such a kind of addressing is known as Table Across.




2)Table Down:-
If we performs the computation down the Table vertically,then such a kind of addressing is known as Table Down.

3)Table Across then Down:-
If we performs the computation across the Table horizontally then Down the table vertically, such a kind of addressing is known as Table Across then down.


4)Pane Across:-
If we performs the computation across the Pane horizontally,then such a kind of addressing is known as Pane Across.



5)Pane Down:-
If we performs the computation down the pane vertically,then such a kind of addressing is known as Pane Down.



6)Pane Across then Down:-
If we performs the computation across the pane horizontally then down the pane vertically,then such a kind of addressing is known as Pane Across then Down.




7)Cell:-
If we performs the computations at each and every value level,then such a kind of addressing is known as Cell.


Thanks Guru's,
Prazval.ks














Friday, 4 September 2015

Hiding Abc

Hi Gurus,
Let us see how to hide "Abc" After dragging and dropping any dimension into the rows/columns shelf in the following steps


Step1:-
1.Open Tableau Desktop and connect to the super store English(Extract)


Step2:-
2. Drag the continent and drop into the Rows.



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


Step4:-
Enter the Field name as Hiding Abc and in the formula window write as CHAR(32) and click on ok.
Note:-
32 is the ASCII Number for the Space.


Step5:-
After that Drag the Hiding Abc field from the Dimensions and drop it into the Label of the Marks Legend,It will replace Abc with space,hence Abc is hided.


Thanks Guru's,
Prazval.ks



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






Formatting Tips

Hello Gurus, One of the common things in Tableau after building any visualization is performing formatting. The Structured way of doing i...