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}}}}]