Solved

visualization of data frequency

  • 10 July 2020
  • 3 replies
  • 101 views

Hi,

i want to visualize the frequency of postcodes from a table with a barchart,

 but I didnt have any ideas how to do this. Can somebody help?

Thanks

 

 

icon

Best answer by mateusarakawa 10 July 2020, 23:01

Hi, @Gergely.

I would create a set called S_AllePostleitzahlen with attributes ‘Index’ set to “PLZ” and ‘Parameter’ set to “Pe_PLZ”: 

Then I would populate this set with all possible PLZ:

Remark: you can also populate it easily with every PLZ that has frequency >= 1 using your original table Hilfsbeduerftige(i), that I named P_YourOriginalTable(i,) using a procedure:

 

After that, I would create a parameter P_PostleitzahlHaufigkeit(PLZ) that counts the PLZ frequency:

and then you can use this parameter (P_PostleitzahlHaufigkeit(PLZ)) directly on the barchart object.

Idk if it’s the best approach but it works. Hope it helps!

View original

3 replies

Userlevel 5

Hi, @Gergely.

I would create a set called S_AllePostleitzahlen with attributes ‘Index’ set to “PLZ” and ‘Parameter’ set to “Pe_PLZ”: 

Then I would populate this set with all possible PLZ:

Remark: you can also populate it easily with every PLZ that has frequency >= 1 using your original table Hilfsbeduerftige(i), that I named P_YourOriginalTable(i,) using a procedure:

 

After that, I would create a parameter P_PostleitzahlHaufigkeit(PLZ) that counts the PLZ frequency:

and then you can use this parameter (P_PostleitzahlHaufigkeit(PLZ)) directly on the barchart object.

Idk if it’s the best approach but it works. Hope it helps!

Thank you for your fast response, you helped me a lot.

Userlevel 6

Hi @Gergely , would be great if you share how you solved it and show a screendump of the end result. Would be a nice share as I am sure  there are more people interested.

Reply


Didn't find what you were looking for? Try searching on our documentation pages:

AIMMS Developer & PRO | AIMMS How-To | AIMMS SC Navigator