GrantSmith Coach 
-
Re: Custom / Manual Sort Order
Create a duplicate beast mode with the same logic you're using to create the ranges but instead of returning the ranges return a number to sort on (0, 1, 2, 3 etc) then use that new sort beast m…1 -
Re: Creating Card filters on values currently absent from a dataset
You could configure a beast mode to return the opposite and then do a NOT IN CASE WHEN Target Go-Live Date` IS NULL THEN 'Blank' ELSE 'Not-Blank' END Alternatively if you're …2 -
Re: Date Slicer - Years Only
Create a beast mode which returns YEAR(`CreatedOn`) to return the year and save it to the dataset. Alternatively you can calculate this within a dataflow. Then use this new field in your slicer filte…1 -
Re: Default date filter on dashboard not affecting cards
Are you using a date field in the graph? Does your data have different date values or are they all the same date? Can you post a redacted screenshot of your analyzer with the date picker expanded?2 -
Re: End of query request - what is wrong
@jgRugby_123098 Since your invoice number field is a string you need to use strings in your IN clause. You can do this by putting them in single quotes SELECT * FROM CHARGE_DETAIL WHERE INVOICE_NUMBE…3
