Difference between revisions of "Drill Down"

From TaticView
Jump to: navigation, search
(Created page with "<languages/> <translate> Operation that allows you to choose a row from a table or graph and drill down (filter) by another column(s) (dimensions). Multiple drill down(s) a...")
 
(Marked this version for translation)
 
(3 intermediate revisions by 2 users not shown)
Line 2: Line 2:
 
<translate>
 
<translate>
  
 +
 +
<!--T:1-->
 
Operation that allows you to choose a row from a table or graph and drill down (filter) by another column(s) (dimensions).
 
Operation that allows you to choose a row from a table or graph and drill down (filter) by another column(s) (dimensions).
  
  
 +
<!--T:2-->
 
Multiple drill down(s) are possible until there are no more columns available.
 
Multiple drill down(s) are possible until there are no more columns available.
  
  
 +
<!--T:3-->
 
These filters add to the existing ones (combos filters, panel filters, objects, and columns).
 
These filters add to the existing ones (combos filters, panel filters, objects, and columns).
  
  
Attention: Operation only available for simple tables and simple graphs (lines, bars, area and pie)
+
<!--T:5-->
 
 
 
 
 
For example:
 
For example:
  
  
 +
<!--T:6-->
 
I have a table with customer information. I choose a customer and select the products column. The table will now show the products purchased by that customer.
 
I have a table with customer information. I choose a customer and select the products column. The table will now show the products purchased by that customer.
  
  
 +
<!--T:7-->
 
[[File:Drill down 1 en-US.png|link=]]
 
[[File:Drill down 1 en-US.png|link=]]
  
  
 +
<!--T:8-->
 
We select the client ''Bakery Junior Inc'' and double-click (taphold on mobile devices)
 
We select the client ''Bakery Junior Inc'' and double-click (taphold on mobile devices)
  
  
 +
<!--T:9-->
 
A window with the columns (text dimensions and dates) available for drill down will be displayed, confirming the choice made.
 
A window with the columns (text dimensions and dates) available for drill down will be displayed, confirming the choice made.
  
  
 +
<!--T:10-->
 
We chose the column ''Product''.
 
We chose the column ''Product''.
  
  
 +
<!--T:11-->
 
[[File:Drill down 2 en-US.png|link=]]
 
[[File:Drill down 2 en-US.png|link=]]
  
  
 +
<!--T:12-->
 
The same table that showed customers now shows the products that customer bought.
 
The same table that showed customers now shows the products that customer bought.
  
  
 +
<!--T:13-->
 
[[File:Drill down 3 en-US.png|link=]]
 
[[File:Drill down 3 en-US.png|link=]]
  
  
 +
<!--T:14-->
 
The title bar, if disabled will be enabled and will display the title (Drill down) to indicate the operation and two new icons are included for navigation.
 
The title bar, if disabled will be enabled and will display the title (Drill down) to indicate the operation and two new icons are included for navigation.
  
  
 +
<!--T:15-->
 
[[File:Drill down 4 en-US.png|link=]]
 
[[File:Drill down 4 en-US.png|link=]]
  
  
 +
<!--T:16-->
 
The icon  [[File:Drill down back level.png|link=]]  will allow you to go back one level (drill up) and the icon [[File:Drill down back start.png|link=]] will allow you to go back to the original table state (drill down reset). The filter [[File:Filter info.png|link=]] info icon will display all active filters.
 
The icon  [[File:Drill down back level.png|link=]]  will allow you to go back one level (drill up) and the icon [[File:Drill down back start.png|link=]] will allow you to go back to the original table state (drill down reset). The filter [[File:Filter info.png|link=]] info icon will display all active filters.
  
  
 +
<!--T:17-->
 
[[File:Filter info detail.png|link=]]
 
[[File:Filter info detail.png|link=]]
  
  
 +
<!--T:18-->
 
Expanding [[File:Expand component en-US.png|link=]] the table or graph during a drill down process may improve the user experience due to differences in column widths.
 
Expanding [[File:Expand component en-US.png|link=]] the table or graph during a drill down process may improve the user experience due to differences in column widths.
  
  
 +
<!--T:19-->
 
Important:
 
Important:
  
 +
<!--T:27-->
 +
* Drill down on cross tables and charts will keep the object crossing.
  
 +
<!--T:20-->
 
* Drill down comes enabled when the component is inserted into the dashboard. To not allow drill down on a particular component (table/graphs) you must turn off the Drill down property in the object properties in panel editing.
 
* Drill down comes enabled when the component is inserted into the dashboard. To not allow drill down on a particular component (table/graphs) you must turn off the Drill down property in the object properties in panel editing.
  
 +
<!--T:21-->
 
::[[File:Drill down 5 en-US.png|link=]]
 
::[[File:Drill down 5 en-US.png|link=]]
  
  
 +
<!--T:22-->
 
* When a combo filter connected to a drill down table/chart is changed, the drill down operation will be canceled (reset).
 
* When a combo filter connected to a drill down table/chart is changed, the drill down operation will be canceled (reset).
  
 +
<!--T:23-->
 
* For each date type column a list of formats is available. The title will refer to which date it refers to. Ex. Order Date (Month/Year)
 
* For each date type column a list of formats is available. The title will refer to which date it refers to. Ex. Order Date (Month/Year)
  
 +
<!--T:24-->
 
::[[File:Drill down 6 en-US.png|link=]] [[File:Drill down 7 en-US.png|link=]]
 
::[[File:Drill down 6 en-US.png|link=]] [[File:Drill down 7 en-US.png|link=]]
  
  
* [[Conditional Formatting]] is turned off during the drill down process, as context switching will invalidate it.
+
<!--T:25-->
 +
* [[Conditional Formatting]] is by default configured off during the drill down process. You must set to on to work with drill down.
  
 +
<!--T:26-->
 
* On the mobiles tap (taphold) the screen over the chosen line to open the drill down screen.
 
* On the mobiles tap (taphold) the screen over the chosen line to open the drill down screen.
  
 
</translate>
 
</translate>

Latest revision as of 11:59, 18 December 2020

Other languages:
English • ‎português do Brasil


Operation that allows you to choose a row from a table or graph and drill down (filter) by another column(s) (dimensions).


Multiple drill down(s) are possible until there are no more columns available.


These filters add to the existing ones (combos filters, panel filters, objects, and columns).


For example:


I have a table with customer information. I choose a customer and select the products column. The table will now show the products purchased by that customer.


Drill down 1 en-US.png


We select the client Bakery Junior Inc and double-click (taphold on mobile devices)


A window with the columns (text dimensions and dates) available for drill down will be displayed, confirming the choice made.


We chose the column Product.


Drill down 2 en-US.png


The same table that showed customers now shows the products that customer bought.


Drill down 3 en-US.png


The title bar, if disabled will be enabled and will display the title (Drill down) to indicate the operation and two new icons are included for navigation.


Drill down 4 en-US.png


The icon Drill down back level.png will allow you to go back one level (drill up) and the icon Drill down back start.png will allow you to go back to the original table state (drill down reset). The filter Filter info.png info icon will display all active filters.


Filter info detail.png


Expanding Expand component en-US.png the table or graph during a drill down process may improve the user experience due to differences in column widths.


Important:

  • Drill down on cross tables and charts will keep the object crossing.
  • Drill down comes enabled when the component is inserted into the dashboard. To not allow drill down on a particular component (table/graphs) you must turn off the Drill down property in the object properties in panel editing.
Drill down 5 en-US.png


  • When a combo filter connected to a drill down table/chart is changed, the drill down operation will be canceled (reset).
  • For each date type column a list of formats is available. The title will refer to which date it refers to. Ex. Order Date (Month/Year)
Drill down 6 en-US.png Drill down 7 en-US.png


  • Conditional Formatting is by default configured off during the drill down process. You must set to on to work with drill down.
  • On the mobiles tap (taphold) the screen over the chosen line to open the drill down screen.