Luděk Janošek
01/31/2023, 10:22 AMSELECT IFNULL(( "metric_code"),0)+0
but then I have 0 for full date dimension, from 1.1.1900 without possibility to filter it by date interval in insight or in dahsboard. (first pic with IFNULL, second without IFNULL).
And second question -> how can I change weekly interval from default Sun-Sat to Mon-Sun? (3rd pic) Thanks 🙏Moises Morales
01/31/2023, 11:00 AMLuděk Janošek
01/31/2023, 11:42 AMJan Soubusta
01/31/2023, 11:47 AMLuděk Janošek
01/31/2023, 2:27 PMLuděk Janošek
02/01/2023, 2:56 PMSELECT 0
. In Canvas I choose Data Labels = hide
and Total Labels = show
. Right, Im loosing values for each metric and have only total value, but I have zeros instead of empty values. It works, but not in all cases. Please, do you anybody knows how to solve it? There must be any solution how to show complete axis in the chart, as like as in Tableau or other simillar platforms. Thanks!Moises Morales
02/01/2023, 3:02 PM