Posts

Showing posts from March, 2023

ATTR Function use

  If we want to show sum for a particular segment, avg for another segment, Ratio for the other segment in a single calculation then we use the ATTR Function.    IF ATTR([Segment])='Consumer'  THEN SUM([Profit]) ELSEIF ATTR([Segment])='Corporate'   THEN avg({ INCLUDE [Category]:SUM([Sales])}) ELSEIF ATTR([Segment])='Home Office'  THEN [Profit Ratio]*100 END

TMS FILE

   You can Import a custom map from an URL     

SQL QUERY TO FIND STUDENTS HAVING MARKS >75 IN ALL SUBJECTS

  select name1,course from student where course IN ("Art","Math","Eng") group by name1,course having min(marks)>75;

Animations in Tableau

                 Types of Animations in Tableau 1.                            Simultaneous Animations : These are by default 2.                            Sequential Animations : These take more time but make complex changes clearer by presenting                step by step                  Animations are supported by all web browser except Internet explorer                Following Tableau features don’t animate ·         Maps, polygons and density marks in web browser ·         Pie and text marks ·    ...