Words cloud

Hi Raimondas,

Thank you for reaching out. I think that this is a valid idea for future Yellowfin enhancement, but before I convert this question into an idea, I was wondering if you could provide our product team with a bit more information on the exact functionality that you are seeking, such as:

• What would you like to see, and where within Yellowfin would this be implemented? Would you like to see this added as a new chart type?
• Could you provide us with an example screenshot and use case?

I look forward to your response.

Regards,

Nathan

Hi Nathan,

Here is the example i have found: http://www.clearlyandsimply.com/clearly_and_simply/2015/02/word-clouds-with-microsoft-excel.html

The functionality i see it could be implemented could look like this:

1) to select a field which contains text (string or clob or xml).

2) to put parameters to the function which parses the source of text. For parsing you can look into this example: https://eight2late.wordpress.com/2015/05/27/a-gentle-introduction-to-text-mining-using-r/

3) when i have a table of two columns ( word (or phrase); frequency), then i could choose a chart type word cloud which could draw a special chart. Parameters for the chart output can be different from font to color: http://shiny.rstudio.com/gallery/word-cloud.html

BR.,

r.

Hi Raimondas,

Thank you for the elaboration. Currently, there are no plans to include text parsing in Yellowfin. This is something that would need to be applied to your data using a third party tool such as R, then imported into Yellowfin.

However, once the requisite fields have been created within your database, being able to employ a word cloud chart type is an idea that we think is worth considering for future builds.

I have converted this question to an idea so that it may be open to voting from the community. At the end of each month, the product team will review all ideas and consider the most popular and feasible ideas for future Yellowfin enhancement.

Please let me know if you have any further questions regarding this issue.

Nathan

Any progress on this? It's something we would be very interested in.

Hi Peter,

This can now be done with JavaScript charts in 7.3+. Something like this should provide the example source you need:

https://julienrenaux.fr/2014/09/23/d3-js-responsive-word-cloud/

Hopefully this gets you startedn let me know if you have any questions.

Regards,

Nathan

Thanks Nathan. I see this requires a reference to d3.layout.cloud.js, which I have placed under /js/chartingLubraries, but I'm unclear as to how the function is defined for this. Can you advise?

I'm also assumng the standard reference to a 2 column dataset (text, number) is acceptable, rather than using the js file used in this instance.

Hi Peter,

This will be placed into the "require" function, as this is how Yellowfin loads the required javascript libraries. I have attached an example word cloud built off ski-team data. This also shows you how to incorporate Yellowfin data into the script.

Let me know if this doesn't help and I can explain further :)

Regards,

Nathan

Thanks Nathan, appreciate that. I've put d3.layout.cloud.js under chartingLibraries, but see from your file that the reference is simply to '/js/chartingLibraries/cloud', so I've renamed it 'cloud.js'. Is that correct? The problem is that 'cloud' is undefined (see attached), so when 'cloud()' gets called later on it fails.

Its OK, fixed it now - had the wrong version of d3.layout.cloud.js - correct version is at https://bl.ocks.org/jasondavies/5d88eaa7bdc776fbae67f96718614eda

Thanks for your help Nathan.

No problem, glad you got it working!

Regards,

Nathan

Hi Nathan, we are also attmepting to set up as variation on the word cloud using a bubble cloud option and d3plus. For this, I need the data in the shape of:

reportdata = [

{"band": "Client ABC", "word": "Trauma", "Count": 81},

but my reportdata function returns it like this:

0: (3) ["Band", "Word", "Count"]

1: (3) ["Client ABC", "Trauma", 81]

How do I rearrange the data in my function to achieve this?

Hi Peter,

I would suggest something along the lines of the following :

reportdata=[]
for (int i=0;i<data.band.length;i++){
    reportdata.push({"band": data.band[i].raw_data, "word": data.word[i].raw_data, "count": data.count[i].raw_data})

I have been working mostly in Java recently so I cannot guarantee my JavaScript syntax here, but you will need to create your own reportdata. Let me know if this makes sense.

Regards,

Nathan

Thanks a lot for this Nathan, worked a treat!

Only needed one small change (for others interested): instead (for(int i=0; use for(var i=0;

Appreciate your help here.

A small postcript: I can now preview the bubble chart, but on design or view I get an error: d3plus is not defined (sometimes d3 is no defined). I'm referencing the d3 library that comes with d3plus:

generateChart = function (options)

{

require(['js/chartingLibraries/d3plus/d3', 'js/chartingLibraries/d3plus/d3plus'], function (d3)

{ etc.

Should the reference be different in some way?

I should add that I can repeatedly show the chart in preview mode without errors, but not in design mode where this error keeps repeating. The code is attached for information.

Hi Peter,

First, glad to hear that you got it working. Another alternative to storing the charting library in YF is to reference the URL here. The below link contains the CDN for d3 specifically, but you can typically find any library by googling "CDN _____".

https://cdnjs.com/libraries/d3

Can you try using this instead?

Regards,

Nathan

That worked thanks Nathan, not sure why but all is well now. Feel free to close this item.

Hi Peter,

Cool, I am not sure either. It should work equally consistently when referencing an internal address.

I will close this now, let me know if you run into any other problems.

Nathan