LiveCode Forums

In a moment of clarity, I wrote the following code in a new project with nothing loaded: -- Sent when the mouse is released after clicking -- pMouseButton specifies which mouse button was pressed on mouseUp pMouseButton local arrayMonths put empty into field "tblMonths" put "January" into arrayMonth...

Richard,

Tell me something, how come this does not work in Livecode - assume ccMonthDecrypted contains a properly spelled month (ex: January):
Why does that not work?

Richard, More of the same. However, I just import that data into our system, so the data is not important. What is important is for me to count two things right now (and the rest after): The Accounts per month and The Accounts per zipcode The two variables for that are: ccMonthDecrypted and ccZipDec...

I'm getting somewhere. This code works in populating the table correctly (put 1 into varLN is before the repeat loop - so that we start at line 2 in the table): ##========================================================= add 1 to varMonthCount[(ccMonthDecrypted)] add 1 to ln put ccMonthDecrypted & "...

Hi, I tried it this way: put "01/22/2020;January; [...] ; $ 7,302.00" into myData -- = the data you posted -- preparation: put the monthNames into myNames put the short monthnames into myNums repeat with i = 1 to 12 -- prepopulate array put line i of myNums into myArr[(line i of myNames)]["Num"] en...

Here is the dashboard: http://www.mfelkerco.com/stuff/dash_not_working.jpg Forget the middle and pie charts. I am concentrating on the two tables to the left and bar charts. Notice the Accounts per Month table only shows one value. Here is what it should look like: http://www.mfelkerco.com/stuff/das...

Er, what's causing this is they way you are putting (or not putting) data into the array. Can we see some source data and how you are taking the records and putting it into the array? When I said "one line", you realise it is one line in a loop to iterate over your source data? At least I presume s...

I made a button to test your early post, in order to be able to use it easily. I explicitly put some text into a variable, because I, like everyone else here, does not know how you are doing it. Have we ever gotten past the fact that I got a "hit" for january, and you only did as well? What is good...

Here: 01/22/2020;January;Blaine;Stepson;Blanchard;962-1525 Augue St.;Atlanta;Georgia;30303;USA;elit@AeneanmassaInteger.co.uk;Own;08/04/2019;169907074;475; $ 4,381.00 ; $ 4,010.00 ; $ 292,468.00 ; $ 50,403.00 ;3916130998812410;242;7708; $ 49,532.00 ; $ 8,319.00 ; $ 2,902.00 07/07/2021;July;Celeste;St...

I'm not trying to be vague, but this tech is patent pending so I am not allowed to just blurt it all out. I have this in the main repeat loop: ##========================================================= add 1 to varMonthCount[(ccMonthDecrypted)] put ccMonthDecrypted & varMonthCount[(ccMonthDecrypted...

So, after eating a meal and rebooting my computer, I feel a bit better. Now: -- double-check the results with a visual check that there are only 12 valid month name keys in the array put the keys of varMonthCount --or answer the keys of varMonthCount put empty into tMonthCountList --just to clear it...

I appreciate the help everyone. The other dilemma is that this solution lists each month found and then a number so there are multiple months with different numbers. Not sure how to read it. Ie: October 1 January 3 ... October 2 January 1 Point is, there are 403 records and this will give me 403 res...

As Richard says, it looks like we need to see where the assignment of ccMonthDecrypted is made. Personally I wouldn't use an if/then or switch structure for this, it's crying out for an array. One line: add 1 to varMonthCount[(ccMonthDecrypted)] The added advantage of this is that you can see exact...

Did not work. Resulted in all '0's

It's like the variable is being reset or emptied. I just don't get it.

Mike

Yes, case is correct.

I can try switch, but will it work over the if/then = statement?

Mike