I have a chart to link to an IR. I am trying to set the link in the query to link to an IR where the column values are null. I'm on Apex 5.1.
This is my query. Can someone correct the link in the query to a column where the values are null please? I've tried using the Link Builder to see how the link would appear so I could copy it, but I'm not able to go that route either.
select url, label, Value
'Patients Added' label,
sum(case when CR_MDT_PHYS is null then 1 else 0 end) Value
where CR_MDT_DT between TO_DATE('01/01/2017', 'mm/dd/yyyy') and TO_DATE