Creating Bined Histogram from Subtotals
I want to create a histogram of sales information. I currently have a single table givin me - OrderID, type of product, quantity, price As such if you buy 3 different types of products, you would get 3 different lines in the DB. I'm trying to create a histogram of size of order. But if I used the standarized Group / Bins on the quantity metric I get the histogram at a product level (quantity of each product). How can I make subtotal ranges for the same OrderID so I can later use them as bins in the histogram. Order sizes 1-10, 10-20, 20-30...etc up to 1500. Thanks everyone.
Need help in creating a histogram from a measure
Hello! I have an [Age] measure that calculates the age of active employees given a chosen year. I'm attempting to create a histogram to show the distribution of the ages of active employees given a chosen year using this measure. Is this possible? I attached my .pbix file here. I tried creating the histogram using a calculated column but since it's a calculated column, ages will not be updated if I select other years. I tried categorizing the ages of all active employees given a selected year using the formula below but I'm not really sure how I can used this in creating my histogram. Please help! Thank you so much.Need help in creating a histogram from a measure
Hello! I have an [Age] measure that calculates the age of active employees given a chosen year. I'm attempting to create a histogram to show the distribution of the ages of active employees given a chosen year using this measure. Is this possible? Below is the Age measure formula used: Age = VAR _selyear = MAX(_Calendar[Year]) VAR _age = CALCULATE( DATEDIFF(SELECTEDVALUE(hr_coredata[DOB]),DATE(_selyear, 12, 31 ), YEAR ), ALL(_Calendar),_Calendar[Year]<=_selyear) RETURN _age I tried creating the histogram using a calculated column but since it's a calculated column, ages will not be updated if I select other years. I tried categorizing the ages of all active employees given a selected year using the formula below but I'm not really sure how I can used this in creating my histogram: Age Category = VAR _age = [Age] // Assuming [Age] is the name of your existing Age measure RETURN SWITCH( TRUE(), _age < 25, "Under 25", _age >= 25 && _age <= 34, "25-34", _age >= 35 && _age <= 44, "35-44", _age >= 45 && _age <= 54, "45-54", _age >= 55, "55+" ) Please help! Thank you so much.
Get accumulated pending tasks
Hi. I have the following example table: id opening date closing date 1 01/01/2021 01/02/2021 2 01/01/2021 01/02/2021 3 01/01/2021 01/02/2021 4 01/01/2021 01/02/2021 5 01/01/2021 6 01/01/2021 7 01/01/2021 8 01/01/2021 9 01/02/2021 10 01/02/2021 11 01/02/2021 12 01/02/2021 13 01/02/2021 14 01/02/2021 15 01/02/2021 16 01/02/2021 17 01/03/2021 18 01/03/2021 19 01/03/2021 20 01/03/2021 Each row of the table is a task (demand) that has been generated for someone. The objective is to create a histogram that shows the amount of accumulated open demands. An open demand is one that does not have an closing date, or whose closing date is later than the month bar in the histogram. The result should be something like: *i know this is not a histogram Note that 8 demands were generated in January, 8 in February and 4 in March, but 4 were closed in February. Could someone help me create this chart?
