-
How to get grand totals to appear on top for a tabular grid
In a Matrix Grid there is an option to display the Grand Totals on top Is there some way to do this for a Tabular Grid?
- Answered
-
Filter with numeric attribute
I'm trying to achieve the below: sum of transactions.sales by product where transactions.Sales > $32,000 (user can choose amount) I can't find a slicer type for a numeric attribute,…
- Answered
-
Median with SQL Server direct query
How can I get the median for a measure with a SQL Server data source using direct query? Median is not in the list of aggregate functions for a measure.…
-
Drop tables in the In Memory Database
Is there a way to drop a table in the In Memory Database? I see where I can delete an entire database, but not individual tables.
- Answered
-
Multilevel Sankey
Is there a way to create a multilevel sankey diagram? For example, if I have a dataset like this: Source Target Values NY TX 100 NY CA 200 MA CA 75 CA HI 25 TX WY 50 I'd like to produce
-
Formulate with condition if measure is blank
I'm trying to subtract one measure from another only if the second measure has a value. If not, the formula should return empty. The below is not working.…
- Answered
-
Formula for measure filtered by a dimension
I have the fact and dimension tables below: SourceType dimension · SourceType 1 · SourceType 2 · SourceType 3 · SourceType 4 Event fact · Count of events I would like to 1) create a formula which…
- Answered
-
DistinctCount with filter
I have a fact table Impressions (ImpressionID, DeviceID, AudienceID) and two dimension tables Devices (DeviceID, DeviceType, etc) Audiences (AudienceID, AudienceType,…
- Answered
Latest Posts