Questions tagged [level-of-detail]

86 questions
0
votes
1 answer

TABLEAU - Calculating measure as a percentage of another measure

I want to calculate a measure as a percentage of another measure. For example, I have a field x_users and I want to calculate the percentage of this field in relation to the total_users. Then, I would like to visualize this percentage set against…
vtrhmd
  • 75
  • 7
0
votes
1 answer

Count occurence based on another column and return label having maximum count for each row

I have two categorical columns "Job Industry Categories" and "Wealth Segment" and I can create a crosstab using "Job Industry Categories" in rows and "Wealth Segment" to count values for each industry. This is how my crosstab looks like…
0
votes
1 answer

Count at the end of a month in Tableau

I want to find the number of customers per subscription plan at the end of the acquisition month. As you can see in the workbook, customers can change their subscription plan on any date, but I only want to find the subscription plan at the end of…
kimi
  • 525
  • 5
  • 17
0
votes
1 answer

how to combine all of the results of count for every max, min, median, average

this is the continous from my question from here how to display max, min, median, and average from tableau i have data like this on that picture, that is user_id and the right side are the frequency of transaction for each users so based on the…
18Man
  • 572
  • 5
  • 17
0
votes
1 answer

TABLEAU CALCULATED FIELD OPTIMIZATION

I have a calculated field called FirstSale where I observe the first instance of a product that sells more than 80% of its inventory. I look at the product ID and the timestamp (converted to string) and the % of inventory sold. How can this query be…
0
votes
1 answer

Tableau : Find difference between timestamps included in string

I have a csv file with this test time/dates formatted as strings concatenated with either 'parsing started/ended at' along with file_id in a separate field. The screenshot of data is- For each file_id I have to calculate difference between fist…
DrGenius
  • 817
  • 1
  • 9
  • 26
0
votes
1 answer

THREE.JS: Quadtree terrain glitch

I have a very simple code for visualising geo terrain from tiles of different zoom levels, based on pseudo-quadtree algorithm. Due to crossDomain restrictions and StackOverflow limits I am publishing code just for reference, the live demo is…
VVK
  • 435
  • 2
  • 27
0
votes
0 answers

How do you calculate percent change in tableau when the original fields are calculated with fixed LOD?

I am currently working in tableau and could not find the answer to this question on the tableau forums or on stack overflow. To get the yearly ticket sales in the attached screenshot, I had to used a Fixed LOD calculation to get the 2018 and 2019…
Jacques
  • 57
  • 2
  • 7
0
votes
1 answer

Can't compute an aggregation of an aggregation in Tableau

I'm trying to compute the standard deviation of a nested calculated measure. In this example, different countries produce a number of items every month, each with a specific colour. I'm trying to sort countries by the standard deviation of the…
Jivan
  • 21,522
  • 15
  • 80
  • 131
0
votes
1 answer

Dax : LOD to extract latest value

I have the following table in which I am trying to the extract the Status based on the Latest Date -------------------------------------- Date | User | Status | ID | -------------------------------------- 12-01-2019 | A | Approved | 1A…
kcvizer
  • 137
  • 1
  • 2
  • 8
0
votes
1 answer

Tableau Level of detail fix required

Above is the image link of actual Tableau layout, along with table structure with before and after filter I have two tables – Users and Categories User Table: The user table has userid, name, title, channel, team, sub-team columns. from which I…
Dharmesh
  • 1
  • 3
0
votes
1 answer

Key Value Observation with SCNGeometry for Levels of Detail

I am attempting to use kvo to observe my node's geometry because Scenekit does not provide some sort of callback to let me know when the level of detail of a node has been updated. The purpose of this is that my of my nodes have idle animations and…
0
votes
0 answers

THREE.js - Cloned and rotated LOD objects - wrong shading

I have a txt. file exported from 3ds Max with name of objects, position, rotation and scale. Secondly I have a javascript initial list of this objects with paths on extern obj. and mtl. files. From initial list I create a LOD objects that are…
0
votes
0 answers

Tableau - Average of Ranking based on Average

For a certain data range, for a specific dimension, I need to calculate the average value of a daily rank based on the average value. First of all this is the starting point: This is quite simple and for each day and category I get the AVG(value)…
Fabio Fantoni
  • 3,077
  • 3
  • 22
  • 32
0
votes
1 answer

Double aggregation in Tableau using LOD expressions

I am using Tableau to create a custom google analytics dashboard. I have a custom dimension named author in my google analytics view and I would like to group the date of the first page/view by author and by month having a counter. I successfully…