Can a Pareto Chart be created in DIAdem?

[jsmalley]

Is this possible to do?  I know LabVIEW has some in the toolkit. But I wasn't sure if there was some way to this with channel data in DIAdem.

[Walter_Rick]

Hi jsmalley,

Yes, it is possible. DIAdem doesn't have a ready to use function for it but with a small script it is realizable. I have attached such an example.

Greetings
Walter

[James M]

Hi jsmalley,

If you have the english version of DIAdem you will need to change the following line:
Call ChnHistogram("[4]/Temperatur_1","/ClassMean","/SampleCount","NoBeginWidth","absolute")
to:
Call ChnHistogram("[4]/Temperature_1","/ClassMean","/SampleCount","NoBeginWidth","absolute")

Regards,

[jsmalley]

Thanks. I looked at the example earlier and saw the typo. It does run correctly.

My issue is that I need to do the Pareto based on text data. So the histogram as is won't work directly. My thinking is that I have to have a lookup integer table based on the text entries.

1. Sort the text channel.

2. Loop through the values and assign a numical integer to each unique text string type found, which will go into another channel.

3. Create the histogram based on the integer representative numbers and refer back to to the text data channel for x-axis values.

What I'm looking for is getting the text names on the x-axis and number of occurances on the y-axis.

[Walter_Rick]

Hi jsmalley,

Sorry for the German channel name (the different is just the "e").
What you are looking for is already implemented in the example - just with numeric information. Typically DIAdem creates the axis text in a strait order like 1,3,5,7. For the Pareto chart this order doesn't exist - it can be like 5,1,7,3. To realize that I've defined a user command which creates the axis text depending on an index channel but taken from an other numeric channel. This user command is called in the "Axis parmeters" > "Format". You just need to replace the numeric channel with your text channel.

Greetings
Walter

[Brad_Turpin]

Hi jsmalley,

How do you want to launch this code?  Are you perhaps wanting to create a pareto graph of a property column in the Search Results of the DataFinder in NAVIGATOR, or are you wanting to run this as part of an analysis of already loaded channels?  I ask because I have very similar code to what you want, but it's embedded in custom NAVIGATOR menus.  I could rip it out for you, but if that's where you really want it, I'll just send it to you as-is.

Brad Turpin
DIAdem Product Support Engineer
National Instruments

[jsmalley]

Hi Brad.

I want to do the Pareto on channels that are already loaded.

Bascally I have multiple TDM files with N-groups and M-channels. The number of groups per file changes but the number of channels per group never changes. I want to pull in a particular channel  from all of the TDM files that I want to analyze and do a Pareto on that data. The data in question is Text.

I've been looking through and modifying the example Importing Data From Multiple DataPlugin Files.VBS  to try and get my data imported correctly. I assume I have to get the data all concantenated into one channel to do the histogram, so I'm working on that part right now.

[Brad_Turpin]

Hi jsmalley,

I actually prefer the following code for concatenating channels from multiple files-- it's more complicated but is ready to use and can be parametrized pretty easily for your purposes.  Feel free to use the DIAdem example if you prefer, but I thought it would be nice for you to have both options.  If you would like to give this code a try, also feel free to ask me questions about it (I created it).

Walter or I will get back to you soon regarding the text channel Pareto chart,
Brad Turpin
DIAdem Product Support Engineer
National Instuments

[Brad_Turpin]

Hi jsmalley,

Here's the promised code to calculate a Histogram and a Pareto Chart from a text channel.

Ask if you have questions,
Brad Turpin
DIAdem Product Support Engineer
National Instruments

[jsmalley]

Thanks Brad.

Is there something missing in the files?  I get a script error about the function ReplaceGroupInPath. I don't see it in the script.

I was able to get something going based on the multiple file.zip that you attached and the Pareto.zip that Walter attached. Of course my script isn't as elegant.  I attached a pdf of the Pareto that I was able to get from it.