I have data from an MySQL table that have many date, three date exactly.
I have to display some graphics and give the possibility to the user to select a set of date and see the result just for the selected date.
To do it, I've created a Reference Date table.
Here is my script:
ODBC CONNECT TO ADV;
[Data Agent ADV]:
LOAD `Numero_de_demande` AS [Numero de Demande],
`date_d_arrivee_DSC` AS [Date d'Arrivee DSC], Week(date_d_arrivee_DSC) AS [Semaine Arrivee DSC], MonthName(date_d_arrivee_DSC) AS [Mois Arrivee DSC], Year(date_d_arrivee_DSC) AS [Annee Arrivee DSC],
`Livraison_attendue` AS [Date de Livraison Attendue], Week(Livraison_attendue) AS [Semaine Livraison Attendue], MonthName(Livraison_attendue) AS [Mois Livraison Attendue], Year(Livraison_attendue) AS [Annee Livraison Attendue],
`Canal_d_arrivee` AS [Canal d'Arrivee],
provenance AS [Provenance],
`Numero__de_compte` AS [Numero de Compte],
`Nom_Client` AS [Nom du Client],
`Nbre_de_lignes` AS [Nombre de Lignes],
`Numero_tache` AS [Numero de la Tache],
Objet AS [Objet],
Typologie AS [Typologie],
Traitant AS [Traitant],
Validation AS [Validation],
`date_de_transmission` AS [Date de Transmission],
`date_de_retour` AS [Date de Retour],
interlocuteur AS [Interlocuteur],
`date_de_traitement` AS [Date de Traitement], Week(date_de_traitement) AS [Semaine Traitement], MonthName(date_de_traitement) AS [Mois Traitement], Year(date_de_traitement) AS [Annee Traitement],
`Livraison_effective` AS [Date de Livraison Effective],Week(Livraison_effective) AS [Semaine Livraison Effective], MonthName(Livraison_effective) AS [Mois Livraison Effective], Year(Livraison_effective) AS [Annee Livraison Effective],
`delai_de_traitement_DSC` AS [Delai de Traitement DSC],
`delai_de_livraison` AS [Delai de Livraison],
`Date_de_reception_ADV` AS [Date de Reception ADV],Week(Date_de_reception_ADV) AS [Semaine Reception ADV], MonthName(Date_de_reception_ADV) AS [Mois Reception ADV], Year(Date_de_reception_ADV) AS [Annee Reception ADV],
`Delai_de_traitement__ADV` AS [Delai de Traitement ADV],
RMT_ADV AS [RMT ADV],
Palier_RMT_ADV AS [Palier RMT ADV]
;
SQL SELECT *
FROM adv.dataadvagent;
[Reference Date]:
LOAD DISTINCT [Date de Traitement] AS Date
Resident [Data Agent ADV];
Then, I created a list of date from [Reference Date] in such a way that all formula will use the seleted that from [Reference Date] to display result but it doesn't work at all.
Here is one of my SET Analysis statement
Sum(Aggr (Sum ( {1<[Date de Reception ADV]={"=$(=P(Date))"}>} [Nombre de Lignes]), [Date de Reception ADV], Typologie))
