cancel
Showing results for 
Search instead for 
Did you mean: 

Story - Get value of columns in Calculated Measure/Dimension

0 Kudos

Hi everyone, i have column named On Time which has YES and NO. What i want is display a new column named OnTimeDel that has the data of YES ( 120 ).

Thank you guys!

Accepted Solutions (0)

Answers (3)

Answers (3)

Sowmiya_C
Active Participant

Hi angelooo011898,

Create a calculated measure and select a type as Aggregation and define the condition as shown below.

.

Output

Hope this will works for you !

Thanks,

0 Kudos

Hi william.yu,

The only available option is Calculated Dimension and Measure-based Dimension

William_Yu
Product and Topic Expert
Product and Topic Expert
0 Kudos

Looks to me you are creating calculated dimension, but not calculated measure. Try to find measure or account from table builder panel and create calculation from there.

William_Yu
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi angelooo011898,

Just create a calculated measure with restritction to 'On time' = YES.

Best regards, William

0 Kudos

Hi im having a problem on create calculated measure, the restricted in not showing.