Stack Overflow
Stack Overflow

Questions tagged [measures]

58 questions
7
votes
2 answers

break line after some number of measures in lilypond

I have this as a sample notation example. How would I specify to have exactly 4 measures per line, throughout the whole piece. I searched the whole documentation and did not find such a simple feature. Am I missing something? \version "2.18.2" %…
branquito
  • 3,864
  • 5
  • 35
  • 60
5
votes
2 answers

SSAS dimension processing makes underlying measures unprocessed

There is a Sales Invoice dimension which is related to Sales measures. Sales measures are partitioned. I have 2011 partition and 2012 partition. I figured that we don't need to process Sales 2011 partition because it doesn't change…
baq
  • 51
  • 1
  • 6
4
votes
1 answer

How to create a separate measure group for the distinct count

I am adding distinct order count measure to the cube. I have to place it in a separate measure group for better performance When I click on "new measure group" button, I am presented with a dialog box "select a table from the source view" . My…
user2374904
  • 41
  • 1
  • 3
3
votes
1 answer

Overloading of F# Measures

Consider the following F# code: [] type pixel [] type inch [] type dot [] type percentage let scaleCalculation (finalSize:float) (originalSize:float) = finalSize/originalSize *…
Onorio Catenacci
  • 14,928
  • 14
  • 81
  • 132
3
votes
1 answer

Power BI - Using of filters in calculate function

Please refer below to the sample data i used: ID Name Status Dept. 1 Austin Pending MES 2 Roy Devilered DHA 3 Steven Terminated DHA 4 Peter Pending MES 5 Sanjay Pending MES 6 …
MJoy
  • 1,349
  • 2
  • 9
  • 23
3
votes
1 answer

mdx group by measures values range

I'm looking for the way to create a group by measure value. I have a cube of bookings with the dimensions, client, supplier.... and more dimensions. I want to create a query, which must returns the suppliers grouped by Total amount range and count…
Constanza forteza
  • 31
  • 1
3
votes
1 answer

Measure as date variable when calculating time periods in Powerpivot

My situation is as following: This is a Powerpivot solution developed in Excel 2013 (32-bit). I got a transaction table containing transactions with an amount, a category and a posting date. What I would like to to is to present a number of…
Adam
  • 113
  • 1
  • 10
2
votes
2 answers

Removing repeated obs data if n Obs < x in R

I have a repeated measures data set. I need to remove all Participants where the number of observations for that individual is less than 3. What is the best way to do this? x <- c(9, 9, 9, 11, 11, 23, 23, 23, 23, 45, 45, 45, 56, 56) Here 11 and 56…
jusjosgra
  • 375
  • 2
  • 4
  • 14
2
votes
1 answer

weighted average by category filtered by time period

I've got a headache which I would love some help with So I have the following table: Table 1: Date Hour Volume Value Price 10/09/2018 1 10 400 40.0 10/09/2018 2 80 200 2.5 10/09/2018 3 14 …
squib1996
  • 67
  • 5
2
votes
0 answers

Figure inside a box

This is just a theoretical question. I think it's very probably that someone is already faced this problem before, and should be plenty of known algorithms to solve it. More than a concrete answer to my problem, I would be grateful if someone could…
Rumpelstinsk
  • 3,107
  • 3
  • 30
  • 57
2
votes
3 answers

Categorize measures in SonarQube

I want to categorize specific metrics I have in SonarQube to fit my needs. In detail: I built a Gatling Plugin for SonarQube that reads the stats which Gatling writes and puts them into SonarQube Metrics. Now I want to categorize my measures…
kummerer94
  • 171
  • 10
2
votes
0 answers

How to show projects not containing a given string in sonarqube

I'm using sonarqube 4.5.1. Is it possible to show, in measures tab, sub-projects not containing a string? For example, I want to show only projects not having the word "tests" in their name.
atrw sr
  • 141
  • 1
  • 10
2
votes
1 answer

How to convert repeated measures from rows to columns in Excel

I have a data file of approximately 5000 repeated measures organized with rows containing IDs and repeated measures on weight, BMI, etc for children. I would like to find the maximum value of one variable (BMI) for each individual (out of up to 9…
Melissa Melby
  • 21
  • 2
1
vote
2 answers

Tableau - Split a measure into measures (one for negative numbers, one for positive numbers)

Does anyone know how to take one measure and split it into two new measures. The first measure will include only positive numbers, the second will contain only negative numbers. I have tried creating a group. This makes the new group a dimension,…
Tashka
  • 13
  • 3
1
vote
1 answer

Calculate where type clause from two different tables

I haven't written DAX in a while and I'm having a bit of a hard time putting this together and I am hoping someone could throw in a suggestion. What I have: Qty Table (a lot more months than January): +----------+-----------+----------+ | Location |…
Cosmin
  • 565
  • 1
  • 8
  • 33
1
2 3 4