@gooddata/fixtures - npm Package Compare versions

Comparing version 1.9.0 to 1.9.1

assets/fixtures/TigerLayout/tiger_goodsales_declarative_layout.json

@@ -78,4 +78,175 @@ {
         "title": "Parent metric"
+      },
+      {
+        "content": {
+            "format": "#,##0",
+            "maql": "SELECT MAX({fact/fact.f_timeline.timelinedate}) BY ALL IN ALL OTHER DIMENSIONS EXCEPT {attribute/dt_timeline_timestamp.day}"
+        },
+        "description": "",
+        "id": "6b1411d5-e253-418e-8fd3-137a9f56ea92",
+        "title": "_Timeline [EOP]"
+    },
+    {
+        "content": {
+            "format": "#,##0.00",
+            "maql": "SELECT COUNT({attribute/f_opportunity.id}, {label/f_opportunitysnapshot.id}) WHERE {fact/fact.f_opportunitysnapshot.oppsnapshotdate} = {metric/c5ee7836-126c-41aa-bd69-1873d379a065}"
+        },
+        "description": "",
+        "id": "768414e1-4bbe-4f01-b125-0cdc6305dc76",
+        "title": "# of Opportunities"
+    },
+    {
+        "content": {
+            "format": "$#,##0.00",
+            "maql": "SELECT SUM({fact/f_opportunitysnapshot.f_amount}) WHERE {fact/fact.f_opportunitysnapshot.oppsnapshotdate} = {metric/c5ee7836-126c-41aa-bd69-1873d379a065}"
+        },
+        "description": "",
+        "id": "87a053b0-3947-49f3-b0c5-de53fd01f050",
+        "title": "Amount"
+    },
+    {
+        "content": {
+            "format": "#,##0.00",
+            "maql": "SELECT {metric/768414e1-4bbe-4f01-b125-0cdc6305dc76} WHERE {label/f_stage.status_id} = \"Won\""
+        },
+        "description": "",
+        "id": "8d33a0b1-cfdf-4074-a26a-4c4357774967",
+        "title": "# Of Opportunities Won"
+    },
+    {
+        "content": {
+            "format": "#,##0.0%",
+            "maql": "SELECT {metric/8d33a0b1-cfdf-4074-a26a-4c4357774967} / {metric/768414e1-4bbe-4f01-b125-0cdc6305dc76}"
+        },
+        "description": "",
+        "id": "973a14c4-acb1-45fb-ba52-5d96fa02f7ba",
+        "title": "Win Rate"
+    },
+    {
+        "content": {
+            "format": "#,##0.0%",
+            "maql": "SELECT AVG({fact/f_opportunitysnapshot.f_probability}) WHERE {fact/fact.f_opportunitysnapshot.oppsnapshotdate} = {metric/c5ee7836-126c-41aa-bd69-1873d379a065}"
+        },
+        "description": "",
+        "id": "b4e3e3c7-ead3-4d69-8be4-23bcfe5ff7aa",
+        "title": "Probability"
+    },
+    {
+        "content": {
+            "format": "#,##0.00",
+            "maql": "SELECT MAX({fact/fact.f_opportunitysnapshot.oppsnapshotdate}) BY ALL IN ALL OTHER DIMENSIONS EXCEPT {attribute/dt_snapshotdate_timestamp.day} WHERE {fact/fact.f_opportunitysnapshot.oppsnapshotdate} <= {metric/6b1411d5-e253-418e-8fd3-137a9f56ea92}"
+        },
+        "description": "",
+        "id": "c5ee7836-126c-41aa-bd69-1873d379a065",
+        "title": "_Snapshot [EOP]"
+    },
+    {
+      "content": {
+        "format": "$#,##0.00",
+        "maql": "SELECT {metric/87a053b0-3947-49f3-b0c5-de53fd01f050}\n  WHERE {label/f_stage.status_id} = \"Won\""
+      },
+      "description": "",
+      "id": "e519fa2a-86c3-4e32-8313-0c03062348j3",
+      "title": "Won"
+    },
+    {
+      "title": "# of Lost Opps.",
+      "id": "of_lost_opps.",
+      "description": "",
+      "content": {
+        "format": "#,##0",
+        "maql": "SELECT {metric/768414e1-4bbe-4f01-b125-0cdc6305dc76}\n  WHERE {label/f_stage.status_id} = \"Lost\""
       }
-    ],
+    },
+    {
+      "title": "# of Won Opps.",
+      "id": "of_won_opps.",
+      "description": "",
+      "content": {
+        "format": "#,##0",
+        "maql": "select {metric/768414e1-4bbe-4f01-b125-0cdc6305dc76} where {label/f_stage.status_id} = \"Won\""
+      }
+    },
+    {
+      "title": "_Snapshot [BOP]",
+      "id": "snapshot_bop",
+      "description": "",
+      "content": {
+        "format": "#,##0",
+        "maql": "SELECT MIN({fact/fact.f_opportunitysnapshot.oppsnapshotdate})\n  BY ALL IN ALL OTHER DIMENSIONS EXCEPT {attribute/dt_snapshotdate_timestamp.day}\n  WHERE {fact/fact.f_opportunitysnapshot.oppsnapshotdate} >= {metric/timeline_bop}"
+      }
+    },
+    {
+      "title": "_Close [EOP]",
+      "id": "close_eop",
+      "description": "",
+      "content": {
+        "format": "#,##0.00",
+        "maql": "SELECT MAX({fact/fact.f_opportunitysnapshot.oppclosedate}) where {fact/fact.f_opportunitysnapshot.oppsnapshotdate} = {metric/c5ee7836-126c-41aa-bd69-1873d379a065}"
+      }
+    },
+    {
+      "title": "_Opp. First Snapshot",
+      "id": "opp._first_snapshot",
+      "description": "",
+      "content": {
+        "format": "#,##0.00",
+        "maql": "select min({fact/fact.f_opportunitysnapshot.oppsnapshotdate}) by all in all other dimensions except {attribute/f_opportunity.id}"
+      }
+    },
+    {
+      "title": "Amount [BOP]",
+      "id": "amount_bop",
+      "description": "",
+      "content": {
+        "format": "$#,##0.00",
+        "maql": "SELECT SUM({fact/f_opportunitysnapshot.f_amount}) WHERE {fact/fact.f_opportunitysnapshot.oppsnapshotdate} = {metric/snapshot_bop}"
+      }
+    },
+    {
+      "title": "Avg. Amount",
+      "id": "avg._amount",
+      "description": "",
+      "content": {
+        "format": "$#,##0.00",
+        "maql": "SELECT AVG({fact/f_opportunitysnapshot.f_amount})\n  WHERE {fact/fact.f_opportunitysnapshot.oppsnapshotdate} = {metric/c5ee7836-126c-41aa-bd69-1873d379a065}"
+      }
+    },
+    {
+      "title": "Best Case",
+      "id": "best_case",
+      "description": "",
+      "content": {
+        "format": "#,##0",
+        "maql": "SELECT SUM(\n    SELECT {metric/87a053b0-3947-49f3-b0c5-de53fd01f050}\n      WHERE {label/f_stage.status_id} = \"Open\")"
+      }
+    },
+    {
+      "title": "_Timeline [BOP]",
+      "id": "timeline_bop",
+      "description": "",
+      "content": {
+        "format": "#,##0",
+        "maql": "SELECT MIN({fact/fact.f_timeline.timelinedate})\n  BY ALL IN ALL OTHER DIMENSIONS EXCEPT {attribute/dt_timeline_timestamp.day}"
+      }
+    },
+    {
+      "title": "# of Activities",
+      "id": "of_activities",
+      "description": "",
+      "content": {
+        "format": "#,##0",
+        "maql": "SELECT COUNT({label/f_activity.id})"
+      }
+    },
+    {
+      "content": {
+        "format": "#,##0.00",
+        "maql": "SELECT MAX({fact/fact.f_opportunitysnapshot.oppclosedate})\n  WHERE {fact/fact.f_opportunitysnapshot.oppsnapshotdate} = {metric/snapshot_bop}"
+      },
+      "description": "",
+      "id": "close_bop",
+      "title": "_Close [BOP]"
+    }
+  ],
     "visualizationObjects": [
@@ -148,2 +319,6 @@ {
           {
+            "defaultView": {
+              "id": "label.f_account.account.name",
+              "type": "label"
+            },
             "description": "Account",
@@ -154,11 +329,11 @@ "id": "attr.f_account.account",
                 "description": "",
-                "id": "label.f_account.account.accountid",
-                "sourceColumn": "ls__id__nm_id",
+                "id": "label.f_account.account.name",
+                "sourceColumn": "ls__id__nm_name",
                 "tags": [
                   "Account"
                 ],
-                "title": "Account"
+                "title": "Name"
               }
             ],
-            "sourceColumn": "ls__id__nm_name",
+            "sourceColumn": "ls__id__nm_id",
             "tags": [
@@ -203,2 +378,6 @@ "Account"
           {
+            "defaultView": {
+              "id": "label.f_activity.subject",
+              "type": "label"
+            },
             "description": "Activity",
@@ -209,11 +388,11 @@ "id": "attr.f_activity.activity",
                 "description": "",
-                "id": "label.f_activity.activity",
-                "sourceColumn": "ls__id__nm_id",
+                "id": "label.f_activity.subject",
+                "sourceColumn": "ls__id__nm_subject",
                 "tags": [
                   "Activity"
                 ],
-                "title": "Activity"
+                "title": "Subject"
               }
             ],
-            "sourceColumn": "ls__id__nm_subject",
+            "sourceColumn": "ls__id__nm_id",
             "tags": [
@@ -359,2 +538,6 @@ "Activity"
           {
+            "defaultView": {
+              "id": "label.f_opportunity.opportunity.name",
+              "type": "label"
+            },
             "description": "Opportunity",
@@ -365,8 +548,8 @@ "id": "attr.f_opportunity.opportunity",
                 "description": "",
-                "id": "label.f_opportunity.opportunity.opportunity",
-                "sourceColumn": "ls__id__nm_id",
+                "id": "label.f_opportunity.opportunity.name",
+                "sourceColumn": "ls__id__nm_name",
                 "tags": [
                   "Opportunity"
                 ],
-                "title": "Opportunity"
+                "title": "Opportunity Name"
               },
@@ -380,7 +563,7 @@ {
                 ],
-                "valueType": "HYPERLINK",
-                "title": "SFDC URL"
+                "title": "SFDC URL",
+                "valueType": "HYPERLINK"
               }
             ],
-            "sourceColumn": "ls__id__nm_name",
+            "sourceColumn": "ls__id__nm_id",
             "tags": [
@@ -616,2 +799,6 @@ "Opportunity"
           {
+            "defaultView": {
+              "id": "label.f_owner.salesrep.ownername",
+              "type": "label"
+            },
             "description": "",
@@ -622,11 +809,11 @@ "id": "attr.f_owner.salesrep",
                 "description": "",
-                "id": "label.f_owner.salesrep.owner",
-                "sourceColumn": "ls__id__nm_id",
+                "id": "label.f_owner.salesrep.ownername",
+                "sourceColumn": "ls__id__nm_name",
                 "tags": [
                   "owner"
                 ],
-                "title": "Owner"
+                "title": "Owner Name"
               }
             ],
-            "sourceColumn": "ls__id__nm_name",
+            "sourceColumn": "ls__id__nm_id",
             "tags": [
@@ -691,2 +878,6 @@ "owner"
           {
+            "defaultView": {
+              "id": "label.f_product.product.name",
+              "type": "label"
+            },
             "description": "Product",
@@ -697,11 +888,11 @@ "id": "attr.f_product.product",
                 "description": "",
-                "id": "label.f_product.product.productid",
-                "sourceColumn": "ls__id__nm_id",
+                "id": "label.f_product.product.name",
+                "sourceColumn": "ls__id__nm_name",
                 "tags": [
                   "product"
                 ],
-                "title": "Product"
+                "title": "Product Name"
               }
             ],
-            "sourceColumn": "ls__id__nm_name",
+            "sourceColumn": "ls__id__nm_id",
             "tags": [
@@ -708,0 +899,0 @@ "product"

fixture_tiger.js

@@ -14,2 +14,5 @@ // (C) 2022 GoodData Corporation
 function getTigerBackendSdk(token, host, backend) {
+    if (!host.startsWith('http')) {
+        host = `https://${host}`; // eslint-disable-line no-param-reassign
+    }
     if (backend === 'TIGER') {
@@ -16,0 +19,0 @@ const axios = newAxios(host, {});

package.json

 {
   "name": "@gooddata/fixtures",
-  "version": "1.9.0",
+  "version": "1.9.1",
   "description": "",
@@ -5,0 +5,0 @@ "main": "index.js",

No alert changes

Improved metrics

Total package byte prevSize

232222315

increased by49.17%

Number of package files

120

increased by11.11%

Lines of code

8408

increased by9.46%

No dependency changes