Bar chart - How to display the count of a column ?

Jacques
Jacques Dataiku DSS Core Designer, Registered Posts: 6

Hi everyone,

Hope your are all doing good.

I was wondering if there is a way to create a bar chart with just using x axis and y would be the count like if we have this dataset : i just would like to have one bar with count of Id (equal to 3) and not the count per distinct id

id | name |

1| curry |

2| adebayo |

3| doncic|

Thank you for your help.

Best regards,

Jacques

Best Answer

  • CH007
    CH007 Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 5
    Answer ✓

    Good Day Jacques,

    To help solve your inquiry I’m going to make an assumption that you’re trying to build a chart through the visual interface of dataiku from a dataset currently residing within the flow. If so, below are the steps to achieve just the actual count of the IDs and nothing else.

    CH007_0-1706851111002.png

    Step #1 – Open the Dataiku Dataset and navigate to the Charts Icon.

    Step #2 – When the Charts icon appears to display the backstage view, within the left window pane dataiku lists your column options which are found within your dataset and they add an additional metric that you can create graphics from “Count of records”, drag this option to the Y axis

    Step #3 – Select your id column and drag this over to the X axis. When you see this, you will automatically notice how you get the count by individual which is binned. To achieve your objective, select the drop-down arrow to the left of the id field placed within the X axis. This opens up a drop-down menu pane and select the Number of bins to 1. This will give you the actual count of your records.

    CH007_1-1706851111011.png

Answers

  • Jacques
    Jacques Dataiku DSS Core Designer, Registered Posts: 6

    Hello CH007,

    Sorry, I did not add much details about my request. So thank you for your time replying me.

    It is absolutly what i am looking for.

    Thank you and have a nice day !

    Jacques

Setup Info
    Tags
      Help me…