Questions tagged as 'business-intelligence'

1
answer

QLIKVIEW Formula to feed POISSON

I need help finding the value for a POISSON formula I have the table below: With the POISSON formula of excel = POISSON (10; 11.97; TRUE) I get 35,07% =POISSON( Numero de Peças ; Peças Entregues dentro do prazo 7 dias;TRUE)...
asked by 16.04.2018 / 15:36
0
answers

Percentage calculated through different levels

Hello! I recently started some developments in Power BI and I have the following doubt: I have a test table composed as follows: AfterimportingthebasetoPowerBIIcreatedanewcolumninsidethetoolthatcalculatesthepercentageofVALOR1overVALOR_TOT...
asked by 18.04.2018 / 14:41
0
answers

Error formula Power BI

I have a question in Power BI, I'm a DBA and I'm growing my bank with the following formula: YoY = CALCULATE(('Consulta2'[AVAILABLE_SPACE] - 'Consulta2'[TOTAL_SIZE]/'Consulta2'[TOTAL_SIZE])) But he is returning this message:    A single...
asked by 21.03.2018 / 14:49
0
answers

Solved - Tableau - Calculating% between two calculated fields

I have two types of Sales where my dash presents the total value in $ of each of these types, but I would like to show how much of the sale X (total sale) my sale Y represents, for example: Sale X: 100 Sale and: 5 Sale and%: 5% But when I...
asked by 26.07.2017 / 16:04
1
answer

How to calculate the sum of a group in MDX

I need to create a Calculation in SQL Server Data Tools. Imagine that in my OLAP framework I have the Dimensions City and Reseller, and a Sales Fact. In the City dimension I have City, State and Population, and that Population is a mea...
asked by 17.12.2014 / 11:52