Creating Measures from Values in Dropdown

Question & Answer
,
1

Hi Everyone,

I have a table called appointments. Each one has a unique ID. By default is very easy for me count on distinctID. However, I want to count appointments based on characteristics.

For example I have a field called status which has values of cancelled, rescheduled, no show, arrived.

If I want to count up how many cancelled appointments there are what is the best solution? My idea is to create a new field and do a if status = cancelled, 1, 0

Then I could total all these up to get the number. Is this the best approach?

2

Hi @Derek_Sanborn,

Can you try this?

distinct_countIf(ID, status = 'cancelled')
3

Hey David,

Should I do this as a field within the dataset or a field within the dataset?

4

@David_Wong i added this as a measure inside the analyst and wanted to thank you, this was exactly what I was looking for and has unlocked so many new measures I can make!

5

@Derek_Sanborn
Glad I could help!