Returnerar ett beräknat värde med hjälp av lämplig aggregeringsfunktion, baserat på uttrycks aggregeringstyp. Syntax: aggregat (expr auto) aggregat (expr för alla expr) aggregat (expr för rapport) Räkning: Returnerar antalet valda dataobjekt exklusive NULL-värden. Nyckelordet distinkt är tillgängligt för bakåtkompatibilitet av uttryck som används i tidigare versioner av produkten. Syntax: räkning (distinkt expr auto) räkning (distinkt expr för alla expr) räkna (separat expr för rapport) Exempel: räkna (gosalesgoretailers. Products. Product name) - (upp: 41, 15, 21) Räkning (Produkttyp för all produktlinje) ------------ (upp: 5, 4, 4) Räkning (Produkttyp för vilken produktlinje) ----------- (upp: 5, 4, 4) Count (Produkttyp för rapport) ------------------- (upp: 21 för alla) Max: Returnerar maximivärdet för valda dataobjekt. Nyckelordet distinkt är tillgängligt för bakåtkompatibilitet av uttryck som används i tidigare versioner av produkten. Syntax: maximalt (distinkt expr auto) maximalt (distinkt expr för alla expr) maximum (särskiljande expr för rapport) Exempel: max (antal) -------------------- ------------ (upp: 962) maximum (Kvantitet för alla gosalesgoretailers. Products. Product type) (upp: 344,4368230) Maximalt (Antal för alla gosalesgoretailers. Products. Product name) : 44,78,8230.) Maximalt (Antal för rapport) ------------------- (upp: 1,646) Minsta: Returnerar minimivärdet för valda dataobjekt. Nyckelordet distinkt är tillgängligt för bakåtkompatibilitet av uttryck som används i tidigare versioner av produkten. Syntax: Minsta (särskiljande expr auto) minimum (distinkt expr för alla expr) minsta (separat expr för rapport) Exempel: Minsta (Mängd) -------------- (op: 43,330, 142,150 ) Minimum (Antal för alla Produkttyp) ---- (Op: 6, 4, 4, 8230.) Minsta (Antal för alla Produkttyp) 8211 (Op: 6, 4, 4.) Minsta (Antal för rapport) ----------------- (op: 2) Moving-Average: Returnerar värdet genom att lägga till värdena till det föregående baserat på numericexp. Syntax: moving-average (numericexpr. Numericexpr vid exp-prefilter) moving-average (distinkt numericexpr. Numericexpr prefilter). för expr för rapport auto Exempel: moving-average (Antal, 2) (op: Kvantitet Flyttande medelvärde 198,676 198,676 345,096 271,886 95,552 220,324 96,246 95,889 Flytt-Totalt: Returnerar värdet genom att lägga till värdena till föregående baserat på numericexp Syntax: förflyttnings-summa (numericexpr. numericexpr vid exp-förfilter) förflyttnings-total (distinkt numericexpr. numericexpr prefilter). expr för rapport auto Exempel: Total-rörelse (Mängd, 3) Utgång: Mängd Flyttande medelvärde 198,676 198,676 345,096 543,772 95,552 639,324 96,246 536,894 Procentandel: Returnerar procenten av det totala värdet för valda dataobjekt. Används endast i relationella datakällor. Syntax: procentandel (numericexpr vid exp prefilter) procentandel (distinkt numericexpr prefilter). Expr för rapport auto Exempel: procentandel Op: 16, 12, 10.) Procent: Returnerar ett värde på en skala av hundra som anger procenten av en fördelning som är lika med eller under de valda data poster. Syntax: percentil (numericexpr vid exp-förfilter) percentil (distinkt numericexpr-förfilter). för expr för rapport auto Exempel: percentil (Quantity) -------- (op: 100, 95, 90) Kvantitet: Returnerar värdet för ett värde för ett intervall som du anger. Den returnerar heltal för att representera valfritt antal rader, till exempel 1 (högsta) till 100 (lägsta). Syntax: quantile (numericexpr, numericexpr vid exp prefilter) quantile (distinkt numericexpr, numericexpr prefilter). för expr för rapport auto Exempel: quantile (Quantity, 5) --- (op: 1, 2, 3, 4, 5) Quartile: Returnerar värdet av ett värde representerat som heltal från 1 (högsta) till 4 ), i förhållande till en grupp av värden. Syntax: kvartil (numericexpr vid exp prefilter) kvartil (distinkt numericexpr prefilter). för expr för rapport auto Exempel: kvartil (Mängd) ---------- (op: 1, 2, 3, 4) Returnerar rankvärdet för valda dataobjekt. Om två eller flera rader knyts, finns det ett gap i sekvensen av rankade värden (även känd som olympisk ranking). Syntax: rank (expr sortorder vid exp prefilter) rank (distinkt expr sortorder prefilter). för expr för rapport auto Exempel: Rang Mängd) ----------------- (upp: 1, 2, 3, 4, 8230 ..) Returnerar löpande medelvärde för rad (inklusive den aktuella raden) för en uppsättning värden Syntax: löpande medelvärde (numericexpr vid exp-förfilter) löpande medelvärde (distinkt numericexpr-förfilter). för expr för rapport auto Exempel: löpande antal Kvantitet) ------------ (op: Kvantitet Flyttande medelvärde 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Löpningsantal: Returnerar löpande räkning för rad (inklusive den nuvarande raden) för en uppsättning värden. Syntax: löpnummer (numericexpr vid exp-förfilter) körräkning (distinkt numericexpr prefilter). expr för rapport auto Exempel: löpnummer (Quantity) ------- (upp: 1, 2, 3, 8230) Returnerar en kördifferens för rad, beräknad som skillnaden mellan värdet för den aktuella raden och föregående rad (inklusive den aktuella raden) för en uppsättning värden. Syntax: skillnad (numericexpr vid exp prefilter) kördifferens (distinkt numericexpr prefilter). expr för rapport auto Exempel: kördifferens (antal) - (op: null, 146420, -249,544, 8230 ..) Returnerar löpande maximalt med rad (inklusive den aktuella raden) för en uppsättning värden. Syntax: kör-max (numericex pr vid förförfilter) körhastighet (distinkt numericexpr förfilter). för expr för rapport auto Exempel: kör-max (Quantity) --------- (upp: 198676, 345096) Returnerar löpminimum för rad (inklusive nuvarande rad) för en uppsättning värden. Syntax: körminimum (numericexpr vid exp prefilter) körminimum (distinkt numericexpr prefilter). för expr för rapport auto Exempel: körminimum (antal) --------- (upp: 198676, 198676, 95552,) Returnerar en löpande total för rad (inklusive den aktuella raden) för en uppsättning värden. Syntax: körtall (numericalxpr vid exp prefilter) körtall (distinkta numericexpr prefilter). för expr för rapport auto Exempel: körtall (Mängd) ----------- (op: 198676, 5437728230.) Returnerar standardavvikelsen för valda dataobjekt. Nyckelordet distinkt är tillgängligt för bakåtkompatibilitet av uttryck som används i tidigare versioner av produkten. Syntax: standardavvikelse (distinkt expr auto) standardavvikelse (distinkt expr för all expr) standardavvikelse (distinkt expr för rapport) Exempel: standardavvikelse (kvantitet) ------ (op: 50.628, 69.098 8230) standardavvikelse (antal för alla produkttyp) -------- (op: 50.628, 69.098, 8230) standardavvikelse (antal för vilken produkttyp) ------ (upp: 50.628, 69.098 8230) standardavvikelse (Kvantitet för rapport) -------------------- (upp: 59.70671027) Rapport: Standardavvikelse Standardavvikande pop: Beräknar befolkningsstandardavvikelsen och återvänder kvadratroten av befolkningsvarianansen. Nyckelordet distinkt är tillgängligt för bakåtkompatibilitet av uttryck som används i tidigare versioner av produkten. Syntax: standardavvikelse-pop (distinkt expr auto) standardavvikelse-pop (distinkt expr för alla expr) standardavvikelse-pop (distinkt expr för rapport) Exempel: standardavvikelse-pop (kvantitet) ---- --- (upp: 50.62240898, 69.09035128) standardavvikelse-pop (antal för alla produkttyper) (antal: 50.62240898, 69.09035128) standard - avvikelse-pop (Antal för rapport) --- (upp: 59.70601702,) Totalt: Returnerar det totala värdet av valda dataobjekt. Nyckelordet distinkt är tillgängligt för bakåtkompatibilitet av uttryck som används i tidigare versioner av produkten. Syntax: totalt (separat expr auto) totalt (distinkt expr för alla expr) totalt (separat expr för rapport) Exempel: totalt (antal) --------------- (upp: 198,676, 345.096) Totalt (Antal för alla Produkttyp) ----- (upp: 198,676, 345,096) Totalt (Antal för rapport) --------------- (upp: 2215354) Rapport: Totalvariation: Returnerar variansen för valda dataobjekt. Nyckelordet distinkt är tillgängligt för bakåtkompatibilitet av uttryck som används i tidigare versioner av produkten. Exempel: varians (Mängd) ----- (upp: 2563.244, 4774.5438230) varians (antal för alla Produkttyp) -------- (op: 2563.244, 4774.5438230) varians (Kvantitet för vilken produkttyp) ------- (upp: 2563.244, 4774.5438230) varians (Kvantitet för rapport) ------- --------------- (op: 3,564.89125097) Returnerar befolkningsvariationen av en uppsättning siffror efter borttagning av nollorna i den här uppsättningen. Syntax: varians pop (distinkt expr auto) varians-pop (distinkt expr för alla expr) varians-pop (distinkt expr för rapport) Exempel: varians-pop (Quantity) ------- (upp: 2,562,6282905, 4,773.47663957) varians pop (Antal för alla Produkttyp) ----------- (upp: 2,562,6282905, 4,773,47663957) varians pop (antal för vilken produkttyp) -------- (op : 2,562,6282905, 4,773,47663957) varians pop (Antal för rapport) ------ (op: 3,564.80846781) Inlagd av Ramana Reddy CH kl 22: 44Cognos Sammanfattningsfunktioner Aggregat: Returnerar ett beräknat värde med lämplig aggregeringsfunktion, baserat på aggregeringstyp av uttrycket. Syntax: aggregat (expr auto) aggregat (expr för alla expr) aggregat (expr för rapport) Räkning: Returnerar antalet valda dataobjekt exklusive NULL-värden. Nyckelordet distinkt är tillgängligt för bakåtkompatibilitet av uttryck som används i tidigare versioner av produkten. Syntax: räkning (distinkt expr auto) räkning (distinkt expr för alla expr) räkna (separat expr för rapport) Exempel: räkna (gosalesgoretailers. Products. Product name) - (upp: 41, 15, 21) Räkning all produktlinje) ------------ (upp: 5, 4, 4) Räkning (Produkttyp för vilken produktlinje) ----------- (upp: 5, 4, 4) Count (Produkttyp för rapport) ------------------- (upp: 21 för alla) Max: Returnerar maximivärdet för valda dataobjekt. Nyckelordet distinkt är tillgängligt för bakåtkompatibilitet av uttryck som används i tidigare versioner av produkten. Syntax: maximalt (distinkt expr auto) maximalt (distinkt expr för alla expr) maximum (särskiljande expr för rapport) Exempel: max (antal) -------------------- ------------ (upp: 962) maximum (Kvantitet för alla gosalesgoretailers. Products. Product type) (upp: 344,4368230) Maximalt (Antal för alla gosalesgoretailers. Products. Product name) : 44,78,8230.) Maximalt (Antal för rapport) ------------------- (upp: 1,646) Minsta: Returnerar minimivärdet för valda dataobjekt. Nyckelordet distinkt är tillgängligt för bakåtkompatibilitet av uttryck som används i tidigare versioner av produkten. Syntax: Minsta (särskiljande expr auto) minimum (distinkt expr för alla expr) minsta (separat expr för rapport) Exempel: Minsta (Mängd) -------------- (op: 43,330, 142,150 ) Minimum (Antal för alla Produkttyp) ---- (Op: 6, 4, 4, 8230.) Minsta (Antal för alla Produkttyp) 8211 (Op: 6, 4, 4.) Minsta (Antal för rapport) ----------------- (op: 2) Moving-Average: Returnerar värdet genom att lägga till värdena till det föregående baserat på numericexp. Syntax: moving-average (numericexpr. Numericexpr vid exp-prefilter) moving-average (distinkt numericexpr. Numericexpr prefilter). för expr för rapport auto Exempel: moving-average (Antal, 2) (op: Kvantitet Flyttande medelvärde 198,676 198,676 345,096 271,886 95,552 220,324 96,246 95,889 Flytt-Totalt: Returnerar värdet genom att lägga till värdena till föregående baserat på numericexp Syntax: förflyttnings-summa (numericexpr. numericexpr vid exp-förfilter) förflyttnings-total (distinkt numericexpr. numericexpr prefilter). expr för rapport auto Exempel: Total-rörelse (Mängd, 3) Utgång: Mängd Flyttande medelvärde 198,676 198,676 345,096 543,772 95,552 639,324 96,246 536,894 Procentandel: Returnerar procenten av det totala värdet för valda dataobjekt. Används endast i relationella datakällor. Syntax: procentandel (numericexpr vid exp prefilter) procentandel (distinkt numericexpr prefilter). Expr för rapport auto Exempel: procentandel Op: 16, 12, 10.) Procent: Returnerar ett värde på en skala av hundra som anger procenten av en fördelning som är lika med eller under de valda data poster. Syntax: percentil (numericexpr vid exp-förfilter) percentil (distinkt numericexpr-förfilter). för expr för rapport auto Exempel: percentil (Quantity) -------- (op: 100, 95, 90) Kvantitet: Returnerar värdet för ett värde för ett intervall som du anger. Den returnerar heltal för att representera valfritt antal rader, till exempel 1 (högsta) till 100 (lägsta). Syntax: quantile (numericexpr, numericexpr vid exp prefilter) quantile (distinkt numericexpr, numericexpr prefilter). för expr för rapport auto Exempel: quantile (Quantity, 5) --- (op: 1, 2, 3, 4, 5) Quartile: Returnerar värdet av ett värde representerat som heltal från 1 (högsta) till 4 ), i förhållande till en grupp av värden. Syntax: kvartil (numericexpr vid exp prefilter) kvartil (distinkt numericexpr prefilter). för expr för rapport auto Exempel: kvartil (Mängd) ---------- (op: 1, 2, 3, 4) Returnerar rankvärdet för valda dataobjekt. Om två eller flera rader knyts, finns det ett gap i sekvensen av rankade värden (även känd som olympisk ranking). Syntax: rank (expr sortorder vid exp prefilter) rank (distinkt expr sortorder prefilter). för expr för rapport auto Exempel: Rang Mängd) ----------------- (upp: 1, 2, 3, 4, 8230 ..) Returnerar löpande medelvärde för rad (inklusive den aktuella raden) för en uppsättning värden Syntax: löpande medelvärde (numericexpr vid exp-förfilter) löpande medelvärde (distinkt numericexpr-förfilter). för expr för rapport auto Exempel: löpande antal Kvantitet) ------------ (op: Kvantitet Flyttande medelvärde 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Löpräkning: Returnerar löpande räkning för rad (inklusive den nuvarande raden) för en uppsättning värden. Syntax: löpnummer (numericexpr vid exp-förfilter) körräkning (distinkt numericexpr prefilter). expr för rapport auto Exempel: löpnummer (Quantity) ------- (upp: 1, 2, 3, 8230) Returnerar en kördifferens för rad, beräknad som skillnaden mellan värdet för den aktuella raden och föregående rad (inklusive den aktuella raden) för en uppsättning värden. Syntax: skillnad (numericexpr vid exp prefilter) kördifferens (distinkt numericexpr prefilter). expr för rapport auto Exempel: kördifferens (antal) - (op: null, 146420, -249,544, 8230 ..) Returnerar löpande maximalt med rad (inklusive den aktuella raden) för en uppsättning värden. Syntax: kör-max (numericex pr vid förförfilter) körhastighet (distinkt numericexpr förfilter). för expr för rapport auto Exempel: kör-max (Quantity) --------- (upp: 198676, 345096) Returnerar löpminimum för rad (inklusive nuvarande rad) för en uppsättning värden. Syntax: körminimum (numericexpr vid exp prefilter) körminimum (distinkt numericexpr prefilter). för expr för rapport auto Exempel: körminimum (antal) --------- (upp: 198676, 198676, 95552,) Returnerar en löpande total för rad (inklusive den aktuella raden) för en uppsättning värden. Syntax: körtall (numericalxpr vid exp prefilter) körtall (distinkta numericexpr prefilter). för expr för rapport auto Exempel: körtall (Mängd) ----------- (op: 198676, 5437728230.) Returnerar standardavvikelsen för valda dataobjekt. Nyckelordet distinkt är tillgängligt för bakåtkompatibilitet av uttryck som används i tidigare versioner av produkten. Syntax: standardavvikelse (distinkt expr auto) standardavvikelse (distinkt expr för all expr) standardavvikelse (distinkt expr för rapport) Exempel: standardavvikelse (kvantitet) ------ (op: 50.628, 69.098 8230) standardavvikelse (antal för alla produkttyp) -------- (op: 50.628, 69.098, 8230) standardavvikelse (antal för vilken produkttyp) ------ (upp: 50.628, 69.098 8230) standardavvikelse (Kvantitet för rapport) -------------------- (upp: 59.70671027) Rapport: Standardavvikelse Standardavvikande pop: Beräknar befolkningsstandardavvikelsen och återvänder kvadratroten av befolkningsvarianansen. Nyckelordet distinkt är tillgängligt för bakåtkompatibilitet av uttryck som används i tidigare versioner av produkten. Syntax: standardavvikelse-pop (distinkt expr auto) standardavvikelse-pop (distinkt expr för alla expr) standardavvikelse-pop (distinkt expr för rapport) Exempel: standardavvikelse-pop (kvantitet) ---- --- (upp: 50.62240898, 69.09035128) standardavvikelse-pop (antal för alla produkttyper) (antal: 50.62240898, 69.09035128) standard - avvikelse-pop (Antal för rapport) --- (upp: 59.70601702,) Totalt: Returnerar det totala värdet av valda dataobjekt. Nyckelordet distinkt är tillgängligt för bakåtkompatibilitet av uttryck som används i tidigare versioner av produkten. Syntax: totalt (separat expr auto) totalt (distinkt expr för alla expr) totalt (separat expr för rapport) Exempel: totalt (antal) --------------- (upp: 198,676, 345.096) Totalt (Antal för alla Produkttyp) ----- (upp: 198,676, 345,096) Totalt (Antal för rapport) --------------- (upp: 2215354) Rapport: Totalvariation: Returnerar variansen för valda dataobjekt. Nyckelordet distinkt är tillgängligt för bakåtkompatibilitet av uttryck som används i tidigare versioner av produkten. Exempel: varians (Mängd) ----- (upp: 2563.244, 4774.5438230) varians (antal för alla Produkttyp) -------- (op: 2563.244, 4774.5438230) varians (Kvantitet för vilken produkttyp) ------- (upp: 2563.244, 4774.5438230) varians (Kvantitet för rapport) ------- --------------- (op: 3,564.89125097) Returnerar befolkningsvariationen av en uppsättning siffror efter borttagning av nollorna i den här uppsättningen. Syntax: varians pop (distinkt expr auto) varians-pop (distinkt expr för alla expr) varians-pop (distinkt expr för rapport) Exempel: varians-pop (Quantity) ------- (upp: 2,562,6282905, 4,773.47663957) varians pop (Antal för alla Produkttyp) ----------- (upp: 2,562,6282905, 4,773,47663957) varians pop (antal för vilken produkttyp) -------- (op : 2,562,6282905, 4,773,47663957) varians-pop (kvantitet för rapport) ------ (op: 3,564.80846781) glidande medelvärde (distinkt numericexpr. Numericexpr prefilter). för expr för rapport auto Exempel: moving-average (Antal, 2) (op: Kvantitet Flyttande medelvärde 198,676 198,676 345,096 271,886 95,552 220,324 96,246 95,889 Flytt-Totalt: Returnerar värdet genom att lägga till värdena till föregående baserat på numericexp Syntax: förflyttnings-summa (numericexpr. numericexpr vid exp-förfilter) förflyttnings-total (distinkt numericexpr. numericexpr prefilter). expr för rapport auto Exempel: Total-rörelse (Mängd, 3) Utgång: Mängd Flyttande medelvärde 198,676 198,676 345,096 543,772 95,552 639,324 96,246 536,894 Procentandel: Returnerar procenten av det totala värdet för valda dataobjekt. Används endast i relationella datakällor. Syntax: procentandel (numericexpr vid exp prefilter) procentandel (distinkt numericexpr prefilter). Expr för rapport auto Exempel: procentandel Op: 16, 12, 10.) Procent: Returnerar ett värde på en skala av hundra som anger procenten av en fördelning som är lika med eller under de valda data poster. Syntax: percentil (numericexpr vid exp-förfilter) percentil (distinkt numericexpr-förfilter). för expr för rapport auto Exempel: percentil (Quantity) -------- (op: 100, 95, 90) Kvantitet: Returnerar värdet för ett värde för ett intervall som du anger. Den returnerar heltal för att representera valfritt antal rader, till exempel 1 (högsta) till 100 (lägsta). Syntax: quantile (numericexpr, numericexpr vid exp prefilter) quantile (distinkt numericexpr, numericexpr prefilter). för expr för rapport auto Exempel: quantile (Quantity, 5) --- (op: 1, 2, 3, 4, 5) Quartile: Returnerar värdet av ett värde representerat som heltal från 1 (högsta) till 4 ), i förhållande till en grupp av värden. Syntax: kvartil (numericexpr vid exp prefilter) kvartil (distinkt numericexpr prefilter). för expr för rapport auto Exempel: kvartil (Mängd) ---------- (op: 1, 2, 3, 4) Returnerar rankvärdet för valda dataobjekt. Om två eller flera rader knyts, finns det ett gap i sekvensen av rankade värden (även känd som olympisk ranking). Syntax: rank (expr sortorder vid exp prefilter) rank (distinkt expr sortorder prefilter). för expr för rapport auto Exempel: Rang Mängd) ----------------- (upp: 1, 2, 3, 4, 8230 ..) Returnerar löpande medelvärde för rad (inklusive den aktuella raden) för en uppsättning värden Syntax: löpande medelvärde (numericexpr vid exp-förfilter) löpande medelvärde (distinkt numericexpr-förfilter). för expr för rapport auto Exempel: löpande antal Kvantitet) ------------ (op: Kvantitet Flyttande medel 198.676 198.676 345.096 271.886 95.552 213.108 96.246 183.892 Löpningsantal: Returnerar löpande räkning för rad (inklusive den nuvarande raden) för en uppsättning värden. Syntax: löpnummer (numericexpr vid exp-förfilter) körräkning (distinkt numericexpr prefilter). expr för rapport auto Exempel: löpnummer (Quantity) ------- (upp: 1, 2, 3, 8230) Returnerar en kördifferens för rad, beräknad som skillnaden mellan värdet för den aktuella raden och föregående rad (inklusive den aktuella raden) för en uppsättning värden. Syntax: skillnad (numericexpr vid exp prefilter) kördifferens (distinkt numericexpr prefilter). expr för rapport auto Exempel: kördifferens (antal) - (op: null, 146420, -249,544, 8230 ..) Returnerar löpande maximalt med rad (inklusive den aktuella raden) för en uppsättning värden. Syntax: kör-max (numericex pr vid förförfilter) körhastighet (distinkt numericexpr förfilter). för expr för rapport auto Exempel: kör-max (Quantity) --------- (upp: 198676, 345096) Returnerar löpminimum för rad (inklusive nuvarande rad) för en uppsättning värden. Syntax: körminimum (numericexpr vid exp prefilter) körminimum (distinkt numericexpr prefilter). för expr för rapport auto Exempel: körminimum (antal) --------- (upp: 198676, 198676, 95552,) Returnerar en löpande total för rad (inklusive den aktuella raden) för en uppsättning värden. Syntax: körtall (numericalxpr vid exp prefilter) körtall (distinkta numericexpr prefilter). för expr för rapport auto Exempel: körtall (Mängd) ----------- (op: 198676, 5437728230.) Returnerar standardavvikelsen för valda dataobjekt. Nyckelordet distinkt är tillgängligt för bakåtkompatibilitet av uttryck som används i tidigare versioner av produkten. Syntax: standardavvikelse (distinkt expr auto) standardavvikelse (distinkt expr för all expr) standardavvikelse (distinkt expr för rapport) Exempel: standardavvikelse (kvantitet) ------ (op: 50.628, 69.098 8230) standardavvikelse (antal för alla produkttyp) -------- (op: 50.628, 69.098, 8230) standardavvikelse (antal för vilken produkttyp) ------ (upp: 50.628, 69.098 8230) standardavvikelse (Kvantitet för rapport) -------------------- (upp: 59.70671027) Rapport: Standardavvikelse Standardavvikande pop: Beräknar befolkningsstandardavvikelsen och återvänder kvadratroten av befolkningsvarianansen. Nyckelordet distinkt är tillgängligt för bakåtkompatibilitet av uttryck som används i tidigare versioner av produkten. Syntax: standardavvikelse-pop (distinkt expr auto) standardavvikelse-pop (distinkt expr för alla expr) standardavvikelse-pop (distinkt expr för rapport) Exempel: standardavvikelse-pop (kvantitet) ---- --- (upp: 50.62240898, 69.09035128) standardavvikelse-pop (antal för alla produkttyper) (antal: 50.62240898, 69.09035128) standard - avvikelse-pop (Antal för rapport) --- (upp: 59.70601702,) Totalt: Returnerar det totala värdet av valda dataobjekt. Nyckelordet distinkt är tillgängligt för bakåtkompatibilitet av uttryck som används i tidigare versioner av produkten. Syntax: totalt (separat expr auto) totalt (distinkt expr för alla expr) totalt (separat expr för rapport) Exempel: totalt (antal) --------------- (upp: 198,676, 345.096) Totalt (Antal för alla Produkttyp) ----- (upp: 198,676, 345,096) Totalt (Antal för rapport) --------------- (upp: 2215354) Rapport: Totalvariation: Returnerar variansen för valda dataobjekt. Nyckelordet distinkt är tillgängligt för bakåtkompatibilitet av uttryck som används i tidigare versioner av produkten. Exempel: varians (Mängd) ----- (upp: 2563.244, 4774.5438230) varians (antal för alla Produkttyp) -------- (op: 2563.244, 4774.5438230) varians (Kvantitet för vilken produkttyp) ------- (upp: 2563.244, 4774.5438230) varians (Kvantitet för rapport) ------- --------------- (op: 3,564.89125097) Returnerar befolkningsvariationen av en uppsättning siffror efter borttagning av nollorna i den här uppsättningen. Syntax: varians pop (distinkt expr auto) varians-pop (distinkt expr för alla expr) varians-pop (distinkt expr för rapport) Exempel: varians-pop (Quantity) ------- (upp: 2,562,6282905, 4,773.47663957) varians pop (Antal för alla Produkttyp) ----------- (upp: 2,562,6282905, 4,773,47663957) varians pop (antal för vilken produkttyp) -------- (op : 2,562,6282905, 4,773,47663957) varians-pop (antal för rapport) ------ (op: 3,564.80846781) för expr för rapport auto Exempel: Flyttande medelvärde (Antal, 2) (Op: Mängd Flyttande medelvärde 198,676 198,676 345,096 271,886 95,552 220,324 96,246 95,889 Moving-Total. Returnerar värdet genom att lägga till värdena till det föregående baserat på numericexp-syntaxen: rörlig total (numericalxpr. Numericexpr vid exp-prefilter) rörelsetalj (distans numericexpr. Numericexpr prefilter). Expr för rapport auto Exempel: Flytt-summa (Antal, 3) Utgång: Antal Flyttande medelvärde 198 676 198 676 345 096 543 772 95 552 639 324 96 , 246 536 894 Procentandel: Returnerar procenten av det totala värdet för valda dataobjekt. Används endast i relationella datakällor. Syntax: procentsats (numericalxpr vid exp prefilter) procentandel (distinkt numericexpr prefilter). expr för rapport auto Exempel: procentandel (Mängd) - (upp: 16, 12, 10.) Procent: Returnerar ett värde på en skala av hundra som anger procenten av en fördelning som är lika med eller under den valda dataposter. Syntax: percentil (numericexpr vid exp-förfilter) percentil (distinkt numericexpr-förfilter). för expr för rapport auto Exempel: percentil (Quantity) -------- (op: 100, 95, 90) Kvantitet: Returnerar värdet för ett värde för ett intervall som du anger. Den returnerar heltal för att representera valfritt antal rader, till exempel 1 (högsta) till 100 (lägsta). Syntax: quantile (numericexpr, numericexpr vid exp prefilter) quantile (distinkt numericexpr, numericexpr prefilter). för expr för rapport auto Exempel: quantile (Quantity, 5) --- (op: 1, 2, 3, 4, 5) Quartile: Returnerar värdet av ett värde representerat som heltal från 1 (högsta) till 4 ), i förhållande till en grupp av värden. Syntax: kvartil (numericexpr vid exp prefilter) kvartil (distinkt numericexpr prefilter). för expr för rapport auto Exempel: kvartil (Mängd) ---------- (op: 1, 2, 3, 4) Returnerar rankvärdet för valda dataobjekt. Om två eller flera rader knyts, finns det ett gap i sekvensen av rankade värden (även känd som olympisk ranking). Syntax: rank (expr sortorder vid exp prefilter) rank (distinkt expr sortorder prefilter). för expr för rapport auto Exempel: Rang Mängd) ----------------- (upp: 1, 2, 3, 4, 8230 ..) Returnerar löpande medelvärde för rad (inklusive den aktuella raden) för en uppsättning värden Syntax: löpande medelvärde (numericexpr vid exp-förfilter) löpande medelvärde (distinkt numericexpr-förfilter). för expr för rapport auto Exempel: löpande antal Kvantitet) ------------ (op: Kvantitet Flyttande medelvärde 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Löpningsantal: Returnerar löpande räkning för rad (inklusive den nuvarande raden) för en uppsättning värden. Syntax: löpnummer (numericexpr vid exp-förfilter) körräkning (distinkt numericexpr prefilter). expr för rapport auto Exempel: löpnummer (Quantity) ------- (upp: 1, 2, 3, 8230) Returnerar en kördifferens för rad, beräknad som skillnaden mellan värdet för den aktuella raden och föregående rad (inklusive den aktuella raden) för en uppsättning värden. Syntax: skillnad (numericexpr vid exp prefilter) kördifferens (distinkt numericexpr prefilter). expr för rapport auto Exempel: kördifferens (antal) - (op: null, 146420, -249,544, 8230 ..) Returnerar löpande maximalt med rad (inklusive den aktuella raden) för en uppsättning värden. Syntax: kör-max (numericex pr vid förförfilter) körhastighet (distinkt numericexpr förfilter). för expr för rapport auto Exempel: kör-max (Quantity) --------- (upp: 198676, 345096) Returnerar löpminimum för rad (inklusive nuvarande rad) för en uppsättning värden. Syntax: körminimum (numericexpr vid exp prefilter) körminimum (distinkt numericexpr prefilter). för expr för rapport auto Exempel: körminimum (antal) --------- (upp: 198676, 198676, 95552,) Returnerar en löpande total för rad (inklusive den aktuella raden) för en uppsättning värden. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) moving-total ( distinct numericexpr. numericexpr prefilter ) . for expr for report auto Example: moving-total(Quantity,3) Output:Quantity Moving average 198,676 198,676 345,096 543,772 95,552 639,324 96,246 536,894 Percentage: Returns the percent of the total value for selected data items. Only used in relational Data sources. Syntax: percentage ( numericexpr at exp prefilter ) percentage ( distinct numericexpr prefilter ) . for expr for report auto Example: percentage (Quantity) - (op: 16, 12, 10 . ) Percentile: Returns a value, on a scale of one hundred, that indicates the percent of a distribution that is equal to or below the selected data items. Syntax: percentile ( numericexpr at exp prefilter ) percentile ( distinct numericexpr prefilter ) . for expr for report auto Example: percentile (Quantity) -------- (op: 100, 95, 90) Quantile: Returns the rank of a value for a range that you specify. It returns integers to represent any range of ranks, such as 1 (highest) to 100 (lowest). Syntax: quantile ( numericexpr, numericexpr at exp prefilter ) quantile ( distinct numericexpr, numericexpr prefilter ) . for expr for report auto Example: quantile (Quantity, 5) --- (op: 1, 2, 3, 4, 5) Quartile: Returns the rank of a value, represented as integers from 1 (highest) to 4 (lowest), relative to a group of values. Syntax: quartile ( numericexpr at exp prefilter ) quartile ( distinct numericexpr prefilter ) . for expr for report auto Example: quartile (Quantity) ---------- (op: 1, 2, 3, 4) Returns the rank value of selected data items. If two or more rows tie, then there is a gap in the sequence of ranked values (also known as Olympic ranking). Syntax: rank ( expr sortorder at exp prefilter ) rank ( distinct expr sortorder prefilter ) . for expr for report auto Example: rank Quantity) ----------------- ( op: 1, 2, 3, 4, 8230..) Returns the running average by row (including the current row) for a set of values Syntax: running-average ( numericexpr at exp prefilter ) running-average ( distinct numericexpr prefilter ) . for expr for report auto Example: running-average Quantity) ------------ (op: Quantity Moving average 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Running-Count: Returns the running count by row (including the current row) for a set of values. Syntax: running-count ( numericexpr at exp prefilter ) running-count ( distinct numericexpr prefilter ) . for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Returns a running difference by row, calculated as the difference between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericex pr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) for expr for report auto Example: moving-total(Quantity,3) Output:Quantity Moving average 198,676 198,676 345,096 543,772 95,552 639,324 96,246 536,894 Percentage: Returns the percent of the total value for selected data items. Only used in relational Data sources. Syntax: percentage ( numericexpr at exp prefilter ) percentage ( distinct numericexpr prefilter ) . for expr for report auto Example: percentage (Quantity) - (op: 16, 12, 10 . ) Percentile: Returns a value, on a scale of one hundred, that indicates the percent of a distribution that is equal to or below the selected data items. Syntax: percentile ( numericexpr at exp prefilter ) percentile ( distinct numericexpr prefilter ) . for expr for report auto Example: percentile (Quantity) -------- (op: 100, 95, 90) Quantile: Returns the rank of a value for a range that you specify. It returns integers to represent any range of ranks, such as 1 (highest) to 100 (lowest). Syntax: quantile ( numericexpr, numericexpr at exp prefilter ) quantile ( distinct numericexpr, numericexpr prefilter ) . for expr for report auto Example: quantile (Quantity, 5) --- (op: 1, 2, 3, 4, 5) Quartile: Returns the rank of a value, represented as integers from 1 (highest) to 4 (lowest), relative to a group of values. Syntax: quartile ( numericexpr at exp prefilter ) quartile ( distinct numericexpr prefilter ) . for expr for report auto Example: quartile (Quantity) ---------- (op: 1, 2, 3, 4) Returns the rank value of selected data items. If two or more rows tie, then there is a gap in the sequence of ranked values (also known as Olympic ranking). Syntax: rank ( expr sortorder at exp prefilter ) rank ( distinct expr sortorder prefilter ) . for expr for report auto Example: rank Quantity) ----------------- ( op: 1, 2, 3, 4, 8230..) Returns the running average by row (including the current row) for a set of values Syntax: running-average ( numericexpr at exp prefilter ) running-average ( distinct numericexpr prefilter ) . for expr for report auto Example: running-average Quantity) ------------ (op: Quantity Moving average 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Running-Count: Returns the running count by row (including the current row) for a set of values. Syntax: running-count ( numericexpr at exp prefilter ) running-count ( distinct numericexpr prefilter ) . for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Returns a running difference by row, calculated as the difference between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericex pr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) percentage ( distinct numericexpr prefilter ) . for expr for report auto Example: percentage (Quantity) - (op: 16, 12, 10 . ) Percentile: Returns a value, on a scale of one hundred, that indicates the percent of a distribution that is equal to or below the selected data items. Syntax: percentile ( numericexpr at exp prefilter ) percentile ( distinct numericexpr prefilter ) . for expr for report auto Example: percentile (Quantity) -------- (op: 100, 95, 90) Quantile: Returns the rank of a value for a range that you specify. It returns integers to represent any range of ranks, such as 1 (highest) to 100 (lowest). Syntax: quantile ( numericexpr, numericexpr at exp prefilter ) quantile ( distinct numericexpr, numericexpr prefilter ) . for expr for report auto Example: quantile (Quantity, 5) --- (op: 1, 2, 3, 4, 5) Quartile: Returns the rank of a value, represented as integers from 1 (highest) to 4 (lowest), relative to a group of values. Syntax: quartile ( numericexpr at exp prefilter ) quartile ( distinct numericexpr prefilter ) . for expr for report auto Example: quartile (Quantity) ---------- (op: 1, 2, 3, 4) Returns the rank value of selected data items. If two or more rows tie, then there is a gap in the sequence of ranked values (also known as Olympic ranking). Syntax: rank ( expr sortorder at exp prefilter ) rank ( distinct expr sortorder prefilter ) . for expr for report auto Example: rank Quantity) ----------------- ( op: 1, 2, 3, 4, 8230..) Returns the running average by row (including the current row) for a set of values Syntax: running-average ( numericexpr at exp prefilter ) running-average ( distinct numericexpr prefilter ) . for expr for report auto Example: running-average Quantity) ------------ (op: Quantity Moving average 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Running-Count: Returns the running count by row (including the current row) for a set of values. Syntax: running-count ( numericexpr at exp prefilter ) running-count ( distinct numericexpr prefilter ) . for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Returns a running difference by row, calculated as the difference between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericex pr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) for expr for report auto Example: percentage (Quantity) - (op: 16, 12, 10 . ) Report: Percentage. Percentile: Returns a value, on a scale of one hundred, that indicates the percent of a distribution that is equal to or below the selected data items. Syntax: percentile ( numericexpr at exp prefilter ) percentile ( distinct numericexpr prefilter ) . for expr for report auto Example: percentile (Quantity) -------- (op: 100, 95, 90) Quantile: Returns the rank of a value for a range that you specify. It returns integers to represent any range of ranks, such as 1 (highest) to 100 (lowest). Syntax: quantile ( numericexpr, numericexpr at exp prefilter ) quantile ( distinct numericexpr, numericexpr prefilter ) . for expr for report auto Example: quantile (Quantity, 5) --- (op: 1, 2, 3, 4, 5) Quartile: Returns the rank of a value, represented as integers from 1 (highest) to 4 (lowest), relative to a group of values. Syntax: quartile ( numericexpr at exp prefilter ) quartile ( distinct numericexpr prefilter ) . for expr for report auto Example: quartile (Quantity) ---------- (op: 1, 2, 3, 4) Returns the rank value of selected data items. If two or more rows tie, then there is a gap in the sequence of ranked values (also known as Olympic ranking). Syntax: rank ( expr sortorder at exp prefilter ) rank ( distinct expr sortorder prefilter ) . for expr for report auto Example: rank Quantity) ----------------- ( op: 1, 2, 3, 4, 8230..) Returns the running average by row (including the current row) for a set of values Syntax: running-average ( numericexpr at exp prefilter ) running-average ( distinct numericexpr prefilter ) . for expr for report auto Example: running-average Quantity) ------------ (op: Quantity Moving average 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Running-Count: Returns the running count by row (including the current row) for a set of values. Syntax: running-count ( numericexpr at exp prefilter ) running-count ( distinct numericexpr prefilter ) . for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Returns a running difference by row, calculated as the difference between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericex pr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) percentile ( distinct numericexpr prefilter ) . for expr for report auto Example: percentile (Quantity) -------- (op: 100, 95, 90) Quantile: Returns the rank of a value for a range that you specify. It returns integers to represent any range of ranks, such as 1 (highest) to 100 (lowest). Syntax: quantile ( numericexpr, numericexpr at exp prefilter ) quantile ( distinct numericexpr, numericexpr prefilter ) . for expr for report auto Example: quantile (Quantity, 5) --- (op: 1, 2, 3, 4, 5) Quartile: Returns the rank of a value, represented as integers from 1 (highest) to 4 (lowest), relative to a group of values. Syntax: quartile ( numericexpr at exp prefilter ) quartile ( distinct numericexpr prefilter ) . for expr for report auto Example: quartile (Quantity) ---------- (op: 1, 2, 3, 4) Returns the rank value of selected data items. If two or more rows tie, then there is a gap in the sequence of ranked values (also known as Olympic ranking). Syntax: rank ( expr sortorder at exp prefilter ) rank ( distinct expr sortorder prefilter ) . for expr for report auto Example: rank Quantity) ----------------- ( op: 1, 2, 3, 4, 8230..) Returns the running average by row (including the current row) for a set of values Syntax: running-average ( numericexpr at exp prefilter ) running-average ( distinct numericexpr prefilter ) . for expr for report auto Example: running-average Quantity) ------------ (op: Quantity Moving average 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Running-Count: Returns the running count by row (including the current row) for a set of values. Syntax: running-count ( numericexpr at exp prefilter ) running-count ( distinct numericexpr prefilter ) . for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Returns a running difference by row, calculated as the difference between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericex pr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) for expr for report auto Example: percentile (Quantity) -------- (op: 100, 95, 90) Quantile: Returns the rank of a value for a range that you specify. It returns integers to represent any range of ranks, such as 1 (highest) to 100 (lowest). Syntax: quantile ( numericexpr, numericexpr at exp prefilter ) quantile ( distinct numericexpr, numericexpr prefilter ) . for expr for report auto Example: quantile (Quantity, 5) --- (op: 1, 2, 3, 4, 5) Quartile: Returns the rank of a value, represented as integers from 1 (highest) to 4 (lowest), relative to a group of values. Syntax: quartile ( numericexpr at exp prefilter ) quartile ( distinct numericexpr prefilter ) . for expr for report auto Example: quartile (Quantity) ---------- (op: 1, 2, 3, 4) Returns the rank value of selected data items. If two or more rows tie, then there is a gap in the sequence of ranked values (also known as Olympic ranking). Syntax: rank ( expr sortorder at exp prefilter ) rank ( distinct expr sortorder prefilter ) . for expr for report auto Example: rank Quantity) ----------------- ( op: 1, 2, 3, 4, 8230..) Returns the running average by row (including the current row) for a set of values Syntax: running-average ( numericexpr at exp prefilter ) running-average ( distinct numericexpr prefilter ) . for expr for report auto Example: running-average Quantity) ------------ (op: Quantity Moving average 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Running-Count: Returns the running count by row (including the current row) for a set of values. Syntax: running-count ( numericexpr at exp prefilter ) running-count ( distinct numericexpr prefilter ) . for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Returns a running difference by row, calculated as the difference between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericex pr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) quantile ( distinct numericexpr, numericexpr prefilter ) . for expr for report auto Example: quantile (Quantity, 5) --- (op: 1, 2, 3, 4, 5) Quartile: Returns the rank of a value, represented as integers from 1 (highest) to 4 (lowest), relative to a group of values. Syntax: quartile ( numericexpr at exp prefilter ) quartile ( distinct numericexpr prefilter ) . for expr for report auto Example: quartile (Quantity) ---------- (op: 1, 2, 3, 4) Returns the rank value of selected data items. If two or more rows tie, then there is a gap in the sequence of ranked values (also known as Olympic ranking). Syntax: rank ( expr sortorder at exp prefilter ) rank ( distinct expr sortorder prefilter ) . for expr for report auto Example: rank Quantity) ----------------- ( op: 1, 2, 3, 4, 8230..) Returns the running average by row (including the current row) for a set of values Syntax: running-average ( numericexpr at exp prefilter ) running-average ( distinct numericexpr prefilter ) . for expr for report auto Example: running-average Quantity) ------------ (op: Quantity Moving average 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Running-Count: Returns the running count by row (including the current row) for a set of values. Syntax: running-count ( numericexpr at exp prefilter ) running-count ( distinct numericexpr prefilter ) . for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Returns a running difference by row, calculated as the difference between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericex pr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) for expr for report auto Example: quantile (Quantity, 5) --- (op: 1, 2, 3, 4, 5) Quartile: Returns the rank of a value, represented as integers from 1 (highest) to 4 (lowest), relative to a group of values. Syntax: quartile ( numericexpr at exp prefilter ) quartile ( distinct numericexpr prefilter ) . for expr for report auto Example: quartile (Quantity) ---------- (op: 1, 2, 3, 4) Returns the rank value of selected data items. If two or more rows tie, then there is a gap in the sequence of ranked values (also known as Olympic ranking). Syntax: rank ( expr sortorder at exp prefilter ) rank ( distinct expr sortorder prefilter ) . for expr for report auto Example: rank Quantity) ----------------- ( op: 1, 2, 3, 4, 8230..) Returns the running average by row (including the current row) for a set of values Syntax: running-average ( numericexpr at exp prefilter ) running-average ( distinct numericexpr prefilter ) . for expr for report auto Example: running-average Quantity) ------------ (op: Quantity Moving average 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Running-Count: Returns the running count by row (including the current row) for a set of values. Syntax: running-count ( numericexpr at exp prefilter ) running-count ( distinct numericexpr prefilter ) . for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Returns a running difference by row, calculated as the difference between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericex pr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) quartile ( distinct numericexpr prefilter ) . for expr for report auto Example: quartile (Quantity) ---------- (op: 1, 2, 3, 4) Returns the rank value of selected data items. If two or more rows tie, then there is a gap in the sequence of ranked values (also known as Olympic ranking). Syntax: rank ( expr sortorder at exp prefilter ) rank ( distinct expr sortorder prefilter ) . for expr for report auto Example: rank Quantity) ----------------- ( op: 1, 2, 3, 4, 8230..) Returns the running average by row (including the current row) for a set of values Syntax: running-average ( numericexpr at exp prefilter ) running-average ( distinct numericexpr prefilter ) . for expr for report auto Example: running-average Quantity) ------------ (op: Quantity Moving average 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Running-Count: Returns the running count by row (including the current row) for a set of values. Syntax: running-count ( numericexpr at exp prefilter ) running-count ( distinct numericexpr prefilter ) . for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Returns a running difference by row, calculated as the difference between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericex pr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) for expr for report auto Example: quartile (Quantity) ---------- (op: 1, 2, 3, 4) Rank: Returns the rank value of selected data items. If two or more rows tie, then there is a gap in the sequence of ranked values (also known as Olympic ranking). Syntax: rank ( expr sortorder at exp prefilter ) rank ( distinct expr sortorder prefilter ) . for expr for report auto Example: rank Quantity) ----------------- ( op: 1, 2, 3, 4, 8230..) Returns the running average by row (including the current row) for a set of values Syntax: running-average ( numericexpr at exp prefilter ) running-average ( distinct numericexpr prefilter ) . for expr for report auto Example: running-average Quantity) ------------ (op: Quantity Moving average 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Running-Count: Returns the running count by row (including the current row) for a set of values. Syntax: running-count ( numericexpr at exp prefilter ) running-count ( distinct numericexpr prefilter ) . for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Returns a running difference by row, calculated as the difference between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericex pr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) rank ( distinct expr sortorder prefilter ) . for expr for report auto Example: rank Quantity) ----------------- ( op: 1, 2, 3, 4, 8230..) Returns the running average by row (including the current row) for a set of values Syntax: running-average ( numericexpr at exp prefilter ) running-average ( distinct numericexpr prefilter ) . for expr for report auto Example: running-average Quantity) ------------ (op: Quantity Moving average 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Running-Count: Returns the running count by row (including the current row) for a set of values. Syntax: running-count ( numericexpr at exp prefilter ) running-count ( distinct numericexpr prefilter ) . for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Returns a running difference by row, calculated as the difference between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericex pr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) for expr for report auto Example: rank Quantity) ----------------- ( op: 1, 2, 3, 4, 8230..) Running-Average: Returns the running average by row (including the current row) for a set of values Syntax: running-average ( numericexpr at exp prefilter ) running-average ( distinct numericexpr prefilter ) . for expr for report auto Example: running-average Quantity) ------------ (op: Quantity Moving average 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Running-Count: Returns the running count by row (including the current row) for a set of values. Syntax: running-count ( numericexpr at exp prefilter ) running-count ( distinct numericexpr prefilter ) . for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Returns a running difference by row, calculated as the difference between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericex pr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) running-average ( distinct numericexpr prefilter ) . for expr for report auto Example: running-average Quantity) ------------ (op: Quantity Moving average 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Running-Count: Returns the running count by row (including the current row) for a set of values. Syntax: running-count ( numericexpr at exp prefilter ) running-count ( distinct numericexpr prefilter ) . for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Returns a running difference by row, calculated as the difference between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericex pr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) for expr for report auto Example: running-average Quantity) ------------ (op: Quantity Moving average 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Running-Count: Returns the running count by row (including the current row) for a set of values. Syntax: running-count ( numericexpr at exp prefilter ) running-count ( distinct numericexpr prefilter ) . for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Returns a running difference by row, calculated as the differenc e between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericexpr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) running-count ( distinct numericexpr prefilter ) . for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Returns a running difference by row, calculated as the difference between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericexpr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Running-Difference: Returns a running difference by row, calculated as the difference between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericexpr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericexpr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Running-Maximum: Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericexpr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Report: Running Running-Minimum: Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Running-Total: Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Standard-Deviation: Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total . Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance . Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Variance-pop: Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781)Pinned topic Moving-total moving-average functions giving weird numbers Unanswered question This question has not been answered yet. Darren Gruber sa: Jag har en ganska enkel kryssningsrapport som beräknar ett enkelt antal kriterier för korsning av månad och år. (se skärmdump). Räkningen fungerar bra, men det rörliga summan (räkningen 3) ger upphov till några konstiga siffror. Här är hur hjälpfilen beskriver den rörliga totalsfunktionen. lttable border1gtlttbodygtlttrgtlttdgt lttdgtlttdgt lttdgtlttrgtlttbodygtlttablegt Men som du kan se i mitt bifogade skärmdump, väntar det inte ens tills det har 3 månader innan det ger ett resultat, vilket också är fel. Observera också att om räkningen är tom är rörelsetalmen tom, även om det kan ha tidigare räknerader att arbeta med. Ive försökte ersätta rörelsetal med rörligt medelvärde och jag får liknande resultat, om än mindre antal. Vilken hjälp som helst skulle uppskattas. Jag kan vara mer specifik om rapporten om mer information behövs. Uppdaterad 2012-01-19T07: 58: 22Z vid 2012-01-19T07: 58: 22Z av SystemAdmin Någon som är villig att dela sina tankar snälla gör det. Tack Resultaten i din skärmdump ser rätt ut. I Grp 1 har du värdena januari februari mars april maj 198 177 158,5 0 0 Förflyttningstalen är: januari: (januari värde) (inga föregående värden) 198 0 198 februari: (februari värde) (januari värde) (inget föregående värden) 177 198 0 375 mars: (marsvärde) (februarivärde) (januarivärde) 158,5 177 198 533,5 april: (aprilvärde) (marsvärde) (februarivärde) 0 158,5 177 335,5 maj: (majsvärde) värde) (marsvärde) 0 0 158,5 158,5 Så verkar rörelsen totalt att göra exakt vad det ska göra. Om du vill sluta använda rörelsetal när mätningen blir noll kan du överväga att använda ytterligare logik i ditt uttryck. Du kan tänka dig: Om du använder ett dimensionspaket, är det bättre att använda medlemssammanfattningar istället för de vanliga sammanfattningsfunktionerna som är avsedda för relationella frågor. Uttrycket för den rörliga totalen med sammanfattningar av medlemmar skulle se ut: Uppdaterad 2014-03-25T08: 36: 22Z vid 2014-03-25T08: 36: 22Z av iron-man Resultaten i din skärmdump ser rätt ut. I Grp 1 har du värdena januari februari mars april maj 198 177 158,5 0 0 Förflyttningstalen är: januari: (januari värde) (inga föregående värden) 198 0 198 februari: (februari värde) (januari värde) (inget föregående värden) 177 198 0 375 mars: (marsvärde) (februarivärde) (januarivärde) 158,5 177 198 533,5 april: (aprilvärde) (marsvärde) (februarivärde) 0 158,5 177 335,5 maj: (majsvärde) värde) (marsvärde) 0 0 158,5 158,5 Så verkar rörelsen totalt att göra exakt vad det ska göra. Om du vill sluta använda rörelsetal när mätningen blir noll kan du överväga att använda ytterligare logik i ditt uttryck. Du kanske tänker på: ltpre classjava dw data-editor-langjava data-pbcklangjava dirltrgtIF (Totalt antal anställda 0) THEN (0) ELSE (flytt-summa (Totalt antal anställda, 3 för år, grupp)) ltpregt På en sidotal, om du är genom att använda en dimensionspaket skulle det vara bättre att använda medlemssammanfattningar istället för de vanliga sammanfattningsfunktionerna som är avsedda för relationella frågor. Uttrycket för den rörliga totalsumman med medlemssammanfattningar skulle se ut: Det är en klassisk data-editor-data-editor-langjava data-pbcklangjava dirltrgtaggregate (Totalt antal anställda inom uppsättningen lastPeriods (3, currentMember (Cube. Time Dimension. Time Hierarchy)))) ingångar. Jag kommer att ge detta ett försök. Thanks Phil WGood morningafternoon TM1 gurus, Im currently working on a sales project that requires a moving average rule. Dimensions are quotcustomerquot. quotLocationquot. quotMeasuresquot. quotYearquot such as 2011,2012,2013 and quotdayquot with the 365 days of the year that rolls up to the corresponding month as parent (Jul, Aug, Sep. ) and the month to the top parent quotTotal Yearquot (see example below) Im trying to show the sales daily average value based on a 10 day moving period, for example see below This means that May-15 shows the avrg of the values from May-15 to May-02 and so on. So my question is: How do I work out the avrg backwards based on the previous 10 days that have a value against, if there is no value then exclude it. What I mean by a value is something in the cube cell even if its a zero. Any help, hints andor tips will be greatly appreciated. winsonlee Regular Participant Posts: 180 Joined: Thu Jul 01, 2010 3:06 am OLAP Product: Cognos Express Version: 9.5 Excel Version: 2007 Location: Melbourne, Australia Not too sure if it can be done via rules as you are looking to skip days which is 0. I tried using TI process to do it and it is achievable. Create a view of all days at N element level and years and set quotSkip Zero Blank valuesquot. temp1 temp2 temp2 temp3 temp3 temp4 temp4 temp5 temp5 temp6 temp6 temp7 temp7 temp8 temp8 temp9 temp9 temp10 temp10 Value CELLPUTN((temp1 temp2 temp3 temp4 temp5 temp6 temp7 temp8 temp9 temp10)10, testing4,YearX, MonthX, Avrg JOB Val) I can think of 1 way to do it via rules but its not exactly pretty. Put an attribute against every day called quotprior dayquot and populate it with you know what. Create an extra measure called quotCheckquot or something like that. 91Check93N: If (91Intake Value93ltgt0,1,0) 91Avrg JOB Val93N: ( DB(Cube, dim1, dim2. Day, Intake Value) DB(Cube, dim1, dim2, Attrs(Day, Day, Prior Day),Intake Value) DB(Cube, dim1, dim2, Attrs(Day, Attrs(Day, Day, Prior Day),Prior Day),Intake Value). and so on 10 times ) Same as above but for the quotCheckquot measure. You could also do it via a dimix that may look cleaner in the rule but is dependent on elements not moving. Presuming that at least 1 of your 10 days will have a value you should probably cheat and just feed the whole measure. A nicer way to do it possibly would be taking the values out to an intermediate cube and using consols to do the averages and then bring them back in. LORR wrote: What I mean by a value is something in the cube cell even if its a zero. I presume that you mean that zero is a significant value but that there may be days for which there is no value. The accepted way to implement this in TM1 is to use UNDEFVALS (publib. boulder. ibminfocenterctm1v9r5m0index. jsptopic2Fcom. ibm. swg. im. cognos. tm1ref.9.5.2.doc2Ftm1refid7852undefvals. html ) in the rule. However be aware that once you put it in the rule it will have a permanent effect on the cube and taking it out will not reverse that effect. Furthermore I do not believe that it is possible any more (9.5.2 and above) in a rule to distinguish between a cell that has a zero in it and a cell with the special undefined value. I would be delighted to be proved wrong in this. In previous versions they used to compare greater than zero but not any more. All things considered if you are importing the data with TI it would probably be safer and more understandable to have an extra measure (e. g. quotHas Dataquot) that you populate with 1 for every sales value that you populate. Of course if the values are entered by users in the cube viewer or in Contributor you cannot do this. winsonlee Regular Participant Posts: 180 Joined: Thu Jul 01, 2010 3:06 am OLAP Product: Cognos Express Version: 9.5 Excel Version: 2007 Location: Melbourne, Australia Looks like a good idea. but i would like to confirm about the rules. using the rules given wouldnt it mean May-14 (May-07 May-08 May-09 May-10 May-11 May-14 ) 6 May-05 0 May-06 0 May-07 187,989 May-08 203,375 May-09 236,468 May-10 106,078 May-11 426,669 may-12 0 May-13 0 May-14 296,722 declanr wrote: I can think of 1 way to do it via rules but its not exactly pretty. Put an attribute against every day called quotprior dayquot and populate it with you know what. Create an extra measure called quotCheckquot or something like that. 91Check93N: If (91Intake Value93ltgt0,1,0) 91Avrg JOB Val93N: ( DB(Cube, dim1, dim2. Day, Intake Value) DB(Cube, dim1, dim2, Attrs(Day, Day, Prior Day),Intake Value) DB(Cube, dim1, dim2, Attrs(Day, Attrs(Day, Day, Prior Day),Prior Day),Intake Value). and so on 10 times ) Same as above but for the quotCheckquot measure. You could also do it via a dimix that may look cleaner in the rule but is dependent on elements not moving. Presuming that at least 1 of your 10 days will have a value you should probably cheat and just feed the whole measure. A nicer way to do it possibly would be taking the values out to an intermediate cube and using consols to do the averages and then bring them back in. winsonlee Regular Participant Posts: 180 Joined: Thu Jul 01, 2010 3:06 am OLAP Product: Cognos Express Version: 9.5 Excel Version: 2007 Location: Melbourne, Australia using the rules define by declanr, I guess it is possbile if the year and the month date dimension is combine into one dimension and use attribute to define prior day according to the existance of the data but this will require alot of work to maintain the attribute as well. winsonlee Regular Participant Posts: 180 Joined: Thu Jul 01, 2010 3:06 am OLAP Product: Cognos Express Version: 9.5 Excel Version: 2007 Location: Melbourne, Australia that looks like a resonable solution that doesnt require much work to maintain it. but would like to further emphasize that using dimix, the sequence of element created in the dimension is important. eg if Jun is created subsequently all the days follow by Jul and all the days, therefore it will comes to a time where the prior period of Jul-01 will be Jul. So it is advisable to create all parent element first then only the days element so that all the days is in correct orders. winsonlee wrote: Looks like a good idea. but i would like to confirm about the rules. using the rules given wouldnt it mean May-14 (May-07 May-08 May-09 May-10 May-11 May-14 ) 6 ah yes I see I mis-read the question. I now take it as the OP always wants to average 10 days worth of data but it will only ever be the last 10 days that had values in them. If that is the case I would still have the quotPriorquot attribute but populate it by a rule (I say this is what I would do. in reality I would use a TI but if a rule was essential). The rule would be something like: Prior PeriodS: If ( DB(Cube, Dim1, Dim2, Dimnm(Day, Dimix(Day, Day)-1), AVG Job Val)ltgt0, Dimnm(Day, Dimix(Day, Day)-1) , If ( DB(Cube, Dim1, Dim2, Dimnm(Day, Dimix(Day, Day)-2), AVG Job Val)ltgt0, Dimnm(Day, Dimix(Day, Day)-2) , If ( DB(Cube, Dim1, Dim2, Dimnm(Day, Dimix(Day, Day)-3), AVG Job Val)ltgt0, Dimnm(Day, Dimix(Day, Day)-3) , . and so on and so forth as many times as you think would be necessary to encompass however many blanks are likely to be in a row. If the Dim1, Dim2 etc all require a different take on this you would possibly need to do it againt a custom control cube rather than the actual attributes cube. Like I say this is starting to look a very messy method and I would probably try to avoid it myself. but I think it would work. Of course if you did this the rule from my previous comment would just have a divide by 10 instead of the variable denominator.
No comments:
Post a Comment