how to get a chart in dataset output

Ncls Registered Posts: 1


I have a request because I can't find any way to do what I want

I have a table with the following columns:
- keywords, which correspond to the keywords of several 10 competing sites (so there are duplicate keywords.)
- search volume for each keyword
- url positioned on the keywords
- NDD of the positioned url (extract)

I want to know how many ndd's are positioned for each keyword

Keyword 1 = 4 sites
keyword 2 = 2 sites
Keyword 3 = 8 sites

In the charts, I can do this easily (I put the keywords column in X and the NDD column of the positioned url in Y)

However, I would like to obtain a table at the output of the data set, but I can't.

Thank you very much for your help.

Operating system used: windows


  • Sarina
    Sarina Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer Posts: 315 Dataiker

    Hi @Ncls

    Would you be able to use a group recipe to group by keyword and get the count of NDD of positioned URL counts? "Count" can be selected as the aggregation value for the NDD column.

    If that doesn't seem like it will work for you, would you mind providing a dummy example of a couple of input rows of data and the desired output table rows?

    Thank you!

Setup Info
      Help me…