Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Attached my file , i am having tough time in figuring out an expression to match the values in the staright table to the pie chart . When a user clicks on the pie chart part , corresponding data should appear in the staright table below , the data in the staright table is correct , but not sure how to include the business logiclogic in the pie chart , when ever i click the pie chart , the date range selection dissapperas and the numbers are not matched .
I have to compare ok to ship date/time value with release_date value ....if the ok to ship date/time is less than release date then it has to fall in prior to release date catogory , if the ok to ship date/time is equal to release date then within the release date catogory.
Please take a look at my working file
Thanks
I think the conditional dimension in the pie chart is the issue. Move the IF statement to the script (it's slightly wrong by the way)
=if(date(SHIP_REQUEST.CREATED_DATE)<ANSWER.ANSWER_DATE, ' Prior the Release Date ',
IF(dateSHIP_REQUEST.CREATED_DATE) >= ANSWER.ANSWER_DATE, 'Within Release Date'))
should really be
=if(date(SHIP_REQUEST.CREATED_DATE)<ANSWER.ANSWER_DATE, ' Prior the Release Date ', 'Within Release Date') AS OnSchedule (or an appropriate field name)
Then use this field in your pie chart.
Hope this helps,
Jason
I think the conditional dimension in the pie chart is the issue. Move the IF statement to the script (it's slightly wrong by the way)
=if(date(SHIP_REQUEST.CREATED_DATE)<ANSWER.ANSWER_DATE, ' Prior the Release Date ',
IF(dateSHIP_REQUEST.CREATED_DATE) >= ANSWER.ANSWER_DATE, 'Within Release Date'))
should really be
=if(date(SHIP_REQUEST.CREATED_DATE)<ANSWER.ANSWER_DATE, ' Prior the Release Date ', 'Within Release Date') AS OnSchedule (or an appropriate field name)
Then use this field in your pie chart.
Hope this helps,
Jason
Did this solve your problem?
Jason
yes ...slight change in the expression solved it ..thank you!!