VictorLuiz Member

Hi @MichelleH, Just for the record, if anyone faces the same situation as me, I solved using two functions. By relating New_York and Sao_Paulo it solved the time zone problem but it didn't bring up the correct time, so I just adjusted it by adding the time difference in seconds.

I'll check with the DOMO owners, but it's probably set to US time zone. In this case, is there any way to get around this problem without changing entire DOMO time zone?

Server date and time:

Hi John, Yes, the DateTime column shows date, hours and minute. I used the Beast Mode to extract only the date an it worked, thank you for the tip. Regarding my first question, I tried to adding the consumption column directly in database but when I select to show total row it still doesn't working.

Perfect, thanks for the solution and the quick response!

Yes, follow the printscreen. I don't know if it impacts, but the values are calculated in Beast Mode:

Have zeros completing the number, but they already come with. I tried with LPAD() and the matched rows were reduce to 112k. I don't know if it's related, but I brought the data from SAP by federated connection, so I created a view of this dataset.

Thank you for help. I tried to uso TRIM and UPPER and the matched rows jumped from 87K to 94k. I inclued the REPLACE(fieldname, ' ', '') as well, to remove all leading spaces, so jumped to 134k. It's far from the real match rows number, but looks like it is a format divergence. Checking the data in the table I didn't see…