Replies posted by amock
Hi, I was searching for something similar and saw your post. I think you will find your answer at Considerations when using table calculations: If you add a total row to your data table, some table calculations that perform aggregations, such as calculations using percentile or median, might not add up as you expect. This is because table calculations calculate totals using the values in the total row, not using the values in the data column. So, it looks like ‘Weighted’ = ‘Order count’ x ‘% of Total’ and rounding to the nearest integer. Since ‘table calculations calculate totals using the values in the total row’, the “Total” for the Weighted column is basing the calculation on the other values in the Total Row, i.e. 68 x 1.
Month-level timeframes for calendar year include a ‘month_num’ timeframe, which includes only the calendar month number, as well as a ‘month’ timeframe, which includes both calendar year and calendar month number. Month-level timeframes for fiscal year include only a ‘fiscal_month_num’ timeframe. Do you anticipate adding a fiscal_month timeframe?
Already have an account? Login
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.