Drill Down Links

[jlomeli]

Hello,

I have a line chart that shows a data point for 30 days. I need to be able to click one of the data points and get the value for the DAY that was clicked. I have the drill down working I just need to get the day. Can I do this with just PHP and XML? How?

$stringData = "<set label='$date' Value='$xnum' link='http://mydomain.com/SPAWeb/ProbeApp/OneProbe.1.Day.Hourly.php?prbname=$prbname&day=DataFromClick' />";

 

Thank you.

[Pallav]

Yes - just make sure to URLEncode the link attribute part.

[jlomeli]

Hello.

I dont understand how to get the click data.  The date is in my xml file like this:

<category label='2007-02-28' />

If I move the mouse over the datapoint I can see the date. How do I get that value when I click and get it into my drill down link??  Thanks

$stringData = "<set label='$date' Value='$xnum' link='http://mydomain.com/SPAWeb/ProbeApp/OneProbe.1.Day.Hourly.php?prbname=$prbname&day=DataFromClick' />";

 

Pallav (3/9/2007)

---

Yes - just make sure to URLEncode the link attribute part.

[Pallav]

When you're providing this link in the XML, make sure to URL Encode it so that it looks as under:

<set ... link='http%3A%2F%2Fmydomain%2Ecom%2FSPAWeb%2FProbeApp%2FOneProbe%2E1%2EDay%2EHourly%2Ephp%3Fprbname%3D%24prbname%26day%3DDataFromClick%27' />

[jlomeli]

I posted a reply here on Friday, that appears to have been deleted ?

I will post again.. I dont think we are understanding each other..

My question is how do I get the value from the data point that is clicked on the chart? My chart has 30 days of the month for the x axis. Each data point is a date like this:

2007-03-21

I want to retrive the DATE value for my URL

http://mydomain.com/SPAWeb/ProbeApp/OneProbe.1.Day.Hourly.php?prbname=$probename&date=<---HOW DO I GET THIS VALUE?

When I code the php to write the XML:

$stringData = "<set value='$xnum' link='http://d2ml2491.dev.sprint.com/SPAWeb/ProbeApp/OneProbe.1.Day.Hourly.php?prbname=$prbname' /> ";  <<-- this works

I want to add "&date=" to the end of the link but I dont know the value of DATE until the chart is clicked. Is there a function that I should put here? &date=(function)? that will tell me what is clicked?

Please advise.

Thank you.

Edited March 25, 2007 by Guest

[halizia]

i don't know if i understood it properly, but if you're working in php you should do this:

 

 

 

$var=$_GET['date'];

 

 

 

 

 

Bye!