Is it possible to create a graph with categorical levels?

Hello! ☺️

I have this card in which every number (1-2-3-4) represents 4 possible levels of a scale (1-> Insufficient, 2-> Regular, 3->Sufficient, 4->Outstanding). Is it possible to create this card but with categorical levels so the card doesn't show 1, 2, 3 and 4 but the categoribal words?


Best Answers

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟤
    Accepted Answer

    @ramoshe if you want categorical values on the X and Y axis you'd need a different chart type.

    Consider a heat map. or pivot table

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🟤
    Accepted Answer

    Agree with @jaeW_at_Onyx . I often use a heat map for this type of work. See below.


Answers

  • You can create a beast mode and use that in your card instead of the field containing the number.


    CASE WHEN number = 1 THEN 'Insufficient'

    when number = 2 THEN 'Regular'

    when number = 3 THEN 'Sufficient'

    when number = 4 then 'Outstanding'

    end


    You'd replace "number" with whatever your field name is.

  • Thanks @mhouston, but the problem is that originaly it's a categorical field (Insufficient, Regular, Sufficient, Outstanding). It is to say I used the reverse beast mode of the one you showed me in order to get the numerical values that can be used in the x-axis. I am asking if is possible to use the categoricals for the x-axis somehow. 😥

  • Hi @ramoshe, for the graph you've selected, the x-axis needs to have some sort of measure field so perhaps it's better to represent that categorical levels information through another chart type (e.g. Pie chart), and the users can filter between the options based on your y-axis field.