How to write calculation to compare Current Month vs Same month previous Year in Tableau?
Вставка
- Опубліковано 15 жов 2024
- Please do SUBSCRIBE to my channel.
Do let me your queries/suggestions in the comment section.
LIKE || SHARE || COMMENT
#tableau #tableaututor #tableauforbeginners
Join our WhatsApp group and get answers to your queries:
chat.whatsapp....
hey actually i learned alot from you and I just given an interview for saama technogy and cleared technical round I am sharing interview question here can you please make a video like how to give an answer to interviewer to build impression like just wanted to say I want focus on body language, answering tact, in what way have to tell answer .
1)itroduction?
2)projects?
3)what types of filters.
4)order of filter
5)data bleanding and relationship difference.
5.1) what is * sign in data blending why it's come and how to remove it.
scenario based question
6)two dimesions
customer id
order date
find the customers who have order in 2014
two ways
in set go to conditin then by formula year(order date)=2014 ===in and out manner result 1st solution
second solution
{fixed [customerid]: attr(orderdate)}
7)find first orderdate of each customer
{fixed [customerid]:min[orderdate])}
8)joins
table1 table2
1 1
2 1
3 2
5 4
null null
inner =
1 1
1 1
2 2
left=
1 1
1 1
2 2
3 null
5 null
null null
right
1 1
1 1
2 2
4 null
null null
full
1 1
1 1
2 2
3 null
5 null
null null
null 4
null null (table2)
9)find the employee with second highest salary
select name from (select name,salary,dens_rank() over(order by salary desc) as rn) where rn=2;
10)find total revenue year wise
select year sum(sales) from customers group by year;
hope you will consider my reply and thanks for everything.
You have very good knowledge on Tableau
Thanks a lot
Do you take tableau classes?
Thank you!
You're welcome!
you could simple use discrete and drop sale on size and color then you would have received the same result :)
Wil this work on specific dates of the relevant months.
How can I get the bar one next to the other one rather than one over the other?
sooooooperu
hi is there a new invite link for whatsapp?