hey everyone welcome back to another quebec quickie it is so good to have you here this episode is brought to you by dot walk dot io i love dot walk dot io because it eliminates the hardest part of using servicenow's atf framework building the test cases let dot walk's bootstrap app populate all your atf use cases automatically and by all this international aldis is a staffing company specializing in ai and servicenow skills i love all this because with their ai podcasts they're really paying it forward in the servicenow world check out the description below for how to contact the sponsors okay today we're talking about reporting on questions which gets my finally award for scratching an itch i've had for three four five thirteen years now see back when gilgamesh traded pelts for beer in the markets of a rook we thought the variables as questions you'd ask to help create the ticket but not things we'd report on jokes on us if people can see it they want a report on it to some extent we've had the ability to report on catalog variables but now we can finally report on variables asked in record producers did you know that variables on record producers have the results stored in a completely different table that's why variable reporting was always a half done solution so here i have a record producer that asks a couple really important questions we might want to report on later and here we are on a report in the incident table i'm going to add a criteria that uses a question so i'm going to the questions section i'm going to find the record producer that i had report an issue demo and then i'm going to do the did this prevent you from work and make sure that that's yes furthermore i'm going to choose columns and add the column for how much damage we thought this did from the column selector we can see that there's questions i'm going to expand that it asks me what record producer and use my report and issue demo i'm going to put the column of how much money did this cost us run that so here we see only the three incidents where work was stopped and we see at the end how much money did this cost us oh yeah and not only can we use it in conditions and have it as a column on a list but we can also group by it as far as reporting is concerned they might as well be fields finally and thank you whoever got this done give that person a cookie