Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio / nhilam |
Follow
829
|
Our Table Calculations are more powerful, giving you the power to use any Dimension field in the chart, and implement INDEX and LOOKUP Table Calculation Functions. There are two new Table Calculation Types: Rank and Percentile.
We now allow you to create table calculations on any Dimension field in your chart.
We now allow you to select Rank as your Calculation type. With Rank you can see how a value ranks in comparison to other values in the same column or row. Use it to see how a particular dimension changes ranks from one week to the next.
There are four new functions you can use in your Table Calculations: INDEX, FIRST_P(), LAST_P() and LOOKUP. The INDEX function allows returning the index of the current row in the partition, without any sorting with regard to value. FIRST_P() returns the number of rows from the current row to the first row in the partition. LAST_P() returns the number of rows from the current row to the last row in the partition. With LOOKUP you can find the value of the expression in a target row, specified as relative offset from the current row.
You can now choose Percentile as your Calculation type. This lets you display the percentile a particular dimension in your Table Calculation falls in to.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017