Dashboard trying to load question not displayed

Bug reports
1
  • Chrome Version 95.0.4638.54 (Build officiel) (x86_64)
  • macOS 11.6
  • BigQuery database
  • Metabase v0.41.1
  • hosting-env : unknown
  • application-database-details :
    name : PostgreSQL
    version : 12.7

I have a really weird issue, so I don't have reproducible steps :confused: but only suppositions about The context in which the bug happened :

  1. having a dashboard D1 in a public folder P1
  2. having a question Q1 in private folder P2
  3. Adding question Q1 to dashboard D1
  4. moving Q1 to public folder P1
  5. removing question Q1 from dashboard D1
  6. Moving Q1 into a private folder P2

step 6 results in error "Sorry you don't have permission to see that" when trying to open dashboard D1 for every person not having access to the private folder P2.

The logs indicates that opening D1 still make a request to question Q1 whereas the question has been removed from the dashboard .

image
image1734×260 80.6 KB

seem to be related to Dashboard causes permission error, when "Click Behavior" linking to dashboard/question without access · Issue #15368 · metabase/metabase · GitHub even if in my case there is no "click behavior"

2

Hi @lgeran
I'm not entirely sure what is going on, but can you include the metadata output by going to the URL /api/dashboard/123, where 123 is your dashboard ID.

3

Hi @flamber. thanks for your answer. I hope this will help :slight_smile: in two parts

{"description":"Similar to the reporting - detailed sessions. This dashboard will be used by the CSM team and will usually be presented by Cyril every Monday morning. ","archived":false,"collection_position":3,"ordered_cards":[{"sizeX":18,"series":[],"collection_authority_level":null,"card":{"query_average_duration":null},"updated_at":"2021-10-28T13:31:04.305062Z","col":0,"id":129,"parameter_mappings":[],"card_id":null,"visualization_settings":{"virtual_card":{"name":null,"display":"text","visualization_settings":{},"dataset_query":{},"archived":false},"text":"# Overview","dashcard.background":true,"text.align_horizontal":"left","text.align_vertical":"middle"},"dashboard_id":18,"created_at":"2021-09-09T15:42:30.40805Z","sizeY":1,"row":0},{"sizeX":18,"series":[],"collection_authority_level":null,"card":{"query_average_duration":null},"updated_at":"2021-10-28T13:31:04.310713Z","col":0,"id":132,"parameter_mappings":[],"card_id":null,"visualization_settings":{"virtual_card":{"name":null,"display":"text","visualization_settings":{},"dataset_query":{},"archived":false},"text":"## Weekly evolution (Over the last 7 rolling days)","text.align_horizontal":"center","text.align_vertical":"middle"},"dashboard_id":18,"created_at":"2021-09-09T15:42:30.463255Z","sizeY":1,"row":29},{"sizeX":18,"series":[],"collection_authority_level":null,"card":{"description":"Count of sessions per status","archived":false,"collection_position":null,"table_id":316,"result_metadata":[{"semantic_type":"type/Category","coercion_strategy":null,"name":"funnel","field_ref":["field",630455,null],"effective_type":"type/Text","id":630455,"display_name":"Funnel","fingerprint":{"global":{"distinct-count":7,"nil%":0.0},"type":{"type/Text":{"percent-json":0.0,"percent-url":0.0,"percent-email":0.0,"percent-state":0.0,"average-length":14.3944}}},"base_type":"type/Text"},{"name":"sum","display_name":"Sum of NbSessionID","base_type":"type/Integer","effective_type":"type/Integer","semantic_type":null,"field_ref":["aggregation",0],"fingerprint":{"global":{"distinct-count":7,"nil%":0.0},"type":{"type/Number":{"min":3290.0,"q1":30717.75,"q3":158703.0,"max":276943.0,"sd":99458.42117593424,"avg":94683.14285714286}}}}],"database_id":3,"enable_embedding":false,"collection_id":16,"query_type":"query","name":"Number of Sessions per Status","query_average_duration":857,"creator_id":2,"moderation_reviews":[],"updated_at":"2021-10-28T13:48:27.230499Z","made_public_by_id":null,"embedding_params":null,"cache_ttl":null,"dataset_query":{"type":"query","query":{"source-table":316,"aggregation":[["sum",["field",630429,null]]],"breakout":[["field",630455,null]]},"database":3},"id":64,"display":"pie","visualization_settings":{"card.title":"Sessions status repartition","pie.colors":{"1 - noSolution":"#EF8C8C","2 - autonomous":"#88BF4D","3 - alternativeChannel":"#F2A86F","4 - externalCall":"#F9D45C","5 - ivrHeadCall":"#A989C5","6 - orientedCall":"#7172AD","7 - multi":"#98D9D9"},"pie.show_legend":true,"pie.slice_threshold":0},"created_at":"2021-09-09T08:36:11.796006Z","public_uuid":null},"updated_at":"2021-10-28T13:31:04.316144Z","col":0,"id":133,"parameter_mappings":[{"parameter_id":"999fbf09","card_id":64,"target":["dimension",["field",630439,null]]},{"parameter_id":"a7e9a6b9","card_id":64,"target":["dimension",["field",630477,null]]},{"parameter_id":"8044bc2f","card_id":64,"target":["dimension",["field",630449,null]]}],"card_id":64,"visualization_settings":{"card.title":"Sessions volume per status","pie.colors":{"1 - noSolution":"#EF8C8C","2 - autonomous":"#88BF4D","3 - alternativeChannel":"#F2A86F","4 - externalCall":"#F9D45C","5 - ivrHeadCall":"#A989C5","6 - orientedCall":"#7172AD","7 - multi":"#98D9D9"},"pie.show_legend":true,"pie.slice_threshold":0,"card.description":"Depending on the end user action, each session are qualified with a dedicated status. click on the pie chart to get more details","click_behavior":{"type":"link","linkType":"url","linkTemplate":"https://dialonce-tools.document360.io/docs/cest-quoi-le-session-status#introduction"}},"dashboard_id":18,"created_at":"2021-09-09T15:42:30.464483Z","sizeY":6,"row":16},{"sizeX":6,"series":[],"collection_authority_level":null,"card":{"description":"Sessions or visits generated by end users when they consult DialOnce viewer.\n\nAs every sessions are related to a uniq ID, this volume equal the total amount of unique ID session. \n\nA session ID expired 30 minutes after the last actions recorded","archived":false,"collection_position":null,"table_id":null,"result_metadata":[{"name":"sum","display_name":"sum","base_type":"type/Integer","effective_type":"type/Integer","field_ref":["field","sum",{"base-type":"type/Integer"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":1,"nil%":0.0},"type":{"type/Number":{"min":662782.0,"q1":662782.0,"q3":662782.0,"max":662782.0,"sd":null,"avg":662782.0}}}}],"database_id":3,"enable_embedding":false,"collection_id":16,"query_type":"native","name":"Number of Sessions","query_average_duration":787,"creator_id":2,"moderation_reviews":[],"updated_at":"2021-10-28T13:48:27.184598Z","made_public_by_id":null,"embedding_params":null,"cache_ttl":null,"dataset_query":{"type":"native","native":{"query":"SELECT sum(production_stitch.V2V3_sessions_v1.NbSessionID) AS sum\nFROM production_stitch.V2V3_sessions_v1\nWHERE {{date}}\nAND {{companyName}}\nAND {{industry}}\nAND {{scenarioName}}\nAND {{integrationType}}","template-tags":{"date":{"id":"1ccba93b-8c4d-63d0-b882-90e8680af611","name":"date","display-name":"Date","type":"dimension","dimension":["field",630439,null],"widget-type":"date/all-options"},"companyName":{"id":"1551922d-9d50-c0d9-4552-985c5e4cec9b","name":"companyName","display-name":"Companyname","type":"dimension","dimension":["field",630449,null],"widget-type":"category"},"industry":{"id":"2539cf80-27b0-11bd-26f0-a6dd08e879cc","name":"industry","display-name":"Industry","type":"dimension","dimension":["field",630477,null],"widget-type":"category"},"scenarioName":{"id":"c585a49c-6747-74b2-1af0-4975c44662d6","name":"scenarioName","display-name":"Scenarioname","type":"dimension","dimension":["field",630435,null],"widget-type":"category"},"integrationType":{"id":"4bb2bd01-21e4-5abc-2add-9e176226d8d0","name":"integrationType","display-name":"Integrationtype","type":"dimension","dimension":["field",630759,null],"widget-type":"category"}}},"database":3},"id":65,"display":"scalar","visualization_settings":{"scalar.switch_positive_negative":false,"card.title":"Sessions volume"},"created_at":"2021-09-09T09:34:12.967431Z","public_uuid":null},"updated_at":"2021-10-28T13:31:04.321565Z","col":0,"id":134,"parameter_mappings":[{"parameter_id":"8044bc2f","card_id":65,"target":["dimension",["template-tag","companyName"]]},{"parameter_id":"999fbf09","card_id":65,"target":["dimension",["template-tag","date"]]},{"parameter_id":"a7e9a6b9","card_id":65,"target":["dimension",["template-tag","industry"]]}],"card_id":65,"visualization_settings":{"scalar.switch_positive_negative":false,"card.title":"Sessions volume"},"dashboard_id":18,"created_at":"2021-09-09T15:42:30.467473Z","sizeY":3,"row":1},{"sizeX":18,"series":[],"collection_authority_level":null,"card":{"query_average_duration":null},"updated_at":"2021-10-28T13:31:04.326463Z","col":0,"id":136,"parameter_mappings":[],"card_id":null,"visualization_settings":{"virtual_card":{"name":null,"display":"text","visualization_settings":{},"dataset_query":{},"archived":false},"text":"## Monthly evolution (Over the last 30 rolling days)","text.align_horizontal":"center","text.align_vertical":"middle"},"dashboard_id":18,"created_at":"2021-09-09T15:42:30.471811Z","sizeY":1,"row":44},{"sizeX":9,"series":[],"collection_authority_level":null,"card":{"description":"This pie chart offer you the chance to identify what is the impact of each integration type on the session volume\n\n","archived":false,"collection_position":null,"table_id":null,"result_metadata":[{"name":"integrationType","display_name":"integrationType","base_type":"type/Text","effective_type":"type/Text","field_ref":["field","integrationType",{"base-type":"type/Text"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":3,"nil%":0.0},"type":{"type/Text":{"percent-json":0.0,"percent-url":0.0,"percent-email":0.0,"percent-state":0.0,"average-length":17.0}}}},{"name":"sum","display_name":"sum","base_type":"type/Integer","effective_type":"type/Integer","field_ref":["field","sum",{"base-type":"type/Integer"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":3,"nil%":0.0},"type":{"type/Number":{"min":8365.0,"q1":38777.75,"q3":425804.75,"max":524401.0,"sd":269762.749875392,"avg":220927.33333333334}}}}],"database_id":3,"enable_embedding":false,"collection_id":16,"query_type":"native","name":"Number of Sessions per Integration type ","query_average_duration":818,"creator_id":10,"moderation_reviews":[],"updated_at":"2021-10-28T13:48:26.804615Z","made_public_by_id":null,"embedding_params":null,"cache_ttl":null,"dataset_query":{"type":"native","native":{"query":"SELECT \n integrationType,\n sum(NbSessionID) AS sum\nFROM production_stitch.V2V3_sessions_v1\nWHERE {{date}}\nAND {{companyName}}\nAND {{Industry}}\nAND {{integrationType}}\nGROUP BY integrationType\nORDER BY integrationType ASC","template-tags":{"Industry":{"id":"f41f18c8-3d09-5bb9-cfa3-4f639d95c90b","name":"Industry","display-name":"Industry","type":"dimension","dimension":["field",630477,null],"widget-type":"category"},"companyName":{"id":"b0a6ded7-85f4-9cc5-c92a-7089de16a9c3","name":"companyName","display-name":"Companyname","type":"dimension","dimension":["field",630449,null],"widget-type":"category"},"date":{"id":"91e48066-d5c1-c846-bf6e-1104ae9e7be5","name":"date","display-name":"Date","type":"dimension","dimension":["field",630439,null],"widget-type":"date/all-options"},"integrationType":{"id":"3aeaab45-ef35-c2f3-0556-c02380b1249b","name":"integrationType","display-name":"Integrationtype","type":"dimension","dimension":["field",630759,null],"widget-type":"category"}}},"database":3},"id":73,"display":"pie","visualization_settings":{"pie.show_legend_perecent":true,"pie.show_legend":true,"card.title":"Sessions volume per integration type","pie.colors":{"Click to Hub Hyperlink":"#98D9D9","Click to Hub Widget":"#F2A86F","SMS to Hub":"#A989C5","null":"#7172AD"},"pie.slice_threshold":0,"card.description":"Identify what is the impact of each integration type on the session volume","click_behavior":{"targetId":21,"parameterMapping":{"db7a773a":{"source":{"type":"parameter","id":"a7e9a6b9","name":"Industry"},"target":{"type":"parameter","id":"db7a773a"},"id":"db7a773a"},"99c3068b":{"source":{"type":"parameter","id":"8044bc2f","name":"companyName"},"target":{"type":"parameter","id":"99c3068b"},"id":"99c3068b"},"710c691":{"source":{"type":"parameter","id":"999fbf09","name":"Date Filter"},"target":{"type":"parameter","id":"710c691"},"id":"710c691"}},"linkType":"dashboard","type":"link"}},"created_at":"2021-09-09T16:03:16.830772Z","public_uuid":null},"updated_at":"2021-10-28T13:31:04.331309Z","col":0,"id":139,"parameter_mappings":[{"parameter_id":"999fbf09","card_id":73,"target":["dimension",["template-tag","date"]]},{"parameter_id":"a7e9a6b9","card_id":73,"target":["dimension",["template-tag","Industry"]]},{"parameter_id":"8044bc2f","card_id":73,"target":["dimension",["template-tag","companyName"]]}],"card_id":73,"visualization_settings":{"pie.show_legend_perecent":true,"pie.show_legend":true,"card.title":"Sessions volume per integration type","pie.colors":{"Click to Hub Hyperlink":"#98D9D9","Click to Hub Widget":"#F2A86F","SMS to Hub":"#A989C5","null":"#7172AD"},"pie.slice_threshold":0,"card.description":"Identify what is the impact of each integration type on the session volume ®","click_behavior":{"targetId":21,"parameterMapping":{"db7a773a":{"source":{"type":"parameter","id":"a7e9a6b9","name":"Industry"},"target":{"type":"parameter","id":"db7a773a"},"id":"db7a773a"},"99c3068b":{"source":{"type":"parameter","id":"8044bc2f","name":"companyName"},"target":{"type":"parameter","id":"99c3068b"},"id":"99c3068b"},"710c691":{"source":{"type":"parameter","id":"999fbf09","name":"Date Filter"},"target":{"type":"parameter","id":"710c691"},"id":"710c691"}},"linkType":"dashboard","type":"link"}},"dashboard_id":18,"created_at":"2021-09-09T16:22:23.825927Z","sizeY":5,"row":4},{"sizeX":6,"series":[],"collection_authority_level":null,"card":{"description":"Count of avoided calls","archived":false,"collection_position":null,"table_id":null,"result_metadata":[{"name":"sum","display_name":"sum","base_type":"type/Integer","effective_type":"type/Integer","field_ref":["field","sum",{"base-type":"type/Integer"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":1,"nil%":0.0},"type":{"type/Number":{"min":253569.0,"q1":253569.0,"q3":253569.0,"max":253569.0,"sd":null,"avg":253569.0}}}}],"database_id":3,"enable_embedding":false,"collection_id":16,"query_type":"native","name":"Number of Avoided calls","query_average_duration":782,"creator_id":2,"moderation_reviews":[],"updated_at":"2021-10-28T13:48:27.121744Z","made_public_by_id":null,"embedding_params":null,"cache_ttl":null,"dataset_query":{"database":3,"native":{"template-tags":{"date":{"id":"2edd98b8-0ec5-0c79-c233-4184e2993428","name":"date","display-name":"Date","type":"dimension","dimension":["field",630439,null],"widget-type":"date/all-options"},"industry":{"id":"807fe055-1af6-cfa7-a1a0-aef5cef9ca3e","name":"industry","display-name":"Industry","type":"dimension","dimension":["field",630477,null],"widget-type":"category"},"scenarioName":{"id":"93a0e339-a4b7-5159-1ac6-6df316c1fe1a","name":"scenarioName","display-name":"Scenarioname","type":"dimension","dimension":["field",630435,null],"widget-type":"category"},"companyName":{"id":"aa33da23-6286-5030-0de5-475d17488ecc","name":"companyName","display-name":"Companyname","type":"dimension","dimension":["field",630449,null],"widget-type":"category"},"integrationType":{"id":"71f460d6-20ee-03c7-215c-dc8aaf55e85e","name":"integrationType","display-name":"Integrationtype","type":"dimension","dimension":["field",630759,null],"widget-type":"category"}},"query":"SELECT sum(production_stitch.V2V3_sessions_v1.NbSessionID) AS sum\nFROM production_stitch.V2V3_sessions_v1\n\nWHERE (production_stitch.V2V3_sessions_v1.avoidedCall = TRUE\nAND {{date}}\nAND {{industry}}\nAND {{companyName}}\nAND {{scenarioName}}\nAND {{integrationType}}\n)"},"type":"native"},"id":76,"display":"scalar","visualization_settings":{"scalar.field":"sum","card.title":"Avoided calls volume ","card.description":"How many sessions routed the end user to a solution where the ressource is not an human and internal to our client. click to see more information","click_behavior":{"type":"link","linkType":"url","linkTemplate":"https://dialonce-tools.document360.io/docs/cest-quoi-le-session-status#comment-est-calculé-le-taux-dappel-évité-"}},"created_at":"2021-09-09T17:06:21.915401Z","public_uuid":null},"updated_at":"2021-10-28T13:31:04.336855Z","col":12,"id":141,"parameter_mappings":[{"parameter_id":"999fbf09","card_id":76,"target":["dimension",["template-tag","date"]]},{"parameter_id":"a7e9a6b9","card_id":76,"target":["dimension",["template-tag","industry"]]},{"parameter_id":"8044bc2f","card_id":76,"target":["dimension",["template-tag","companyName"]]}],"card_id":76,"visualization_settings":{"scalar.field":"sum","card.title":"Avoided calls volume ","card.description":"How many sessions routed the end user to a solution where the ressource is not an human and internal to our client. click to see more information","click_behavior":{"type":"link","linkType":"url","linkTemplate":"https://dialonce-tools.document360.io/docs/cest-quoi-le-session-status#comment-est-calculé-le-taux-dappel-évité-"}},"dashboard_id":18,"created_at":"2021-09-09T17:07:17.97174Z","sizeY":3,"row":1},{"sizeX":18,"series":[],"collection_authority_level":null,"card":{"description":"Comparison of count of sessions over last week with the week before","archived":false,"collection_position":null,"table_id":null,"result_metadata":[{"name":"ScenarioName","display_name":"ScenarioName","base_type":"type/Text","effective_type":"type/Text","field_ref":["field","ScenarioName",{"base-type":"type/Text"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":50,"nil%":0.0},"type":{"type/Text":{"percent-json":0.0,"percent-url":0.0,"percent-email":0.0,"percent-state":0.0,"average-length":29.38}}}},{"name":"Version","display_name":"Version","base_type":"type/Text","effective_type":"type/Text","field_ref":["field","Version",{"base-type":"type/Text"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":2,"nil%":0.0},"type":{"type/Text":{"percent-json":0.0,"percent-url":0.0,"percent-email":0.0,"percent-state":0.0,"average-length":2.0}}}},{"name":"sum","display_name":"sum","base_type":"type/Integer","effective_type":"type/Integer","field_ref":["field","sum",{"base-type":"type/Integer"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":45,"nil%":0.0},"type":{"type/Number":{"min":0.0,"q1":46.0,"q3":1810.0,"max":56988.0,"sd":8507.955612752774,"avg":3099.84}}}},{"name":"sum_2","display_name":"sum_2","base_type":"type/Integer","effective_type":"type/Integer","field_ref":["field","sum_2",{"base-type":"type/Integer"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":46,"nil%":0.0},"type":{"type/Number":{"min":0.0,"q1":31.0,"q3":1997.0,"max":48675.0,"sd":7042.064397458971,"avg":2478.96}}}},{"name":"sum_3","display_name":"sum_3","base_type":"type/Float","effective_type":"type/Float","field_ref":["field","sum_3",{"base-type":"type/Float"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":46,"nil%":0.1},"type":{"type/Number":{"min":-1.0,"q1":-0.2663163716814159,"q3":0.006370139018241061,"max":1.0253549695740365,"sd":0.38166399837860815,"avg":-0.09647582137215817}}}}],"database_id":3,"enable_embedding":false,"collection_id":16,"query_type":"native","name":"Number of Sessions per Sliding Weeks","query_average_duration":1021,"creator_id":10,"moderation_reviews":[],"updated_at":"2021-10-28T13:48:28.654435Z","made_public_by_id":null,"embedding_params":null,"cache_ttl":null,"dataset_query":{"database":3,"native":{"template-tags":{"Industry":{"id":"ecc842f5-4b17-ae7e-e6b7-4205599f5057","name":"Industry","display-name":"Industry","type":"dimension","dimension":["field",630477,null],"widget-type":"category"},"companyName":{"id":"319fc055-626d-b7c6-9dff-f928e2fc452a","name":"companyName","display-name":"Companyname","type":"dimension","dimension":["field",630449,null],"widget-type":"category"},"integrationType":{"id":"481953d1-33ae-9fa3-9c2c-ed7b36b0e7d0","name":"integrationType","display-name":"Integrationtype","type":"dimension","dimension":["field",630759,null],"widget-type":"category"}},"query":"SELECT \nScenarioName,\nVersion,\nsum(Sliding_7d_2) AS sum,\nsum(Sliding_7d_1) AS sum_2,\nCASE \n WHEN sum(Sliding_7d_2)=0 THEN NULL \n ELSE sum(Sliding_7d_diff)/sum(Sliding_7d_2)\n END AS sum_3,\nFROM production_stitch.V2V3_sessions_v1\nWHERE {{companyName}}\nAND {{Industry}}\nAND {{integrationType}}\nGROUP BY \nScenarioName,\nVersion\nORDER BY \nScenarioName ASC"},"type":"native"},"id":77,"display":"table","visualization_settings":{"table.columns":[{"name":"ScenarioName","fieldRef":["field","ScenarioName",{"base-type":"type/Text"}],"enabled":true},{"name":"Version","fieldRef":["field","Version",{"base-type":"type/Text"}],"enabled":true},{"name":"sum","fieldRef":["field","sum",{"base-type":"type/Integer"}],"enabled":true},{"name":"sum_2","fieldRef":["field","sum_2",{"base-type":"type/Integer"}],"enabled":true},{"name":"sum_3","fieldRef":["field","sum_3",{"base-type":"type/Float"}],"enabled":true}],"table.pivot_column":"sum_3","table.cell_column":"sum","table.column_formatting":[{"columns":["sum_3"],"type":"single","operator":"<","value":-0.15,"color":"#EF8C8C","highlight_row":true},{"columns":["sum_3"],"type":"single","operator":">","value":0.15,"color":"#88BF4D","highlight_row":true}],"column_settings":{"["name","sum_3"]":{"column_title":"Evolution","number_style":"percent"},"["name","sum_2"]":{"column_title":"last week"},"["name","sum"]":{"column_title":"2 weeks ago"},"["name","ScenarioName"]":{"column_title":"Scenario Name"}}},"created_at":"2021-09-09T17:31:28.191068Z","public_uuid":null},"updated_at":"2021-10-28T13:31:04.342065Z","col":0,"id":142,"parameter_mappings":[{"parameter_id":"a7e9a6b9","card_id":77,"target":["dimension",["template-tag","Industry"]]},{"parameter_id":"8044bc2f","card_id":77,"target":["dimension",["template-tag","companyName"]]}],"card_id":77,"visualization_settings":{"table.columns":[{"name":"ScenarioName","fieldRef":["field","ScenarioName",{"base-type":"type/Text"}],"enabled":true},{"name":"Version","fieldRef":["field","Version",{"base-type":"type/Text"}],"enabled":true},{"name":"sum","fieldRef":["field","sum",{"base-type":"type/Integer"}],"enabled":true},{"name":"sum_2","fieldRef":["field","sum_2",{"base-type":"type/Integer"}],"enabled":true},{"name":"sum_3","fieldRef":["field","sum_3",{"base-type":"type/Float"}],"enabled":true}],"table.pivot_column":"sum_3","table.cell_column":"sum","table.column_formatting":[{"columns":["sum_3"],"type":"single","operator":">","value":0.15,"color":"#88BF4D","highlight_row":true},{"columns":["sum_3"],"type":"single","operator":"<","value":-0.15,"color":"#EF8C8C","highlight_row":true}],"card.title":"Sessions volume per sliding weeks","card.description":"","column_settings":{"["name","sum_3"]":{"column_title":"Evolution","number_style":"percent"},"["name","sum_2"]":{"column_title":"last week"},"["name","sum"]":{"column_title":"2 weeks ago"},"["name","ScenarioName"]":{"column_title":"Scenario Name"}}},"dashboard_id":18,"created_at":"2021-09-09T17:32:25.498738Z","sizeY":7,"row":30},{"sizeX":18,"series":[],"collection_authority_level":null,"card":{"description":"Comparison of count of sessions over last month with the month before","archived":false,"collection_position":null,"table_id":null,"result_metadata":[{"name":"ScenarioName","display_name":"ScenarioName","base_type":"type/Text","effective_type":"type/Text","field_ref":["field","ScenarioName",{"base-type":"type/Text"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":50,"nil%":0.0},"type":{"type/Text":{"percent-json":0.0,"percent-url":0.0,"percent-email":0.0,"percent-state":0.0,"average-length":29.38}}}},{"name":"Version","display_name":"Version","base_type":"type/Text","effective_type":"type/Text","field_ref":["field","Version",{"base-type":"type/Text"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":2,"nil%":0.0},"type":{"type/Text":{"percent-json":0.0,"percent-url":0.0,"percent-email":0.0,"percent-state":0.0,"average-length":2.0}}}},{"name":"sum","display_name":"sum","base_type":"type/Integer","effective_type":"type/Integer","field_ref":["field","sum",{"base-type":"type/Integer"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":44,"nil%":0.0},"type":{"type/Number":{"min":0.0,"q1":207.0,"q3":7029.0,"max":179664.0,"sd":28072.333205023726,"avg":10921.24}}}},{"name":"sum_2","display_name":"sum_2","base_type":"type/Integer","effective_type":"type/Integer","field_ref":["field","sum_2",{"base-type":"type/Integer"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":48,"nil%":0.0},"type":{"type/Number":{"min":0.0,"q1":211.0,"q3":8097.0,"max":253596.0,"sd":37368.24517883207,"avg":13255.64}}}},{"name":"sum_3","display_name":"sum_3","base_type":"type/Float","effective_type":"type/Float","field_ref":["field","sum_3",{"base-type":"type/Float"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":44,"nil%":0.14},"type":{"type/Number":{"min":-0.7904667328699106,"q1":-0.08680801661982157,"q3":0.3024826564081514,"max":913.0,"sd":139.18469962370293,"avg":21.55717577584262}}}}],"database_id":3,"enable_embedding":false,"collection_id":16,"query_type":"native","name":"Number of Sessions per Sliding Months","query_average_duration":885,"creator_id":10,"moderation_reviews":[],"updated_at":"2021-10-28T13:48:29.183642Z","made_public_by_id":null,"embedding_params":null,"cache_ttl":null,"dataset_query":{"database":3,"native":{"template-tags":{"companyName":{"id":"e26168c7-99dd-4a37-526e-63787d7d4790","name":"companyName","display-name":"Companyname","type":"dimension","dimension":["field",630449,null],"widget-type":"category"},"Industry":{"id":"bdd7265a-d6cd-94b9-089c-bee2034f3a70","name":"Industry","display-name":"Industry","type":"dimension","dimension":["field",630477,null],"widget-type":"category"},"integrationType":{"id":"0e839eea-c4be-fa57-3676-a3f434fb2b53","name":"integrationType","display-name":"Integrationtype","type":"dimension","dimension":["field",630759,null],"widget-type":"category"}},"query":"SELECT \nproduction_stitch.V2V3_sessions_v1.ScenarioName AS ScenarioName,\nproduction_stitch.V2V3_sessions_v1.Version AS Version,\nsum(production_stitch.V2V3_sessions_v1.Sliding_30d_2) AS sum,\nsum(production_stitch.V2V3_sessions_v1.Sliding_30d_1) AS sum_2,\nCASE \n WHEN sum(production_stitch.V2V3_sessions_v1.Sliding_30d_2)=0 THEN NULL \n ELSE sum(production_stitch.V2V3_sessions_v1.Sliding_30d_diff)/sum(production_stitch.V2V3_sessions_v1.Sliding_30d_2)\n END AS sum_3,\nFROM production_stitch.V2V3_sessions_v1\nWHERE {{companyName}}\nAND {{Industry}}\nAND {{integrationType}}\nGROUP BY \nScenarioName,\nVersion\nORDER BY \nScenarioName ASC"},"type":"native"},"id":78,"display":"table","visualization_settings":{"table.columns":[{"name":"ScenarioName","fieldRef":["field","ScenarioName",{"base-type":"type/Text"}],"enabled":true},{"name":"Version","fieldRef":["field","Version",{"base-type":"type/Text"}],"enabled":true},{"name":"sum","fieldRef":["field","sum",{"base-type":"type/Integer"}],"enabled":true},{"name":"sum_2","fieldRef":["field","sum_2",{"base-type":"type/Integer"}],"enabled":true},{"name":"sum_3","fieldRef":["field","sum_3",{"base-type":"type/Float"}],"enabled":true}],"table.pivot_column":"sum_3","table.cell_column":"sum","table.column_formatting":[{"columns":["sum_3"],"type":"single","operator":"<","value":-0.15,"color":"#EF8C8C","highlight_row":true},{"columns":["sum_3"],"type":"single","operator":">","value":0.15,"color":"#88BF4D","highlight_row":true}],"column_settings":{"["name","ScenarioName"]":{"column_title":"Scenario Name"},"["name","sum"]":{"column_title":"2 months ago"},"["name","sum_2"]":{"column_title":"last month"},"["name","sum_3"]":{"column_title":"Evolution","number_style":"percent"}}},"created_at":"2021-09-09T17:37:14.421693Z","public_uuid":null},"updated_at":"2021-10-28T13:31:04.347551Z","col":0,"id":143,"parameter_mappings":[{"parameter_id":"a7e9a6b9","card_id":78,"target":["dimension",["template-tag","Industry"]]},{"parameter_id":"8044bc2f","card_id":78,"target":["dimension",["template-tag","companyName"]]}],"card_id":78,"visualization_settings":{"table.columns":[{"name":"ScenarioName","fieldRef":["field","ScenarioName",{"base-type":"type/Text"}],"enabled":true},{"name":"Version","fieldRef":["field","Version",{"base-type":"type/Text"}],"enabled":true},{"name":"sum","fieldRef":["field","sum",{"base-type":"type/Integer"}],"enabled":true},{"name":"sum_2","fieldRef":["field","sum_2",{"base-type":"type/Integer"}],"enabled":true},{"name":"sum_3","fieldRef":["field","sum_3",{"base-type":"type/Float"}],"enabled":true}],"table.pivot_column":"sum_3","table.cell_column":"sum","table.column_formatting":[{"columns":["sum_3"],"type":"single","operator":">","value":0.15,"color":"#88BF4D","highlight_row":true},{"columns":["sum_3"],"type":"single","operator":"<","value":-0.15,"color":"#EF8C8C","highlight_row":true}],"card.title":"Sessions volume per sliding months","column_settings":{"["name","ScenarioName"]":{"column_title":"Scenario Name"},"["name","sum"]":{"column_title":"2 months ago"},"["name","sum_2"]":{"column_title":"last month"},"["name","sum_3"]":{"column_title":"Evolution","number_style":"percent"}}},"dashboard_id":18,"created_at":"2021-09-09T17:38:45.501936Z","sizeY":7,"row":45},{"sizeX":18,"series":[],"collection_authority_level":null,"card":{"description":"Comparison of rate of avoided calls over last week with the week before","archived":false,"collection_position":null,"table_id":null,"result_metadata":[{"name":"ScenarioName","display_name":"ScenarioName","base_type":"type/Text","effective_type":"type/Text","field_ref":["field","ScenarioName",{"base-type":"type/Text"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":50,"nil%":0.0},"type":{"type/Text":{"percent-json":0.0,"percent-url":0.0,"percent-email":0.0,"percent-state":0.0,"average-length":29.38}}}},{"name":"Version","display_name":"Version","base_type":"type/Text","effective_type":"type/Text","field_ref":["field","Version",{"base-type":"type/Text"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":2,"nil%":0.0},"type":{"type/Text":{"percent-json":0.0,"percent-url":0.0,"percent-email":0.0,"percent-state":0.0,"average-length":2.0}}}},{"name":"sum","display_name":"sum","base_type":"type/Float","effective_type":"type/Float","field_ref":["field","sum",{"base-type":"type/Float"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":44,"nil%":0.0},"type":{"type/Number":{"min":0.0,"q1":0.28510938602681724,"q3":0.5232558139534884,"max":1.0,"sd":0.23224732567745604,"avg":0.39266623132113215}}}},{"name":"sum_2","display_name":"sum_2","base_type":"type/Float","effective_type":"type/Float","field_ref":["field","sum_2",{"base-type":"type/Float"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":45,"nil%":0.0},"type":{"type/Number":{"min":0.0,"q1":0.290879871434311,"q3":0.5892857142857143,"max":1.0,"sd":0.24551777779080486,"avg":0.3971934857049456}}}},{"name":"sum_3","display_name":"sum_3","base_type":"type/Float","effective_type":"type/Float","field_ref":["field","sum_3",{"base-type":"type/Float"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":45,"nil%":0.0},"type":{"type/Number":{"min":-0.467741935483871,"q1":-0.014648690692247834,"q3":0.013445425393697419,"max":1.0,"sd":0.17210194492269293,"avg":0.004527254383813375}}}}],"database_id":3,"enable_embedding":false,"collection_id":16,"query_type":"native","name":"Proportion of Avoided calls per Sliding Weeks","query_average_duration":888,"creator_id":10,"moderation_reviews":[],"updated_at":"2021-10-28T13:48:27.807433Z","made_public_by_id":null,"embedding_params":null,"cache_ttl":null,"dataset_query":{"database":3,"native":{"template-tags":{"companyName":{"id":"fbbd6c80-f561-3b1e-2fba-1e8ae2ac6095","name":"companyName","display-name":"Companyname","type":"dimension","dimension":["field",630449,null],"widget-type":"category"},"Industry":{"id":"6dc31973-837f-2858-a352-9293efcd0ce0","name":"Industry","display-name":"Industry","type":"dimension","dimension":["field",630477,null],"widget-type":"category"},"integrationType":{"id":"5a0bc69c-cee8-5266-c1a0-72e59941a04b","name":"integrationType","display-name":"Integrationtype","type":"dimension","dimension":["field",630759,null],"widget-type":"category"}},"query":"SELECT\n*,\nsum_2-sumAS sum_3\nFROM\n(SELECT \nproduction_stitch.V2V3_sessions_v1.ScenarioName AS ScenarioName,\nproduction_stitch.V2V3_sessions_v1.Version AS Version,\nCASE \n WHEN sum(production_stitch.V2V3_sessions_v1.Sliding_7d_2)=0 THEN 0 \n ELSE sum(production_stitch.V2V3_sessions_v1.Sliding_7d_2Avoiding)/sum(production_stitch.V2V3_sessions_v1.Sliding_7d_2)\n END AS sum,\nCASE \n WHEN sum(production_stitch.V2V3_sessions_v1.Sliding_7d_1)=0 THEN 0 \n ELSE sum(production_stitch.V2V3_sessions_v1.Sliding_7d_1Avoiding)/sum(production_stitch.V2V3_sessions_v1.Sliding_7d_1)\n END AS sum_2,\nFROM production_stitch.V2V3_sessions_v1\nWHERE {{companyName}}\nAND {{Industry}}\nAND {{integrationType}}\nGROUP BY \nScenarioName,\nVersion\nORDER BY \nScenarioName ASC)"},"type":"native"},"id":79,"display":"table","visualization_settings":{"table.columns":[{"name":"ScenarioName","fieldRef":["field","ScenarioName",{"base-type":"type/Text"}],"enabled":true},{"name":"Version","fieldRef":["field","Version",{"base-type":"type/Text"}],"enabled":true},{"name":"sum","fieldRef":["field","sum",{"base-type":"type/Float"}],"enabled":true},{"name":"sum_2","fieldRef":["field","sum_2",{"base-type":"type/Float"}],"enabled":true},{"name":"sum_3","fieldRef":["field","sum_3",{"base-type":"type/Float"}],"enabled":true}],"table.pivot_column":"sum_3","table.cell_column":"sum","table.column_formatting":[{"columns":["sum_3"],"type":"single","operator":"<","value":-0.15,"color":"#EF8C8C","highlight_row":true},{"columns":["sum_3"],"type":"single","operator":">","value":0.15,"color":"#88BF4D","highlight_row":true}],"column_settings":{"["name","sum_3"]":{"number_style":"percent","column_title":"Evolution"},"["name","sum_2"]":{"column_title":"last week","number_style":"percent"},"["name","sum"]":{"column_title":"2 weeks ago","number_style":"percent"},"["name","ScenarioName"]":{"column_title":"Scenario Name"}}},"created_at":"2021-09-10T17:04:57.609792Z","public_uuid":null},"updated_at":"2021-10-28T13:31:04.353261Z","col":0,"id":147,"parameter_mappings":[{"parameter_id":"a7e9a6b9","card_id":79,"target":["dimension",["template-tag","Industry"]]},{"parameter_id":"8044bc2f","card_id":79,"target":["dimension",["template-tag","companyName"]]}],"card_id":79,"visualization_settings":{"table.columns":[{"name":"ScenarioName","fieldRef":["field","ScenarioName",{"base-type":"type/Text"}],"enabled":true},{"name":"Version","fieldRef":["field","Version",{"base-type":"type/Text"}],"enabled":true},{"name":"sum","fieldRef":["field","sum",{"base-type":"type/Float"}],"enabled":true},{"name":"sum_2","fieldRef":["field","sum_2",{"base-type":"type/Float"}],"enabled":true},{"name":"sum_3","fieldRef":["field","sum_3",{"base-type":"type/Float"}],"enabled":true}],"table.pivot_column":"sum_3","table.cell_column":"sum","table.column_formatting":[{"columns":["sum_3"],"type":"single","operator":"<","value":-0.15,"color":"#EF8C8C","highlight_row":true},{"columns":["sum_3"],"type":"single","operator":">","value":0.15,"color":"#88BF4D","highlight_row":true}],"card.title":"Avoided calls rate per sliding weeks","column_settings":{"["name","sum_3"]":{"number_style":"percent","column_title":"Evolution"},"["name","sum_2"]":{"column_title":"last week","number_style":"percent"},"["name","sum"]":{"column_title":"2 weeks ago","number_style":"percent"},"["name","ScenarioName"]":{"column_title":"Scenario Name"}}},"dashboard_id":18,"created_at":"2021-09-10T17:07:31.715207Z","sizeY":7,"row":37},{"sizeX":18,"series":[],"collection_authority_level":null,"card":{"description":"Comparison of rate of avoided calls over last month with the month before","archived":false,"collection_position":null,"table_id":null,"result_metadata":[{"name":"ScenarioName","display_name":"ScenarioName","base_type":"type/Text","effective_type":"type/Text","field_ref":["field","ScenarioName",{"base-type":"type/Text"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":50,"nil%":0.0},"type":{"type/Text":{"percent-json":0.0,"percent-url":0.0,"percent-email":0.0,"percent-state":0.0,"average-length":29.38}}}},{"name":"Version","display_name":"Version","base_type":"type/Text","effective_type":"type/Text","field_ref":["field","Version",{"base-type":"type/Text"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":2,"nil%":0.0},"type":{"type/Text":{"percent-json":0.0,"percent-url":0.0,"percent-email":0.0,"percent-state":0.0,"average-length":2.0}}}},{"name":"sum","display_name":"sum","base_type":"type/Float","effective_type":"type/Float","field_ref":["field","sum",{"base-type":"type/Float"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":43,"nil%":0.0},"type":{"type/Number":{"min":0.0,"q1":0.27014218009478674,"q3":0.5566057550934678,"max":0.8473053892215568,"sd":0.2277518525505597,"avg":0.37269029481717486}}}},{"name":"sum_2","display_name":"sum_2","base_type":"type/Float","effective_type":"type/Float","field_ref":["field","sum_2",{"base-type":"type/Float"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":46,"nil%":0.0},"type":{"type/Number":{"min":0.0,"q1":0.29540481400437635,"q3":0.562200956937799,"max":1.0,"sd":0.22995828524605927,"avg":0.4050738470556858}}}},{"name":"sum_3","display_name":"sum_3","base_type":"type/Float","effective_type":"type/Float","field_ref":["field","sum_3",{"base-type":"type/Float"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":46,"nil%":0.0},"type":{"type/Number":{"min":-0.14038695952973732,"q1":-0.00651528357911324,"q3":0.02717024941951912,"max":1.0,"sd":0.1500219943754008,"avg":0.03238355223851097}}}}],"database_id":3,"enable_embedding":false,"collection_id":16,"query_type":"native","name":"Proportion of Avoided calls per Sliding Months","query_average_duration":839,"creator_id":10,"moderation_reviews":[],"updated_at":"2021-10-28T13:48:27.959283Z","made_public_by_id":null,"embedding_params":null,"cache_ttl":null,"dataset_query":{"type":"native","native":{"query":"SELECT\n*,\nsum_2-sumAS sum_3\nFROM\n(SELECT \nproduction_stitch.V2V3_sessions_v1.ScenarioName AS ScenarioName,\nproduction_stitch.V2V3_sessions_v1.Version AS Version,\nCASE \n WHEN sum(production_stitch.V2V3_sessions_v1.Sliding_30d_2)=0 THEN 0 \n ELSE sum(production_stitch.V2V3_sessions_v1.Sliding_30d_2Avoiding)/sum(production_stitch.V2V3_sessions_v1.Sliding_30d_2)\n END AS sum,\nCASE \n WHEN sum(production_stitch.V2V3_sessions_v1.Sliding_30d_1)=0 THEN 0 \n ELSE sum(production_stitch.V2V3_sessions_v1.Sliding_30d_1Avoiding)/sum(production_stitch.V2V3_sessions_v1.Sliding_30d_1)\n END AS sum_2,\nFROM production_stitch.V2V3_sessions_v1\nWHERE {{companyName}}\nAND {{Industry}}\nAND {{integrationType}}\nGROUP BY \nScenarioName,\nVersion\nORDER BY \nScenarioName ASC)","template-tags":{"companyName":{"id":"cbaf8b12-566c-06a4-393c-e5c88d5bb259","name":"companyName","display-name":"Companyname","type":"dimension","dimension":["field",630449,null],"widget-type":"category"},"Industry":{"id":"703d4d8a-1fe0-9123-3968-b2b37f818ce0","name":"Industry","display-name":"Industry","type":"dimension","dimension":["field",630477,null],"widget-type":"category"},"integrationType":{"id":"568b6dfa-e182-d635-70f4-fc2fc5a6a673","name":"integrationType","display-name":"Integrationtype","type":"dimension","dimension":["field",630759,null],"widget-type":"category"}}},"database":3},"id":80,"display":"table","visualization_settings":{"table.columns":[{"name":"ScenarioName","fieldRef":["field","ScenarioName",{"base-type":"type/Text"}],"enabled":true},{"name":"Version","fieldRef":["field","Version",{"base-type":"type/Text"}],"enabled":true},{"name":"sum","fieldRef":["field","sum",{"base-type":"type/Float"}],"enabled":true},{"name":"sum_2","fieldRef":["field","sum_2",{"base-type":"type/Float"}],"enabled":true},{"name":"sum_3","fieldRef":["field","sum_3",{"base-type":"type/Float"}],"enabled":true}],"table.pivot_column":"sum_3","table.cell_column":"sum","table.column_formatting":[{"columns":["sum_3"],"type":"single","operator":"<","value":-0.15,"color":"#EF8C8C","highlight_row":true},{"columns":["sum_3"],"type":"single","operator":">","value":0.15,"color":"#88BF4D","highlight_row":true}],"column_settings":{"["name","ScenarioName"]":{"column_title":"Scenario Name"},"["name","sum"]":{"column_title":"2 months ago","number_style":"percent"},"["name","sum_2"]":{"column_title":"last month","number_style":"percent"},"["name","sum_3"]":{"column_title":"Evolution","number_style":"percent"}}},"created_at":"2021-09-10T17:15:36.914984Z","public_uuid":null},"updated_at":"2021-10-28T13:31:04.358933Z","col":0,"id":148,"parameter_mappings":[{"parameter_id":"a7e9a6b9","card_id":80,"target":["dimension",["template-tag","Industry"]]},{"parameter_id":"8044bc2f","card_id":80,"target":["dimension",["template-tag","companyName"]]}],"card_id":80,"visualization_settings":{"table.columns":[{"name":"ScenarioName","fieldRef":["field","ScenarioName",{"base-type":"type/Text"}],"enabled":true},{"name":"Version","fieldRef":["field","Version",{"base-type":"type/Text"}],"enabled":true},{"name":"sum","fieldRef":["field","sum",{"base-type":"type/Float"}],"enabled":true},{"name":"sum_2","fieldRef":["field","sum_2",{"base-type":"type/Float"}],"enabled":true},{"name":"sum_3","fieldRef":["field","sum_3",{"base-type":"type/Float"}],"enabled":true}],"table.pivot_column":"sum_3","table.cell_column":"sum","table.column_formatting":[{"columns":["sum_3"],"type":"single","operator":"<","value":-0.15,"color":"#EF8C8C","highlight_row":true},{"columns":["sum_3"],"type":"single","operator":">","value":0.15,"color":"#88BF4D","highlight_row":true}],"card.title":"Avoided calls rate per sliding months","column_settings":{"["name","ScenarioName"]":{"column_title":"Scenario Name"},"["name","sum"]":{"column_title":"2 months ago","number_style":"percent"},"["name","sum_2"]":{"column_title":"last month","number_style":"percent"},"["name","sum_3"]":{"column_title":"Evolution","number_style":"percent"}}},"dashboard_id":18,"created_at":"2021-09-10T17:16:16.497688Z","sizeY":7,"row":52},{"sizeX":18,"series":[],"collection_authority_level":null,"card":{"query_average_duration":null},"updated_at":"2021-10-28T13:31:04.364208Z","col":0,"id":149,"parameter_mappings":[],"card_id":null,"visualization_settings":{"virtual_card":{"name":null,"display":"text","visualization_settings":{},"dataset_query":{},"archived":false},"text":"# Vocal journey (SMS)","text.align_horizontal":"left","text.align_vertical":"middle"},"dashboard_id":18,"created_at":"2021-09-10T18:34:49.80335Z","sizeY":2,"row":22},{"sizeX":12,"series":[],"collection_authority_level":null,"card":{"description":"The SMS funnel describes the total number of sent sms that result into used ones and, thus generating at least a session. The sms used rate is given in small characters in the bottom right.","archived":false,"collection_position":null,"table_id":null,"result_metadata":[{"name":"value","display_name":"value","base_type":"type/Integer","effective_type":"type/Integer","field_ref":["field","value",{"base-type":"type/Integer"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":2,"nil%":0.0},"type":{"type/Number":{"min":2758529.0,"q1":2758529.0,"q3":6216265.0,"max":6216265.0,"sd":2444988.573152848,"avg":4487397.0}}}},{"name":"total","display_name":"total","base_type":"type/Text","effective_type":"type/Text","field_ref":["field","total",{"base-type":"type/Text"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":2,"nil%":0.0},"type":{"type/Text":{"percent-json":0.0,"percent-url":0.0,"percent-email":0.0,"percent-state":0.0,"average-length":7.0}}}}],"database_id":3,"enable_embedding":false,"collection_id":16,"query_type":"native","name":"Funnel from Sent Sms to Used sms ","query_average_duration":5450,"creator_id":2,"moderation_reviews":[],"updated_at":"2021-10-28T13:48:33.744461Z","made_public_by_id":null,"embedding_params":null,"cache_ttl":null,"dataset_query":{"type":"native","native":{"query":"/\nAuthor: aterrien\nDate: 13/10/2021\nReviewer: lgeran\nDate R: 13/10/2021\n/\n\nWITH table1 AS (\nSELECT\n--COUNT(DISTINCT (CASE WHEN callerPhoneNumber IS NOT NULL THEN callerPhoneNumber END)) AS CallerPhoneNumber,\nCOUNT(DISTINCT (CASE WHEN smsSent IS NOT NULL THEN smsSent END)) AS SmsSent,\nCOUNT(DISTINCT (CASE WHEN smsUsedIS NOT NULL THEN smsUsed END)) AS SmsUsed,\n--COUNT(DISTINCT (CASE WHEN smsUsed IS NOT NULL AND session IS NOT NULL THEN session END)) AS Sessions\nFROM production_stitch.V2V3_sms_v1\nWHERE {{Date}} AND {{Industry}} AND {{companyName}}\n)\nSELECT \n* \nFROM table1 \nUNPIVOT(value FOR total IN (SmsSent, SmsUsed))\n","template-tags":{"Date":{"id":"d2fd170b-0def-67bd-0c56-57ee014c73ae","name":"Date","display-name":"Date","type":"dimension","dimension":["field",630427,null],"widget-type":"date/all-options"},"Industry":{"id":"3277b940-28ea-acfb-b002-2b850c698387","name":"Industry","display-name":"Industry","type":"dimension","dimension":["field",630424,null],"widget-type":"category"},"companyName":{"id":"dd44ded4-50d1-55cd-e707-fdad457d42a0","name":"companyName","display-name":"Companyname","type":"dimension","dimension":["field",630419,null],"widget-type":"category"}}},"database":3},"id":95,"display":"funnel","visualization_settings":{"funnel.dimension":"total","funnel.type":"funnel","card.description":"The SMS funnel describes the total number of sent sms that result into used ones and, thus generate at least a session. The rate is given in small characters in the bottom right.","card.title":"SMS Funnel","table.pivot_column":"value","table.cell_column":"total"},"created_at":"2021-09-17T07:06:03.637673Z","public_uuid":null},"updated_at":"2021-10-28T13:31:04.369096Z","col":6,"id":158,"parameter_mappings":[{"parameter_id":"a7e9a6b9","card_id":95,"target":["dimension",["template-tag","Industry"]]},{"parameter_id":"999fbf09","card_id":95,"target":["dimension",["template-tag","Date"]]},{"parameter_id":"8044bc2f","card_id":95,"target":["dimension",["template-tag","companyName"]]}],"card_id":95,"visualization_settings":{"funnel.dimension":"total","funnel.type":"funnel","card.description":"Identify how many sms sent generate at least one session","card.title":"SMS sent volume and sms use rate","table.pivot_column":"value","table.cell_column":"total"},"dashboard_id":18,"created_at":"2021-09-17T07:06:22.573865Z","sizeY":4,"row":24},{"sizeX":9,"series":[],"collection_authority_level":null,"card":{"description":"Repartition of the number of sessions per industry","archived":false,"collection_position":null,"table_id":316,"result_metadata":[{"semantic_type":"type/Category","coercion_strategy":null,"name":"Industry","field_ref":["field",630477,null],"effective_type":"type/Text","id":630477,"display_name":"Industry","fingerprint":{"global":{"distinct-count":6,"nil%":0.0},"type":{"type/Text":{"percent-json":0.0,"percent-url":0.0,"percent-email":0.0,"percent-state":0.0,"average-length":7.7421}}},"base_type":"type/Text"},{"name":"Volume session","display_name":"Volume session","base_type":"type/Integer","effective_type":"type/Integer","semantic_type":null,"field_ref":["aggregation",0],"fingerprint":{"global":{"distinct-count":9,"nil%":0.0},"type":{"type/Number":{"min":276.0,"q1":3579.0,"q3":144623.25,"max":258134.0,"sd":92165.3398899379,"avg":73642.44444444444}}}}],"database_id":3,"enable_embedding":false,"collection_id":33,"query_type":"query","name":"Number of Sessions per Industry ","query_average_duration":931,"creator_id":4,"moderation_reviews":[],"updated_at":"2021-10-28T13:48:28.167335Z","made_public_by_id":null,"embedding_params":null,"cache_ttl":null,"dataset_query":{"database":3,"query":{"source-table":316,"aggregation":[["aggregation-options",["sum",["field",630429,null]],{"name":"Volume session","display-name":"Volume session"}]],"breakout":[["field",630477,null]]},"type":"query"},"id":96,"display":"pie","visualization_settings":{"pie.dimension":"Industry","pie.show_legend_perecent":true,"pie.show_legend":true,"pie.metric":"NbSession","graph.dimensions":["clientName","Industry"],"pie.slice_threshold":0,"card.description":"Identify what is the impact of each industry on the session volume. The industry is defined on Salesforce Accounts, ","graph.metrics":["NbSession"]},"created_at":"2021-09-17T07:28:36.157683Z","public_uuid":null},"updated_at":"2021-10-28T13:31:04.374755Z","col":9,"id":159,"parameter_mappings":[{"parameter_id":"a7e9a6b9","card_id":96,"target":["dimension",["field",630477,null]]},{"parameter_id":"8044bc2f","card_id":96,"target":["dimension",["field",630449,null]]},{"parameter_id":"999fbf09","card_id":96,"target":["dimension",["field",630439,null]]}],"card_id":96,"visualization_settings":{"pie.slice_threshold":0,"pie.show_legend_perecent":true,"click_behavior":{"targetId":22,"parameterMapping":{"c27b4c3e":{"source":{"type":"column","id":"Industry","name":"Industry"},"target":{"type":"parameter","id":"c27b4c3e"},"id":"c27b4c3e"},"79f610c8":{"source":{"type":"column","id":"Industry","name":"Industry"},"target":{"type":"parameter","id":"79f610c8"},"id":"79f610c8"},"e6fc2c4e":{"source":{"type":"parameter","id":"999fbf09","name":"Date Filter"},"target":{"type":"parameter","id":"e6fc2c4e"},"id":"e6fc2c4e"}},"linkType":"dashboard","type":"link"},"pie.dimension":"Industry","graph.metrics":["NbSession"],"pie.metric":"NbSession","pie.show_legend":true,"card.description":"Identify what is the impact of each industry on the session volume. The industry is defined on Salesforce Accounts, ","graph.dimensions":["clientName","Industry"]},"dashboard_id":18,"created_at":"2021-09-17T07:29:16.53289Z","sizeY":5,"row":4},{"sizeX":6,"series":[],"collection_authority_level":null,"card":{"description":"The total number of sent SMS","archived":false,"collection_position":null,"table_id":null,"result_metadata":[{"name":"count","display_name":"count","base_type":"type/Integer","effective_type":"type/Integer","field_ref":["field","count",{"base-type":"type/Integer"}],"semantic_type":"type/Quantity","fingerprint":{"global":{"distinct-count":1,"nil%":0.0},"type":{"type/Number":{"min":537039.0,"q1":537039.0,"q3":537039.0,"max":537039.0,"sd":null,"avg":537039.0}}}}],"database_id":3,"enable_embedding":false,"collection_id":16,"query_type":"native","name":"Number of Sent sms ","query_average_duration":4071,"creator_id":4,"moderation_reviews":[],"updated_at":"2021-10-28T13:48:32.124977Z","made_public_by_id":null,"embedding_params":null,"cache_ttl":null,"dataset_query":{"type":"native","native":{"query":"/\nAuthor: lgeran\nDate: 13/10/2021\nReviewer: lgeran \nDate R: 13/10/2021\n/\n\nSELECT COUNT(DISTINCT production_stitch.V2V3_sms_v1.smsSent) AS count\nFROM production_stitch.V2V3_sms_v1\nWHERE production_stitch.V2V3_sms_v1.smsSent IS NOT NULL\nAND {{date}}\nAND {{Industry}}\nAND {{CompanyName}}","template-tags":{"date":{"id":"dc5e30b8-43ae-69f3-5898-4b285982386f","name":"date","display-name":"Date","type":"dimension","dimension":["field",630427,null],"widget-type":"date/all-options"},"Industry":{"id":"292ebbf1-1638-8022-937d-df35f7773812","name":"Industry","display-name":"Industry","type":"dimension","dimension":["field",630424,null],"widget-type":"category"},"CompanyName":{"id":"1d036e22-de18-46b4-2240-1aff8f8fee2d","name":"CompanyName","display-name":"Companyname","type":"dimension","dimension":["field",630419,null]}}},"database":3},

4

This part should be more interesting. As you can see, it tries to load the card_id : 94, whereas this card is not in the dashboard

"id":69,"display":"scalar","visualization_settings":{"card.title":"SMS sent volume","card.description":"This number describes the total number of SMS sent to consumers."},"created_at":"2021-09-09T13:29:31.023458Z","public_uuid":null},"updated_at":"2021-10-28T13:31:04.380814Z","col":6,"id":160,"parameter_mappings":[{"parameter_id":"999fbf09","card_id":69,"target":["dimension",["template-tag","date"]]},{"parameter_id":"a7e9a6b9","card_id":69,"target":["dimension",["template-tag","Industry"]]},{"parameter_id":"8044bc2f","card_id":69,"target":["dimension",["template-tag","CompanyName"]]}],"card_id":69,"visualization_settings":{"card.title":"SMS sent volume","card.description":"Amount of SMS sent to an end user who initially try to interact with an agent. As each SMS is related to a uniq ID, this volume equal the total amount of unique ID_sms"},"dashboard_id":18,"created_at":"2021-09-17T14:10:42.911181Z","sizeY":3,"row":1},{"sizeX":18,"series":[{"id":70,"name":"Number of Sent sms per Day","description":"Count of sent sms per day","display":"bar","dataset_query":{"type":"query","query":{"source-table":315,"filter":["not-empty",["field",630425,null]],"aggregation":[["distinct",["field",630425,null]]],"breakout":[["field",630427,{"temporal-unit":"day"}]]},"database":3},"visualization_settings":{"graph.dimensions":["date"],"series_settings":{"count":{"color":"#A989C5"}},"graph.metrics":["count"]},"collection_id":16,"query_average_duration":8213}],"collection_authority_level":null,"card":{"description":"Count of sessions per day","archived":false,"collection_position":null,"table_id":null,"result_metadata":[{"name":"date","display_name":"date","base_type":"type/Date","effective_type":"type/Date","field_ref":["field","date",{"base-type":"type/Date"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":30,"nil%":0.0},"type":{"type/DateTime":{"earliest":"2021-09-28T02:00:00+02:00","latest":"2021-10-27T02:00:00+02:00"}}}},{"name":"sum","display_name":"sum","base_type":"type/Integer","effective_type":"type/Integer","field_ref":["field","sum",{"base-type":"type/Integer"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":29,"nil%":0.0},"type":{"type/Number":{"min":7155.0,"q1":15332.0,"q3":27589.0,"max":30479.0,"sd":7802.175903104754,"avg":22092.733333333334}}}}],"database_id":3,"enable_embedding":false,"collection_id":16,"query_type":"native","name":"Number of Sessions per Day","query_average_duration":1272,"creator_id":2,"moderation_reviews":[],"updated_at":"2021-10-28T13:48:29.144376Z","made_public_by_id":null,"embedding_params":null,"cache_ttl":null,"dataset_query":{"database":3,"native":{"template-tags":{"date":{"id":"51bacd1f-33dd-f34f-ed29-25fb2eb14a56","name":"date","display-name":"Date","type":"dimension","dimension":["field",630439,null],"widget-type":"date/all-options"},"Industry":{"id":"49d692c4-2897-d43c-7e96-200c233afcef","name":"Industry","display-name":"Industry","type":"dimension","dimension":["field",630477,null],"widget-type":"category"},"companyName":{"id":"f6c2384f-e26e-f7a0-a8b1-56ee7cf9992f","name":"companyName","display-name":"Companyname","type":"dimension","dimension":["field",630449,null],"widget-type":"category"},"scenarioName":{"id":"d9d94573-ccaa-0bc1-ed31-8ffc50018108","name":"scenarioName","display-name":"Scenarioname","type":"dimension","dimension":["field",630435,null],"widget-type":"category"},"integrationType":{"id":"2c3f3b26-24f4-5f91-75af-0c3851707e2c","name":"integrationType","display-name":"Integrationtype","type":"dimension","dimension":["field",630759,null],"widget-type":"category"}},"query":"SELECT date_trunc(production_stitch.V2V3_sessions_v1.date, day) AS date, sum(production_stitch.V2V3_sessions_v1.NbSessionID) AS sum\nFROM production_stitch.V2V3_sessions_v1\nWHERE {{date}} \nAND {{Industry}} \nAND {{companyName}} \nAND {{scenarioName}}\nAND {{integrationType}}\nGROUP BY date\nORDER BY date ASC"},"type":"native"},"id":72,"display":"line","visualization_settings":{"graph.show_goal":false,"graph.show_trendline":true,"graph.show_values":false,"graph.goal_value":100000,"card.title":"Sessions and SMS sent volume per day","graph.y_axis.auto_split":false,"graph.metrics":["sum"],"card.description":"Analyse the correlation between SMS sent and session generate","series_settings":{"sum":{"title":"Sessions","color":"#F2A86F","display":"area"},"V2v3 Sms Persistents, Distinct values of SmsSent, Grouped by Date (day), Filtered by SmsSent, Date, and Date":{"title":"SMS Sent","color":"#A989C5"},"SMS sent volume per day":{"color":"#A989C5"}},"graph.dimensions":["date"]},"created_at":"2021-09-09T15:51:20.82861Z","public_uuid":null},"updated_at":"2021-10-28T13:31:04.38645Z","col":0,"id":162,"parameter_mappings":[{"parameter_id":"999fbf09","card_id":72,"target":["dimension",["template-tag","date"]]},{"parameter_id":"a7e9a6b9","card_id":72,"target":["dimension",["template-tag","Industry"]]},{"parameter_id":"999fbf09","card_id":70,"target":["dimension",["field",630427,null]]},{"parameter_id":"a7e9a6b9","card_id":70,"target":["dimension",["field",630424,null]]},{"parameter_id":"8044bc2f","card_id":72,"target":["dimension",["template-tag","companyName"]]},{"parameter_id":"8044bc2f","card_id":70,"target":["dimension",["field",630419,null]]}],"card_id":72,"visualization_settings":{"graph.show_goal":false,"graph.show_trendline":true,"graph.show_values":false,"graph.goal_value":100000,"card.title":"Sessions and SMS sent volume per day","graph.y_axis.auto_split":false,"graph.metrics":["sum"],"card.description":"Analyse the correlation between SMS sent and session generate","series_settings":{"sum":{"title":"Sessions","color":"#F2A86F"},"V2v3 Sms Persistents, Distinct values of SmsSent, Grouped by Date (day), Filtered by SmsSent, Date, and Date":{"title":"SMS Sent","color":"#A989C5"},"SMS sent volume per day":{"color":"#A989C5"}},"graph.dimensions":["date"]},"dashboard_id":18,"created_at":"2021-09-17T14:34:49.887521Z","sizeY":7,"row":9},{"sizeX":18,"series":[],"collection_authority_level":null,"card":{"query_average_duration":null},"updated_at":"2021-10-28T13:31:04.392277Z","col":0,"id":168,"parameter_mappings":[],"card_id":null,"visualization_settings":{"virtual_card":{"name":null,"display":"text","visualization_settings":{},"dataset_query":{},"archived":false},"text":"# Evolution"},"dashboard_id":18,"created_at":"2021-09-22T10:52:47.108141Z","sizeY":1,"row":28},{"sizeX":5,"series":[],"collection_authority_level":null,"card":{"description":"Cont of unique callers","archived":false,"collection_position":null,"table_id":null,"result_metadata":[{"name":"count","display_name":"count","base_type":"type/Integer","effective_type":"type/Integer","field_ref":["field","count",{"base-type":"type/Integer"}],"semantic_type":"type/Quantity","fingerprint":{"global":{"distinct-count":1,"nil%":0.0},"type":{"type/Number":{"min":778411.0,"q1":778411.0,"q3":778411.0,"max":778411.0,"sd":null,"avg":778411.0}}}}],"database_id":3,"enable_embedding":false,"collection_id":16,"query_type":"native","name":"Number of Unique callers","query_average_duration":5515,"creator_id":10,"moderation_reviews":[],"updated_at":"2021-10-28T13:48:32.490262Z","made_public_by_id":null,"embedding_params":null,"cache_ttl":null,"dataset_query":{"database":3,"native":{"template-tags":{"date":{"id":"757907d2-e69c-103b-cff2-a4ef7ddd1495","name":"date","display-name":"Date","type":"dimension","dimension":["field",630427,null],"widget-type":"date/month-year"},"Industry":{"id":"2aee400f-c961-3fb0-9818-63d3b9ad2aef","name":"Industry","display-name":"Industry","type":"dimension","dimension":["field",630424,null],"widget-type":"category"},"companyName":{"id":"4c2dda3d-7e3f-724f-4e1e-440251cebdff","name":"companyName","display-name":"Companyname","type":"dimension","dimension":["field",630419,null],"widget-type":"category"}},"query":"SELECT count(distinct production_stitch.V2V3_sms_v1.callerPhoneNumber)+count(distinct production_stitch.V2V3_sms_v1.initNumberMissing) AS count\nFROM production_stitch.V2V3_sms_v1\nWHERE {{date}}\nAND {{Industry}}\nAND {{companyName}}"},"type":"native"},"id":104,"display":"scalar","visualization_settings":{"card.title":"Unique callers volume","card.description":"Amount of unique end user mobile phone number received an SMS"},"created_at":"2021-09-22T12:19:53.45182Z","public_uuid":null},"updated_at":"2021-10-28T13:31:04.399168Z","col":0,"id":172,"parameter_mappings":[{"parameter_id":"999fbf09","card_id":104,"target":["dimension",["template-tag","date"]]},{"parameter_id":"a7e9a6b9","card_id":104,"target":["dimension",["template-tag","Industry"]]},{"parameter_id":"8044bc2f","card_id":104,"target":["dimension",["template-tag","companyName"]]}],"card_id":104,"visualization_settings":{"card.title":"Unique callers volume","card.description":"Amount of unique end user mobile phone number received an SMS","click_behavior":{"type":"link","linkType":"question","parameterMapping":{},"targetId":94}},"dashboard_id":18,"created_at":"2021-09-22T12:20:30.035051Z","sizeY":4,"row":24},{"sizeX":4,"series":[],"collection_authority_level":null,"card":{"description":null,"archived":false,"collection_position":null,"table_id":null,"result_metadata":[{"name":"value","display_name":"value","base_type":"type/Integer","effective_type":"type/Integer","field_ref":["field","value",{"base-type":"type/Integer"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":3,"nil%":0.0},"type":{"type/Number":{"min":2758529.0,"q1":3208559.75,"q3":5801861.75,"max":6216265.0,"sd":1729357.3911809938,"avg":4511148.666666667}}}},{"name":"total","display_name":"total","base_type":"type/Text","effective_type":"type/Text","field_ref":["field","total",{"base-type":"type/Text"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":3,"nil%":0.0},"type":{"type/Text":{"percent-json":0.0,"percent-url":0.0,"percent-email":0.0,"percent-state":0.0,"average-length":7.333333333333333}}}}],"database_id":3,"enable_embedding":false,"collection_id":9,"query_type":"native","name":"funnelsms (Mystery Dashboard)","query_average_duration":16545,"creator_id":2,"moderation_reviews":[],"updated_at":"2021-10-28T13:49:39.014978Z","made_public_by_id":null,"embedding_params":null,"cache_ttl":null,"dataset_query":{"database":3,"native":{"template-tags":{"companyName":{"id":"c79d1ae5-5bbe-a79c-ba82-8a1d3708e1df","name":"companyName","display-name":"Companyname","type":"dimension","dimension":["field",9165,null]},"date":{"id":"1cefdaf4-eb95-c8d4-8040-7587a2927fa9","name":"date","display-name":"Date","type":"dimension","dimension":["field",9162,null],"widget-type":"date/all-options"},"Industry":{"id":"22ac05e1-b8eb-808e-4513-5a1fe9c758e4","name":"Industry","display-name":"Industry","type":"dimension","dimension":["field",9164,null],"widget-type":"category"}},"query":"WITH table1 AS (\nSELECT\n-- COUNT(DISTINCT (CASE WHEN smsAsked IS NOT NULL THEN SmsAsked END)) AS SmsAsked,\nCOUNT(DISTINCT (CASE WHEN smsSent IS NOT NULL THEN smsSent END)) AS SmsSent,\nCOUNT(DISTINCT (CASE WHEN smsUsed IS NOT NULL THEN smsUsed END)) AS SmsUsed,\n--COUNT(DISTINCT (CASE WHEN session IS NOT NULL THEN smsUsed END)) AS Sessions,\nCOUNT(DISTINCT (CASE WHEN smsUsed IS NOT NULL AND session IS NOT NULL THEN session END)) AS Sessions\nFROM production_stitch.V2V3_sms_v1\n)\nSELECT * FROM table1\nUNPIVOT(value FOR total IN (SmsSent, SmsUsed, Sessions))\nWHERE {{companyName}} AND {{date}} AND {{Industry}}"},"type":"native"},"id":94,"display":"table","visualization_settings":{"table.pivot_column":"value","table.cell_column":"total"},"created_at":"2021-09-16T09:49:47.90177Z","public_uuid":null},"updated_at":"2021-10-28T13:31:04.403951Z","col":0,"id":416,"parameter_mappings":[],"card_id":94,"visualization_settings":{},"dashboard_id":18,"created_at":"2021-10-28T13:31:04.103545Z","sizeY":4,"row":59}],"param_values":{"630424":{"values":[null,"Banking","Energy","Health Insurance","IT","Insurance","Other","Public","Retail","Telecom","Transportation & Logistics","Travel"],"human_readable_values":[],"field_id":630424},"630419":{"values":[null,"AXA Banque","AXA France Assistance Santé","BNP Paribas Epargne & Retraite Entreprises","Banque Populaire Aquitaine Centre Atlantique","Banque Populaire Val de France","Boulanger S.A.","CNP Assurances","CRM SERVICES","Camif","Camping and Co","Compte Nickel","Crédit Agricole Normandie Seine","Crédit Agricole Alpes Provence","Crédit Agricole Consumer Finance (Sofinco)","Crédit Agricole Ille et Vilaine","Crédit Agricole La Réunion","Crédit Agricole Nord Midi Pyrenees","Crédit Agricole Nord de France","Crédit Foncier","DIAC","Darty","Dial Once","ES Energies Strasbourg","EWE","Engie - DTR","Eni gas & Power France","GRDF","Generali Vie","La Poste","Les impots (DGFIP) - BU DINR","Les impôts (DGFIP) - BU SRP","MACIF","MAIF","MATMUT","Matmut Protection Juridique","Mutuelle Entre Nous","Natixis Assurances Non VIE","ONEO","ORANGE Badge Now","Orange Business Services (OBS)","Orange Entreprise","Proxiserve","RATP","SIG - Service d'Information du Gouvernement","Schindler","Total Direct Energie","Vattenfall France","ZEOP"],"human_readable_values":[],"field_id":630419},"630759":{"values":["Click to Hub Hyperlink","Click to Hub Widget","SMS to Hub"],"human_readable_values":[],"field_id":630759},"9164":{"values":[null,"Banking","Energy","High-Tech","Hôtellerie","Insurance","Integrator","Mutuelle","Others","Public","Retail","Telecom","Transportation & Logistics","Utilities"],"human_readable_values":[],"field_id":9164},"630435":{"values":["Axa Assistance - Conseil schéma parcours clients cible","Axa Assistance Santé - Live Etape 1 et 2","BNP ERE","BNPP Epargne Retraite - Live","BPACA - SVI Visuel Gestion de crise","Banque Populaire Méditerranée - SVI Visuel - live","Banque Populaire Val de France - Live MyHub","Boulanger","CA NS","CA Normandie Seine - Live","CAMIF","CANS - Conseillers - SVI visuel","Camif","Camping and Co","CampingandCo - Orchestrateur omnicanal - Live","Crédit Agricole Alpes Provence - SVI Visuel/MyHub - Intro Nouvellesdonnes","Crédit Agricole Ille-et-Vilaine - SVI Visuel CRC","Crédit Agricole La Réunion - MyHub - live Agences","Crédit Agricole La Réunion - MyHub - live Conseillers","Crédit Agricole Nord Midi Pyrénées - SVI Visuel - live","Crédit Agricole Nord de France - live - Orchestrateur Omnicanal","Crédit foncier - Live","Darty ICH pilote","Darty pilote","Darty pilote - SCENARIO TEST IADVISE","ES Energies Strasbourg - Live - ELEC","Engie - Gaz tarif réglementé (DTR) Live","Fortuneo - Live SVI Visuel","GRDF - Live OBS GV","La Poste","Les impôts DGFIP - Live - DINR","Les impôts DGFIP - Live - SRP","Macif : SVI Visuel Gestion de crise","Maif","Matmut","Ministère de la Santé via TP - SVI Visuel Vaccination Covid 19","Mutuelle Entre Nous - SVI Visuel - live","Nickel","Oneo - SVI Visuel - live","Orange Entreprise - PABX Live","RCI Bank and Services - live","Roederer","SVI Visuel RATP Live et set up V1 via SoftwareONE","Schindler - SVI Visuel - live","Simax Santé","Société Générale Factoring - live (Arkéa)","Société Générale Factoring - live (CDN)","Société Générale Factoring - live (SGF)","Vattenfall","ZEOP"],"human_readable_values":[],"field_id":630435},"9165":{"values":[null,"AXA Assistance","AXA Assistance Sante","Axa Banque","BNPP ERE","BPACA","BPVF","Boulanger","CAAP","CAIV","CALR","CAMIF","CANDF","CNP","CRM Services","Camif","Camping and Co","Compte Nickel","Crédit Agricole Normandie Seine","Crédit Foncier","DGFIP","DGFIP DINR","Darty","Dial Once","Dialonce","Direct Energie","ENGIE DTR","ENI","ES Energie","EWE","EntreNous","GRDF","Generali","La Poste","MACIF","MAIF","Matmut","Ministère de la Santé vaccination Covid 19","NATIXIS","Nickel","Nouvelle Donne","OBS","ONEO","Orange Badge Now","Orange PABX","Proxiserve","RATP","RCI Banque - Diac","SIG COVID","Schindler","Sofinco","Solidaris","Vattenfall","ZEOP"],"human_readable_values":[],"field_id":9165},"630449":{"values":["AXA France Assistance Santé","BNP Paribas Epargne & Retraite Entreprises","Banque Populaire Aquitaine Centre Atlantique","Banque Populaire Méditerranée","Banque Populaire Val de France","Boulanger S.A.","Camif","Camping and Co","Compte Nickel","Crédit Agricole Normandie Seine","Crédit Agricole Alpes Provence","Crédit Agricole Ille et Vilaine","Crédit Agricole La Réunion","Crédit Agricole Nord Midi Pyrenees","Crédit Agricole Nord de France","Crédit Foncier","DIAC","Darty","ES Energies Strasbourg","Engie - DTR","Fortuneo","GRDF","La Poste","Les impots (DGFIP) - BU DINR","Les impôts (DGFIP) - BU SRP","MACIF","MAIF","MATMUT","Mutuelle Entre Nous","ONEO","Orange Entreprise","RATP","Roederer","SIG Vaccin Covid 19","Schindler","Société Générale Factoring","Vattenfall France","ZEOP"],"human_readable_values":[],"field_id":630449},"630477":{"values":["Banking","Energy","Health Insurance","IT","Insurance","Public","Retail","Telecom","Transportation & Logistics","Travel"],"human_readable_values":[],"field_id":630477}},"can_write":true,"enable_embedding":false,"collection_id":9,"show_in_getting_started":false,"name":"Mystery Dashboard","caveats":null,"collection_authority_level":null,"creator_id":2,"updated_at":"2021-10-28T13:31:04.574154Z","made_public_by_id":null,"embedding_params":null,"cache_ttl":null,"id":18,"position":null,"param_fields":{"9164":{"id":9164,"table_id":301,"display_name":"Industry","base_type":"type/Text","semantic_type":"type/Category","has_field_values":"list","name_field":null,"dimensions":[]},"9165":{"id":9165,"table_id":301,"display_name":"ClientName","base_type":"type/Text","semantic_type":null,"has_field_values":"list","name_field":null,"dimensions":[]},"630419":{"id":630419,"table_id":315,"display_name":"ClientName","base_type":"type/Text","semantic_type":"type/Category","has_field_values":"list","name_field":null,"dimensions":[]},"630439":{"id":630439,"table_id":316,"display_name":"Date","base_type":"type/Date","semantic_type":null,"has_field_values":"none","name_field":null,"dimensions":[]},"630477":{"id":630477,"table_id":316,"display_name":"Industry","base_type":"type/Text","semantic_type":"type/Category","has_field_values":"list","name_field":null,"dimensions":[]},"630435":{"id":630435,"table_id":316,"display_name":"ScenarioName","base_type":"type/Text","semantic_type":"type/Category","has_field_values":"list","name_field":null,"dimensions":[]},"630759":{"id":630759,"table_id":316,"display_name":"IntegrationType","base_type":"type/Text","semantic_type":"type/Category","has_field_values":"list","name_field":null,"dimensions":[]},"630449":{"id":630449,"table_id":316,"display_name":"ClientName","base_type":"type/Text","semantic_type":"type/Category","has_field_values":"list","name_field":null,"dimensions":[]},"9162":{"id":9162,"table_id":301,"display_name":"Date","base_type":"type/DateTime","semantic_type":null,"has_field_values":"none","name_field":null,"dimensions":[]},"630427":{"id":630427,"table_id":315,"display_name":"Date","base_type":"type/DateTime","semantic_type":null,"has_field_values":"none","name_field":null,"dimensions":[]},"630424":{"id":630424,"table_id":315,"display_name":"Industry","base_type":"type/Text","semantic_type":"type/Category","has_field_values":"list","name_field":null,"dimensions":[]}},"last-edit-info":{"id":2,"email":"aterrien@dial-once.com","first_name":"Audrey","last_name":"Terrien","timestamp":"2021-10-28T13:31:04.624033Z"},"parameters":[{"slug":"date_filter","default":"past30days","name":"Date Filter","type":"date/all-options","sectionId":"date","id":"999fbf09","field_ids":[630439,630427],"field_id":null,"hasOnlyFieldTargets":true},{"name":"Industry","slug":"industry","id":"a7e9a6b9","type":"category","filteringParameters":["96a727a5","963cf74e"]},{"name":"companyName","slug":"companyname","id":"8044bc2f","type":"category","filteringParameters":["a7e9a6b9","999fbf09"]}],"created_at":"2021-09-09T15:34:22.074927Z","public_uuid":null,"points_of_interest":null}

5

@lgeran Question 94 is on the dashboard - funnelsms (Mystery Dashboard)
And it's also referenced as a Click Behavior in question 104, which is called Number of Unique callers or Unique callers volume

So you are seeing issue https://github.com/metabase/metabase/issues/15368 - upvote by clicking :+1: on the first post

6

Thanks @flamber ! :+1: