Sunday, March 7, 2021

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


No comments:

Post a Comment

How do I find only strings that contain precisely "ABC" (upper case), but not those that contain "abc" or other upper/lower case combinations?

  How do I find only strings that contain precisely "ABC" (upper case), but not those that contain "abc" or other upper/...