"derivedMeasures": [
Sample of current code is not returning the result in leading "5" symbol. 

{
  "field": "MQL_%",
  "format": {
  "customFormat": "[\"% ###\"]"
  },
  "label": "MQL Percent",
  "showInExplorer": true
  }

Lead = load "Lead_Opportunities";
Lead = filter Lead by 'StageName' == "Closed Won";
VMS = load "StarOpportunities";
VMS = filter VMS by 'StageName' == "07b_Closed Won";
Result = group Lead by 'all' full, VMS by 'all';
Result = foreach Result generate count(Lead.'Id') + count(VMS.'Id') as 'Closed / Won';

How does one apply Lens or SQL filter to obtain records for curent date?
This does not work for example;
q = filter q by date('CreatedDate_Year', 'CreatedDate_Month', 'CreatedDate_Day') == TODAY();

Lead = load "Lead_Opportunities";
Lead = filter Lead by 'StageName' == "Closed Won";
VMS = load "StarOpportunities";
VMS = filter VMS by 'StageName' == "07b_Closed Won";
Result = group Lead by 'all' full, VMS by 'all';
Result = foreach Result generate count(Lead.'Id') + count(VMS.'Id') as 'Closed / Won';

How does one apply Lens or SQL filter to obtain records for curent date?
This does not work for example;
q = filter q by date('CreatedDate_Year', 'CreatedDate_Month', 'CreatedDate_Day') == TODAY();

How does one apply Lens or SQL filter to obtain records for curent date?
This does not work for example;
q = filter q by date('CreatedDate_Year', 'CreatedDate_Month', 'CreatedDate_Day') == TODAY();