default-format
values (Tableau documentation):
C1033%
'n#,##0;-#,##0'
*dd/mmm/yy
p0.0%
semantic-role
values are:
[Geographical].[Latitude]
[Geographical].[Longitude]
[City].[Name]
[State].[Name]
[Country].[ISO3166_2]
[ZipCode].[Name]
SUM([Lineitem Median Revenue])
in Tableau would translate into calculating the median revenue.
customer
entity will always be counted on a customers level of detail.
There is no need for a LOD field such as { FIXED [customer.c_custkey]: AVG([customer.c_custbal]) }
.More complex Level of Details are possible with grouped metrics.workspace
, a working branch
in it (usually would be prod
), and a dynamic dataset dataset
.
This calls a stored procedure to retrieve dynamic dataset data, and stores it in a temporary table
used to build the extract.
Then create a Custom SQL data source with the query