Learning

 
1. We can pass the filter to hover sheet.
2. We can give download button that will download only Data tab data not crossdatatab. Data format would be different in it.
3. Using parameter : we can show some values as  float and some as number 
(left(str([Average Application FICO]),(find(str([Average Application FICO]),'.')+2)))
4. string func : Contains , endswith ,startswith, find ,left (start position is 1 will include last as well) 
, len (start with1 ), lower, ltrim,replace, rteim,right,upper
5. We can show multiple sheet swaping in tableau
6. Javascript API in tableau
7. We can give the index number horizonl and vertical.
8. We can run multiple if by using plus
if() then .. end
+
if() then ... end
9. For Swaping use first horizontal and then inlucde one vertical(only)... not multiple vertical.
 In one vertical include sheets one by one after selecting parameter.

10. How to convert string to date.
11. continuous axis cannot be rotate only dimension/discreate can rotate : Wrong, we can do it  format-->scale
12. Edit date continuous axis
13. if i have c
14. for swapping sheet thers should be one dimension avaialble (on row.column shelf) in each sheet.
15. We can show measure header by using measure name pill
16. How to Build a Monthly Date Slider in Tableau : https://www.theinformationlab.ie/2020/03/09/monthly-date-slider-in-tableau/



**************************
Quarter last date :  DATEADD('month',3,DATETRUNC('quarter', [As Of Dt]))-1
momth last date :  DATEADD('month',1,DATETRUNC('month', [As Of Dt]))-1

*************************************************************************
Issue list
1. Parameter multi select
2. 
************************************
Have to do
1. Column based conditional formatting

Filter/ Parameter hide based on Paramter selectoion

Steps:

1. Create 2 Param1  and Param2. Param1 will be visible all the time the other will appear based on  selection on Param1.

2.Create blank sheet having avg(0) on rows and columns

3. Add Param1 in blank sheet and add values based on which the Param2 will be hide.

4. Add Paramters1 and add blank sheets and then add PArameter2 and add floating object on Parameter2

Please check below link.

https://public.tableau.com/profile/peeyush.jain#!/vizhome/HideFilterParameterbasedonParameterseelction/Dashboard1

This approach will work good in Fixed layout where as for Autoimatic layout there is a chance the floatig object will distorted.

Date Slider in Tableau

 How to  shoe slider where user can select from -to date using slider.

Tableau Known Issue

 1. Latest 5 month selection in filter or Current month , Last year same month slected and other months are unselect in drop-down.

2. Filter hide based on Filter. By Parameter we can hide Filter.

3. Measure name and Measure values cannot used in Calculation

4. When having scroll in dashboard - sheet. Now when we download from server to PDF. it won't download complete data. 

Cell Background Color ( Conditional formatting)

 as