Results 1 to 4 of 4

Thread: Heat Map Help

  1. #1
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8

    Answered: Heat Map Help

    I can put icon on top of a image save data into table


    MapID PK
    MAP = filename.pnp
    Icon = the Icon (metal,Glass,Hole,bla,bla,bla
    Plotx = percentage down from top of map
    Ploty = percentage from right
    ADate = date plotted
    comments =

    I can print the report which plots the icon on top of the map base on its Ploty% and Plotx%

    why percentage if change the size of the map if stays the same place .

    Looks A miss when I have Heaps of icons on the Maps in one place

    SO............................................

    I want to create a Heat map

    what i have done is all done in QuerySSSSSSSSSS so far

    Just the X plot

    GroupX = int(Plotx * 10) so this is a number 1 to 10

    now Groupby the Map and count the numbers of GroupX happy tell me how many in each 10th of the map

    now i find the Min and the Max base on the groupby of the map Now I know the Heat of it ie close to the Max the HOTTER it is

    did the same for the Y point

    and HAPPY CAMPER

    BUT !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    what I want help with is

    Ploting the GroupX and GroupY and I get a total in that square this is where im brain dead



    any Ideas
    have I miss something
    Last edited by myle; 05-28-15 at 01:02.
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  2. Best Answer
    Posted by myle

    "I have Made It A Heat Map

    Image 1 showing the the Mess
    Attachment 16525

    Now with the Maths Worked out the Heat
    and it all Maths

    Attachment 16526

    It builds the Report on the Fly"


  3. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    ...interesting
    have you got some sample data and a rough idea of what you are looking for

    off hand Im slightly confused at the need for the icon, usually when Ive seen heat maps they are effectivley expressing a frequency map of XY co-ordinates. adding a 3rd dimension (the icon) would be tricky to represent

    off hand I think it should be possible to do this in one of several ways
    as self coloured boxes (controls) on a form or report, create the boxes as required.
    ...write to a PDF file as a PD document (not too sure Ive seen a direct PDF library avaialbel in Access (such as the ones available for PHP and similar). My reason for going downt hat appraoch is that you may hit a memory issue, especially with a report.
    ...do a similar sort of thing with a PNG / GIF or JPEG.

    it may be the way to handle this is to shell out to another process that create the image layers.

    just tihginking out aloud I wonder if Access image control can handle ov erlapping iomages and through use of transparency/alpha c hannelk blending allow images underenath to appear through superimposed images).

    I do seem to rememebr that Access had serious problems in the past with image controls consuming vast amounts of memory.
    Last edited by healdem; 05-28-15 at 05:32.
    I'd rather be riding on the Tiger 800 or the Norton

  4. #3
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    OK Healdem

    hes the data

    MapID Map Image plotx ploty Adate Pdate Comments User Added_date
    1 P5RL48.png waterdrop.png 0.89351724137931 3.96984924623116E-02 4/03/2015 10:00:14 a.m. 26/11/2014 Under Explosion Door
    2 P5RL48.png waterdrop.png 0.85351724137931 3.96984924623116E-02 4/03/2015 10:00:47 a.m. 10/12/2014 Under Explosion Door
    3 P5RL48.png waterdrop.png 0.616275862068966 4.09547738693467E-02 4/03/2015 10:02:12 a.m. 26/11/2014 along wall between explosion rooms
    8 P5airlock.png waterdrop.png 0.343172413793103 0.249497487437186 6/03/2015 12:56:13 p.m. 10/12/2014 Airlock piller
    9 P5ground.png waterdrop.png 0.21351724137931 0.856281407035176 6/03/2015 1:01:45 p.m. 17/11/2014
    10 P5ground.png waterdrop.png 0.214896551724138 0.867587939698492 6/03/2015 1:02:15 p.m. 10/12/2014


    I know the number of counts in a square i want can put a Square one the top of the Map and set the background colour to the Heat number
    eg if the max was 10 points in the Square and said Square had 9 of them the background colour would be Redsh

    here is the data for Y

    Map GroupitY CCY
    P3RL24.png 7 1
    P3RL29.png 4 1
    P4 EVA HALL.png 7 3
    P4 EVA HALL.png 9 1

    data X

    Map GroupitX CCX
    P3RL24.png 7 1
    P3RL29.png 7 1
    P4 EVA HALL.png 8 3
    P4 EVA HALL.png 9 1
    P4RL10.png 8 1

    so this is telling me on the Image P4 EVA HALL.png and between 7 and 8 or 70% and 80% of the Down Y I have 3 points
    and is also telling me on the Image P4 EVA HALL.png and between 8 and 9 or 80% and 90% of the left X I have 3 points

    so putting it all as one in my head i can see
    that 70% down the map and 80% across will be a reder square than and other 90% to 100% of the Map as it only has 1 point

    I know what I want I know had to code it I lost in get the Heat value of joining the XY as one point

    Im think down the lines that if there is on one point then dont put a heat square there other wise u wont see the map LOL

    I reading this again Im getting lost now arrrrrrrrrrrrrrrrrrrrrrrrr brain dead already
    Last edited by myle; 05-28-15 at 16:55.
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  5. #4
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    I have Made It A Heat Map

    Image 1 showing the the Mess
    Click image for larger version. 

Name:	Mess.PNG 
Views:	7 
Size:	456.6 KB 
ID:	16525

    Now with the Maths Worked out the Heat
    and it all Maths

    Click image for larger version. 

Name:	HeatMap.PNG 
Views:	7 
Size:	458.5 KB 
ID:	16526

    It builds the Report on the Fly
    Last edited by myle; 08-18-15 at 17:37. Reason: Spelling
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •