Thanks for the replies i did figure it out and used my time dimension, below is the code for those wondering:

select distinct t.visit_date,t.car_id,t.car_color,d.hour_of_day_24

from TABLE t

inner join DIMENSION d

on d.string_representation_24 between...

thank you i will post more details in my future posts 🙂

it seems i have posted to soon, the solution for this problem is

update table cars set color = color from carinfo where cars.id = carinfo.id and rank = (select min(rank)...

update so issue is resolved sorry about the complex question wasn't sure how to word it however answer is below for those looking..

SELECT

...

Hey all thank you for all the replies, i used the following code to automate this query going forward, in the mean time for historical data i needed to though...

seems i have found what i'm looking for. For those who have the same question create a textbox and in the properties you can select go to report and there...

Sorry after a bit more thinking, i have the query below doing most of the what i'm looking for except the flashing portion.

This highlights a field red if a...

At this time i only use SAS for the percentile not for any other function so your solution is one step further than mine. When i review this hopefully within...

Hi Lynn & Dwayne,

I spent a few days trying to find an answer and found the closest value to be the first query i posted, however that query doesn't work...

perfect thank you

wow that seems too easy thank you, i'll look at building a dashboard of some sort. Another question i will have is when i deploy this final solution as a...

Thank you for the information. I would like to delete this topic as i have found my answer. After reading a bit it seems that we can't delete our own...

so it seems like i spoke too soon, this formula only provides you with the row in the 90th percentile not the value.

What i'm looking for is a 90th percentile...

Thank you both Eugene Elutin and s_osborne2! works great!