I have joined two tables in explore and found the difference and rank between two date values using table calculations. Please can someone help me to create a dynamic tier for the column : “delay(in Minutes)” as attached in the image.
Already have an account? Login
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
A dynamic tiers sample for our project.
use minute_tier_config to set tier
minute_tier_config= x or “” (keep origin value)
minute_tier_config= “n,10,0,0,100” (n, size, offset, min, max )
minute_tier_config= “n,10,1,1,100” (n, size, offset, min, max )
minute_tier_config= “m,10,30,50,100” (m, …)
I think he does mean buckets.
At the moment I believe it will only be able to be done using a table calculation with a lot of IF statements.
That is if you can’t achieve the grouping mathematically, for example
11-120anything like that will required calculations
What do you mean by dynamic tier? Like creating a sort of bucket? You could grab the max() value of the column and the min() and do some comparisons based on that, perhaps.
Some more info would help answer the question in more detail.
For example: I want the frequency of the count that occurs between 0-5 or 0-10.
If that is not possible, at least frequency of count of the occurrence. For example: How many times 1 is occuring?