Janine

kapa.ai Is there any way to change the chart colours of a bar chart so that I can make sure the colours are always the same for each entry, and not different per property? For example, I have bar chart 1 with 3 properties, where 'login' is the highest. However, in bar chart 2 with the same 3 properties but different filtering, the 'app_login' is higher than in the other bar chart. Ideally, I can make sure that 'login' gets pink in both of these graphs, regardless of their position in the graph. Same goes for 'app_login'.

kapa.ai I would prefer for it to be a formula that one can choose from the "Metrics" menu as well. Something that spans our entire account, not just in this graph.

kapa.ai Thanks for that. How do I create my own metric? (I want to sum the data of property value A & B)

event Oh, fair! That's a good remark, thanks! I'll try that.

kapa.ai Well, I already have that. I mean that now I have 3 separate numbers, and I want to combine that as well into 1. If I have the following events:

Then that means Pete is counted once in both the events. But I want Pete to be counted once, still.

Why is the formula result only a 4.06, when it should be on a scale from 1-100? I know our NPS ranges between 38-45 right now. kapa.ai

kapa.ai How can I resolve this so that the NPS is calculated correctly? I am putting this formula in Mixpanel, where A = Promoters, and C = Detractors, but it keeps saying that there is an unexpected token: ( ((COUNT(A) / COUNT()) * 100) - ((COUNT(C) / COUNT()) * 100)