Search This Blog

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













at

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



at

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






at

Wednesday 19 August 2015

Parts of the Dataview

  • The parts of a view can be categorized as either table components, which are part of every view, or optional components, which can be turned on or off.
  • Data views are displayed in a table on every worksheet. A table is a collection of rows and columns, and consists of the following components: 
           Headers, Axes, Panes, Cells, and Marks.
           In addition to these, you can optionally show Titles, Captions, Field Labels, and                                                  Legends.
          They are shown as below.


Thanks Guru's,
Prazval.ks





at

Friday 14 August 2015

Tableau Server Architecture

Tableau has a highly scalable, n-tier client-server architecture that serves mobile clients, web clients and desktop-installed software.Tableau Server architecture supports fast and flexible deployments.

 The following diagram shows Tableau Server’s architecture:



 Tableau Server is internally managed by the multiple server processes.They are

 1)Gateway/Load Balancer:-
It acts as an Entrygate to the Tableu Server and also balances the load to the Server if multiple Processes are configured.



2)Application Server:-

Application Server processes (wgserver.exe) handle browsing and permissions for the Tableau Server web and mobile interfaces. When a user opens a view in a client device, that user starts a session on Tableau Server. This means that an Application Server thread starts and checks the permissions for that user and that view.



3)Repository:-
Tableau Server Repository is a PostgreSQLdatabase that stores server data. This data includesinformation about Tableau Server users, groups and group assignments, permissions,projects,datasources, and extract metadata and refresh information.


4)VIZQL Server:-
Once a view is opened, the client sends a request to the VizQL process (vizqlserver.exe). The VizQL process then sends queries directly to the data source, returning a result set that is rendered as images and presented to the user. Each VizQL Server has its own cache that can be shared across multiple users

5)Data Engine:-
It Stores data  extracts and answers queries


6)Backgrounder:-
The backgrounder Executes server tasks which includes refreshes scheduled extracts,tasks initiated from tabcmd and manages other background tasks.


7)DataServer:-
DataServer Manages connections to Tableau Server data sources
It also maintains metadata from Tableau Desktop, such as calculations, definitions, and groups.



Thanks Guru's,
Prazval.ks




at

Sunday 9 August 2015

Tableau Version History



TABLEAU Version History


        
·       

Tableau 7

Tableau 6

Tableau 5

Tableau 4

             
Thanks Guru's,
Prazval.ks


at
Subscribe to: Posts (Atom)

DAX Time Intelligence Functions

   Thanks Guru's, Prazval.Ks