Home > Software > Tableau
Interview Questions   Tutorials   Discussions   Programs   Videos   Discussion   

Tableau - If we want to compare values over time, which chart is the best option?




1492
views
asked sirisha February 25, 2015 04:10 PM  

If we want to compare values over time, which chart is the best option?


           

8 Answers



 
answered By   0  

We can use Gantt charts for to compare values over time.

flag   
   add comment

 
answered By Sobila   0  

When you are showing a change over time, use a time series (a line chart with time on the columns shelf)

flag   
   add comment

 
answered By   0  

Hello Pradeep,

Actual Sales is a measure.

What is Dimension & measure?

Dimension: A dimension is a field that can be considered an independent variable.

Dimensions typically produce headers when added to the rows or columns shelves in the view. By default, Tableau treats any field containing qualitative, categorical information as a dimension. This includes, for instance, any field with text or dates values.

This means that a measure can be aggregated for each value of the dimension. For instance, you might calculate the Sum of “Sales” for every “State”. In this case the State field is acting as a dimension because you want to aggregate sales for each state. The values of Sales are dependent on the State, so State is an independent field and Sales is a dependent field.

Measure:A measure is a field that is a dependent variable; that is, its value is a function of one or more dimensions.

Measures typically produce axes when added to the rows or columns shelves. By default, Tableau treats any field containing numeric (quantitative) information as a measure.

This means that a measure is a function of other dimensions placed on the worksheet. For instance, you might calculate the Sum of “Sales” for every “State”. In this case, the Sales field is acting as a measure because you want to aggregate the field for each state. But measures could also result in a non-numeric result. For instance, you might create a calculated measure called “Sales Rating” that results in the word “Good” if sales are good and “Bad” otherwise. In this case the “Sales Rating” field acts as a measure even though it produces a non-numeric result. It is considered a measure because it is a function of the dimensions in the view.

flag   
   add comment

 
answered By Venkatapradeep   0  
Hi Mouni, Thanks for you reply I got explained picture, where as i have quick clarification,In this case Actual sales Acts as an Dimension...?
flag   
   add comment

 
answered By   0  

Hello Pradeep,

If I want to know whether my company sales reached the target level for a particular period in a graphical representation. Here Sales represents actual sales & target represents target sales, both are measure values.

flag   
   add comment

 
answered By Venkatapradeep   0  

Hi Mouni,

Can you explain little briefly..MAM

flag   
   add comment

 
answered By   0  

Hi Abdul,

Compare values over time in the sense comparing 2 measures over a period of time.

For example: Actual sales vs Target Sales.

We can also use bar/bullet/Dual Combiation graphs as well.

flag   
   add comment

 
answered By   0  

Line chart is the best option to compare values over time

flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert