% survived measure

Marjolein
Marjolein Member Posts: 11 Type 0.5
in Inspiration

Goodmorning,


I just build my first measures in Astrato for the Titanic challenge but I don't see what I expected in the visual.

image.png

Anybody who sees what I do wrong? It should give about 36,4 % instead of 0,00%

image.png


Comments

  • joe_warbington
    joe_warbington Member, Partner, Customer Posts: 158 Type 2

    Hi @Marjolein - have you tried to create this or experiment with other variations of this measure in the Data Explorer? You can find this in the Data View section of your workbook:

    image.png


    There may non-numeric data or some null values that result in an answer of 0.

  • Marjolein
    Marjolein Member Posts: 11 Type 0.5

    This one is working well, gladly, but I need the % survived...


    image.png


    image.png



    I'm afraid I can't solve the other one myself


    image.png


    image.png


  • dataemily
    dataemily Member Posts: 93 Type 2

    @Marjolein Did you try changing "YES" to "Yes"? The filter should be case sensitive. I hope this is a simple one 🤞

  • Marjolein
    Marjolein Member Posts: 11 Type 0.5

    That works, stupid... I'm not good in capitals, thx for your quick response!

    image.png


Categories