Tooltip not showing values

aris_pg · May 10, 2021, 11:22am

Hi,

There's no info in some tooltips. Any idea about why it's happening?

This is my diagnostic info:

{
  "browser-info": {
    "language": "en",
    "platform": "Linux x86_64",
    "userAgent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.85 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.10+9-LTS",
    "java.vendor": "Amazon.com Inc.",
    "java.vendor.url": "https://aws.amazon.com/corretto/",
    "java.version": "11.0.10",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.10+9-LTS",
    "os.name": "Linux",
    "os.version": "4.14.173-137.228.amzn2.x86_64",
    "user.language": "en",
    "user.timezone": "UTC"
  },
  "metabase-info": {
    "databases": [
      "redshift",
      "postgres"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "10.4"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.2.18"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2021-04-27",
      "tag": "v0.39.1",
      "branch": "release-x.39.x",
      "hash": "6beba48"
    },
    "settings": {
      "report-timezone": "UTC"
    }
  }
}

flamber · May 10, 2021, 11:36am

Hi @aris_pg
With very little information to go on, it's difficult to know.
Is it a SQL or GUI question?
When did the values disappear?
Are you returning values? Check the table visualization.
Can you reproduce with Sample Dataset?

aris_pg · May 10, 2021, 12:54pm

Hi @flamber,

It's an SQL question.

It desappear in version 0.39. I though it would be solved in 0.39.1 but it doesn't.

Yes, it's returning values

It seems that it's showing only values of graph. It's painting in graph columns 1 and 4, and in tooltip only appears column 1 and 4 values.

Let me know if you need more info.

Thanks!

flamber · May 10, 2021, 4:04pm

@aris_pg
I cannot reproduce.

Nothing gets fixed unless it's noticed and reported - in some case it might be "accidentally" fixed by something else, but we don't want to rely on that, since it would then also means that there are no test cases for such scenario, so it could become a regression.

I have no idea which version you were using previously or how the question is constructed.
Does this happen to all questions (of that type)?
Does changing which lines are shown fixes the missing tooltips?

aris_pg · May 11, 2021, 7:43am

I think question was created in 0.38 version

No, it's not happening to all questions but most of them

Still not working if I change columns or lines shown.

I tried to create question again and it works properly.

flamber · May 11, 2021, 8:28am

@aris_pg Okay, I cannot reproduce by creating a question on 0.38.1 and upgrading to 0.39.1.
We'll need to look at the metadata, so post the output of a question that is causing problem - look in the application database table report_card

aris_pg · May 11, 2021, 8:52am

Here the info:

id	created_at	updated_at	name	description	display	dataset_query	visualization_settings	creator_id	database_id	table_id	query_type	archived	collection_id	public_uuid	made_public_by_id	enable_embedding	embedding_params	cache_ttl	result_metadata	collection_position
587	2020-12-29 18:22:11.619260	2021-05-11 08:08:19.182210	Taps&Sinks - Flow - By User - LW		line	{"type":"native","native":{"query":"with SelCurrency_Data as (\nselect idCurrency\nfrom SelCurrency inner join \nmastergames\non mastergames.id_game = SelCurrency.id_game\nwhere [[{{CurrencyName}} --]] CurrencyName = 'Hard Currency'\nand SelCurrency.id_game = 5\n),\n\nSelProgression_Data as (\nselect idProgress, ProgressName\n\nfrom SelProgress inner join \nmastergames\non mastergames.id_game = SelProgress.id_game\n\nwhere [[{{ProgressName}} --]] ProgressName = 'daysFromFirstLogin'\nand SelProgress.id_game = 5\n),\n\n\nevents_by_date as (\n\nselect date_event, \n\ncase when idProgress = 0 then daysFromFirstLogin\nwhen idProgress = 1 then progress1 \nwhen idProgress = 2 then progress2\nwhen idProgress = 3 then progress3 end \nas progress, \nsum(cast(abs(case when case when idCurrency = 1 then hc\n            when idCurrency = 2 then sc  \n            when idCurrency = 3 then otherc1  \n            when idCurrency = 4 then otherc2  \n            when idCurrency = 5 then otherc3 end  <0 \n            then \n            case when idCurrency = 1 then hc\n            when idCurrency = 2 then sc  \n            when idCurrency = 3 then otherc1  \n            when idCurrency = 4 then otherc2  \n            when idCurrency = 5 then otherc3 end  \n            else 0 end) as float)/numberusers) as sinks,\nsum(cast(abs(case when case when idCurrency = 1 then hc\n            when idCurrency = 2 then sc  \n            when idCurrency = 3 then otherc1  \n            when idCurrency = 4 then otherc2  \n            when idCurrency = 5 then otherc3 end  >0 \n            then \n            case when idCurrency = 1 then hc\n            when idCurrency = 2 then sc  \n            when idCurrency = 3 then otherc1  \n            when idCurrency = 4 then otherc2  \n            when idCurrency = 5 then otherc3 end  \n            else 0 end) as float)/numberusers) as taps,\n--taps - sinks as flow,\navg(numberusers) as users\n\n\nfrom z_taps_sinks_daily \n\ninner join SelCurrency_Data\non 1=1\n\ninner join SelProgression_Data\non 1=1\n\nleft join z_total_users_by_status\non date_event = datestatus\nand statususer = ProgressName\nand case when idProgress = 0 then daysFromFirstLogin\n        when idProgress = 1 then progress1 \n        when idProgress = 2 then progress2 \n        when idProgress = 3 then progress3 \n        end  = valueStatus\n    \nand z_taps_sinks_daily.id_game = z_total_users_by_status.id_game\n\nwhere [[{{date_event}}--]] date_event >= current_date - 60\nand z_taps_sinks_daily.id_game = 5 \nand abs(case when idCurrency = 1 then hc\n            when idCurrency = 2 then sc  \n            when idCurrency = 3 then otherc1  \n            when idCurrency = 4 then otherc2  \n            when idCurrency = 5 then otherc3 end)>0\nand event_name not in (select distinct event_name from z_taps_sinks_daily where [[{{event_name_excluded}} and id_game = 5--]] 1=0\n)\nand progress >= [[{{MinProgress}}--]] 0\nand progress<= [[{{MaxProgress}}--]] 100\n[[and {{event_name}}]]\n[[and z_taps_sinks_daily.daysfromfirstlogin >= {{min_login}}]]\n[[and z_taps_sinks_daily.daysfromfirstlogin <= {{max_login}}]]\ngroup by 1,2\n)\n\nselect progress,\navg(sinks) as sinks,\navg(taps) as taps,\navg(taps) - avg(sinks) as flow,\navg(users) as avg_users,\nsum(users) as users\n\nfrom events_by_date\n\ngroup by 1\n\norder by 1 asc;","template-tags":{"event_name_excluded":{"id":"ec649721-1976-9ff6-6c0f-60307c7d8677","name":"event_name_excluded","display-name":"Event name excluded","type":"dimension","dimension":["field",6031,null],"widget-type":"category"},"min_login":{"id":"ebe7f861-3000-f745-d095-79940a413954","name":"min_login","display-name":"Min login","type":"number"},"ProgressName":{"id":"83dbe026-2c72-8548-1c8a-dab6cf211cb0","name":"ProgressName","display-name":"Progressname","type":"dimension","dimension":["field",6088,null],"widget-type":"category"},"MaxProgress":{"id":"2258faa8-b33e-efa5-6e10-fbb659c416d1","name":"MaxProgress","display-name":"Maxprogress","type":"number"},"date_event":{"id":"9c39398c-3a87-3fa9-8a64-d8c42abc543a","name":"date_event","display-name":"Date event","type":"dimension","dimension":["field",6040,null],"widget-type":"date/month-year"},"MinProgress":{"id":"e538766a-8665-9761-2a6f-d5afd50d270a","name":"MinProgress","display-name":"Minprogress","type":"number"},"CurrencyName":{"id":"6de1b00a-36b4-c46a-6dfa-b98ff5feefa1","name":"CurrencyName","display-name":"Currencyname","type":"dimension","dimension":["field",6047,null],"widget-type":"category"},"event_name":{"id":"588f6b2b-f658-e3e6-1917-5b69d12bd112","name":"event_name","display-name":"Event name","type":"dimension","dimension":["field",6031,null],"widget-type":"category"},"max_login":{"id":"1c80ba16-1563-2362-03c6-65f5197b1c9c","name":"max_login","display-name":"Max login","type":"number"}}},"database":2}	{"graph.show_goal":true,"graph.show_values":false,"graph.goal_label":"","graph.x_axis.axis_enabled":"rotate-45","graph.goal_value":0,"card.title":"Flow - By User","graph.label_value_frequency":"all","graph.metrics":["flow"],"graph.label_value_formatting":"auto","series_settings":{"flow":{"color":"#EF8C8C"}},"graph.x_axis.scale":"ordinal","graph.dimensions":["progress"]}	18	2		native	false	109			false			[{"name":"progress","display_name":"progress","base_type":"type/BigInteger","field_ref":["field","progress",{"base-type":"type/BigInteger"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":51,"nil%":0},"type":{"type/Number":{"min":0,"q1":12.25,"q3":37.75,"max":50,"sd":14.866068747318506,"avg":25}}}},{"name":"sinks","display_name":"sinks","base_type":"type/Float","field_ref":["field","sinks",{"base-type":"type/Float"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":51,"nil%":0},"type":{"type/Number":{"min":4167.350759487733,"q1":18873.345987266875,"q3":28034.919276477835,"max":38231.82018140589,"sd":7195.451001532149,"avg":23287.453042009136}}}},{"name":"taps","display_name":"taps","base_type":"type/Float","field_ref":["field","taps",{"base-type":"type/Float"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":51,"nil%":0},"type":{"type/Number":{"min":7065.344043992141,"q1":19711.33541525683,"q3":28593.62113858364,"max":38264.41580215419,"sd":6893.933213444637,"avg":23996.94251002371}}}},{"name":"flow","display_name":"flow","base_type":"type/Float","field_ref":["field","flow",{"base-type":"type/Float"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":51,"nil%":0},"type":{"type/Number":{"min":-2664.373084886127,"q1":-727.33872830356,"q3":1984.7196576479128,"max":4391.330357142855,"sd":1936.382155424872,"avg":709.4894680145793}}}},{"name":"avg_users","display_name":"avg_users","base_type":"type/BigInteger","field_ref":["field","avg_users",{"base-type":"type/BigInteger"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":19,"nil%":0},"type":{"type/Number":{"min":2,"q1":3.3131126469708994,"q3":9.75,"max":664,"sd":93.92504312210984,"avg":24.07843137254902}}}},{"name":"users","display_name":"users","base_type":"type/BigInteger","field_ref":["field","users",{"base-type":"type/BigInteger"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":46,"nil%":0},"type":{"type/Number":{"min":58,"q1":89.25,"q3":299.5,"max":19946,"sd":2821.102526234985,"avg":730.2352941176471}}}}]

flamber · May 11, 2021, 9:24am

@aris_pg That question has either been created or modified on 0.39.
Can you post metadata for a problematic question, which was created on 0.38 and not updated?
And then create the a similar question on 0.39, which works, and also post the metadata for that?

aris_pg · May 11, 2021, 9:49am

This is the question that is giving problems. I didn't remember exactly when was created.

This is the same info for the correct question

id	created_at	updated_at	name	description	display	dataset_query	visualization_settings	creator_id	database_id	table_id	query_type	archived	collection_id	public_uuid	made_public_by_id	enable_embedding	embedding_params	cache_ttl	result_metadata	collection_position
932	2021-05-11 09:47:31.759920	2021-05-11 09:47:39.961942	TestCorrect		line	{"type":"native","native":{"query":"with SelCurrency_Data as (\nselect idCurrency\nfrom SelCurrency inner join \nmastergames\non mastergames.id_game = SelCurrency.id_game\nwhere [[{{CurrencyName}} --]] CurrencyName = 'Hard Currency'\nand SelCurrency.id_game = 5\n),\n\nSelProgression_Data as (\nselect idProgress, ProgressName\n\nfrom SelProgress inner join \nmastergames\non mastergames.id_game = SelProgress.id_game\n\nwhere [[{{ProgressName}} --]] ProgressName = 'daysFromFirstLogin'\nand SelProgress.id_game = 5\n),\n\n\nevents_by_date as (\n\nselect date_event, \n\ncase when idProgress = 0 then daysFromFirstLogin\nwhen idProgress = 1 then progress1 \nwhen idProgress = 2 then progress2\nwhen idProgress = 3 then progress3 end \nas progress, \nsum(cast(abs(case when case when idCurrency = 1 then hc\n            when idCurrency = 2 then sc  \n            when idCurrency = 3 then otherc1  \n            when idCurrency = 4 then otherc2  \n            when idCurrency = 5 then otherc3 end  <0 \n            then \n            case when idCurrency = 1 then hc\n            when idCurrency = 2 then sc  \n            when idCurrency = 3 then otherc1  \n            when idCurrency = 4 then otherc2  \n            when idCurrency = 5 then otherc3 end  \n            else 0 end) as float)/numberusers) as sinks,\nsum(cast(abs(case when case when idCurrency = 1 then hc\n            when idCurrency = 2 then sc  \n            when idCurrency = 3 then otherc1  \n            when idCurrency = 4 then otherc2  \n            when idCurrency = 5 then otherc3 end  >0 \n            then \n            case when idCurrency = 1 then hc\n            when idCurrency = 2 then sc  \n            when idCurrency = 3 then otherc1  \n            when idCurrency = 4 then otherc2  \n            when idCurrency = 5 then otherc3 end  \n            else 0 end) as float)/numberusers) as taps,\n--taps - sinks as flow,\navg(numberusers) as users\n\n\nfrom z_taps_sinks_daily \n\ninner join SelCurrency_Data\non 1=1\n\ninner join SelProgression_Data\non 1=1\n\nleft join z_total_users_by_status\non date_event = datestatus\nand statususer = ProgressName\nand case when idProgress = 0 then daysFromFirstLogin\n        when idProgress = 1 then progress1 \n        when idProgress = 2 then progress2 \n        when idProgress = 3 then progress3 \n        end  = valueStatus\n    \nand z_taps_sinks_daily.id_game = z_total_users_by_status.id_game\n\nwhere [[{{date_event}}--]] date_event >= current_date - 60\nand z_taps_sinks_daily.id_game = 5 \nand abs(case when idCurrency = 1 then hc\n            when idCurrency = 2 then sc  \n            when idCurrency = 3 then otherc1  \n            when idCurrency = 4 then otherc2  \n            when idCurrency = 5 then otherc3 end)>0\nand event_name not in (select distinct event_name from z_taps_sinks_daily where [[{{event_name_excluded}} and id_game = 5--]] 1=0\n)\nand progress >= [[{{MinProgress}}--]] 0\nand progress<= [[{{MaxProgress}}--]] 100\n[[and {{event_name}}]]\n[[and z_taps_sinks_daily.daysfromfirstlogin >= {{min_login}}]]\n[[and z_taps_sinks_daily.daysfromfirstlogin <= {{max_login}}]]\ngroup by 1,2\n)\n\nselect progress,\navg(sinks) as sinks,\navg(taps) as taps,\navg(taps) - avg(sinks) as flow,\navg(users) as avg_users,\nsum(users) as users\n\nfrom events_by_date\n\ngroup by 1\n\norder by 1 asc;","template-tags":{"event_name_excluded":{"id":"962b8687-8213-c85f-9ad9-3c369c47d268","name":"event_name_excluded","display-name":"Event name excluded","type":"dimension","dimension":["field",6031,null],"widget-type":"category"},"min_login":{"id":"3dae5e8a-79f8-8a0c-6229-28052f15da6c","name":"min_login","display-name":"Min login","type":"number"},"ProgressName":{"id":"664db3d5-ea90-077e-b394-5021bc5aa977","name":"ProgressName","display-name":"Progressname","type":"dimension","dimension":["field",6088,null],"widget-type":"category"},"MaxProgress":{"id":"1da1c106-3488-157a-ce0f-9e5f0ee5831a","name":"MaxProgress","display-name":"Maxprogress","type":"number"},"date_event":{"id":"c94e3ff4-cbe9-8223-f0ad-307097ee0245","name":"date_event","display-name":"Date event","type":"dimension","dimension":["field",6040,null],"widget-type":"date/month-year"},"MinProgress":{"id":"c2069b0f-8675-978e-26db-16318c2df087","name":"MinProgress","display-name":"Minprogress","type":"number"},"CurrencyName":{"id":"a6ab12da-09f8-bbea-72dc-2d76c2cc3b3d","name":"CurrencyName","display-name":"Currencyname","type":"dimension","dimension":["field",6047,null],"widget-type":"category"},"event_name":{"id":"58f4a79a-cb92-9b09-5d71-abb48f14650c","name":"event_name","display-name":"Event name","type":"dimension","dimension":["field",6031,null],"widget-type":"category"},"max_login":{"id":"ed3e28be-ba3d-fa73-5e23-4649228c0e1e","name":"max_login","display-name":"Max login","type":"number"}}},"database":2}	{"graph.dimensions":["progress"],"graph.metrics":["flow"],"graph.show_goal":true}	2	2		native	false	2			false			[{"name":"progress","display_name":"progress","base_type":"type/BigInteger","field_ref":["field","progress",{"base-type":"type/BigInteger"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":31,"nil%":0.0},"type":{"type/Number":{"min":0.0,"q1":7.25,"q3":22.75,"max":30.0,"sd":9.092121131323903,"avg":15.0}}}},{"name":"sinks","display_name":"sinks","base_type":"type/Float","field_ref":["field","sinks",{"base-type":"type/Float"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":31,"nil%":0.0},"type":{"type/Number":{"min":2.1040817729712256,"q1":3.1445129771921967,"q3":5.467566273195716,"max":21.572497369038878,"sd":4.08416775769818,"avg":5.748161386278578}}}},{"name":"taps","display_name":"taps","base_type":"type/Float","field_ref":["field","taps",{"base-type":"type/Float"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":31,"nil%":0.0},"type":{"type/Number":{"min":2.8952589807852966,"q1":3.266800525094091,"q3":5.71128497617368,"max":26.379722059841363,"sd":4.463528653631442,"avg":5.4859679476991685}}}},{"name":"flow","display_name":"flow","base_type":"type/Float","field_ref":["field","flow",{"base-type":"type/Float"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":31,"nil%":0.0},"type":{"type/Number":{"min":-7.831836728614126,"q1":-1.3880919178452458,"q3":0.6583622624011561,"max":15.319168786162026,"sd":3.7057716050735965,"avg":-0.2621934385794095}}}},{"name":"avg_users","display_name":"avg_users","base_type":"type/BigInteger","field_ref":["field","avg_users",{"base-type":"type/BigInteger"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":21,"nil%":0.0},"type":{"type/Number":{"min":5.0,"q1":6.5885621722338525,"q3":25.0,"max":862.0,"sd":154.42780266700402,"avg":49.70967741935484}}}},{"name":"users","display_name":"users","base_type":"type/BigInteger","field_ref":["field","users",{"base-type":"type/BigInteger"}],"semantic_type":null,"fingerprint":{"global":{"distinct-count":31,"nil%":0.0},"type":{"type/Number":{"min":293.0,"q1":413.0,"q3":1505.5,"max":51750.0,"sd":9268.188567955596,"avg":3000.7419354838707}}}}]

flamber · May 11, 2021, 10:55am

@aris_pg Now I could spot the problem - I've created an issue for it:
https://github.com/metabase/metabase/issues/15998 - upvote by clicking on the first post