LOD expression tableau calculating avg sales above avg global sales

-

Today 22/5/2023

This Question is related to Tableau Sample Super Store Dataset:

Q. For each Category, calculate the percentage of manufacturer that have sales above the global average sales.

Eg. global average sales: 228.23

For category furniture, 47 manufacturers are there out of which 40 manufacturers' sales is above the global average sales.

Required outcome:

Category%age of manufacturer above global average sales
Furniture85.11%

to do this by using LOD expression
1. calculating the global avg sales by using fixed:
2. calculating avg sales per manufacturer per regional by using fixed also:
3. making boolean filter which category avg sales>global avg sales:
4. calculating the manufacture total per category:
5. calculating the manufacture:
6. calculating percentage of manufacture category avg sales>global avg sales:
7. adding filter(calculation2) to be true value
adding category as row
add calcualtion4 
add manufacturetotal
add calcualtion1
 
HERE WE GO
8. remove the calculation4 and manufacturetotal from marks



FINISH
Location: Bandung, Kota Bandung, Jawa Barat, Indonesia

Comments

Post a Comment

Popular posts from this blog

sorting multiple measure value on tableau, works!

-
Image
tableau sorting the data based on column priority, so to sort multiple measure value just do: i have 1 discrete and 2 continuous value: kcp as discrete pertumbuhanhari% as value 1 pertumbuhanhari as value 2   i want to sort kcp by pertumbuhanhari% ascending first andthen pertumbuhanhari descending second step: 1. change continuous value into discrete value 2.  move the pertumbuhanhari% into first row and then pertumbuhanhari as second row and nama kpc as third row  by default it would be all ascending sorting 3, sort the pertumbuhanhari into desc, by right click on pertumbuhanhari column, andthen choose sort by Nested, andthen choose descending on sort order, and then choose field name which is used, ok 4. FINISH, 
Read more

reset many filters with one action click tableau

-
Image
today 24/6/2023, i use tableau 2023.2 version.  sometimes when we have a lot of filter on the dashboard need to come back to default filter ex: ALL, it is hard to click one by one filter to reset it to ALL, imagine we had 4 or 5 ot even 6 filter, it is hard to deal with it. many filter on dashboard luckly 3rd party has it, you know tableau has extension to deal it, it is FILTER BOOKMARK. filter bookmarks' logo with filter bookmarks, just one click it would reset all filter into default like we start ex: ALL. to do it : go to extension on dashboard search 'filter bookmarks' add it on dashboard configure it (explanation below) finish configuration button style        : to let the result being button with text on it label                     : title text on that button just uncheckbox (ignore) the options formatting  background color: it is background color text button color:it is button color text bu...
Read more

tableau needs upgrade: control parameter by specific user

-
Image
hello, today is 28th december 2023, im using brand new tableau 2023.3 i'm oftenly using parameter on my dashboard, paramter is used for variable inputed coming from user, but this is real question is? who is the user? since tableau can do separate role user perfectly, which can adapt the display with what the user on (it is called user filter) role user access i'm thinking that tableau should upgrade the future, the idea is: paramter can control by specific user otherwise it would be default value, example of boolean value coming from parameter It is importanting tableau to do becasue the feature that tableau can do already awesome, but it would be more perfect if the specific user can set the value of parameter, so the goal is specific user can set the value and specific user can not do it. it would be more efficient for developer, so developer must not use extenal source data (such as like spread sheet) to update data as variable for specific role/user  thank you,  Bnadung, ...
Read more