Solved
Formulas - anyone having challenges?
Hi y'all! Sisense newbie and hoping to get some help on formulas. In our trial, I was able to build formulas for activation rate (as an example), where I counted the number of customer IDs (a string...
Not using live models, but in my few experiments with them I haven't noticed a difference in how the formulas work. I use filtering in formulas extensively.
I would try the formula like this: (COUNT([CustomerID]),[activation filtered by 'yes'])/COUNT([CustomerID]) -- so using slightly different placement of parentheses.
If for whatever reason you are also applying a grouping on CustomerID itself, you can try:
(COUNT([CustomerID]),[activation filtered by 'yes'])/COUNT(ALL([CustomerID]))
Some of the aggregation functions (SUM, MAX etc) allow two parameters to the function, where the first one is a group by and the second another aggregation. But COUNT generally only takes one. And the filter is then applied outside the aggregation.
Good luck!
