Lu_zhang Member

yes, thank you. I am requesting access to my company DOMO admin. hope I will get access. thank you.

@ArborRose thank you, and could you pls show me where is the function by detailed?

so great!!! I need time to digesting all of these above. thank you very much. you are such a great man! @Jonathan53891

@Jonathan53891 the dynamic one. Can you pls help? thank you!

feel like it opens a new beast mode world to me! really useful and solved the problem which had kept bothering me a lot recently! @ColemenWilson THANK YOU VERY MUCH

@ColemenWilson I make it by count(快递单号)/sum(COUNT(快递单号) fixed ()). I'd like to say you are so great a beast mode man!! Even though I've made it, I do not understand the design especially fixed (). My understanding it is fixed by (Province） can you pls explain some to me on it? thank you very much.

@ColemenWilson can you help look why it doesn't work for me? thank you so much

I had found line +100% stacked bar chart before posted this help. but still failed. I realize right now that each of the column doesn't have the series probably is the problem point, which you've already pointed out to me. thank you so much for reminding me at the beginning. when I first time read your below picture's…

@MichelleH I don't find it "Series on left scale" (found under General chart properties) , please see above picture. Need help. what's wrong with it?

thank you @MichelleH

can you pls show me how to use ETL to convert? I do not quite understand how to do it. thanks @ColemenWilson another question. when I want to @ someone, It always doesn't pop out the name list. I appears like ' @Colemen', not like ' @ColemenWilson '. I need to try many times then get the one just for one time at random. Do…

It‘s you again. thanks for your help again. can you pls show me how to use ETL to convert? I do not quite understand how to do it. thanks

thank you very much

I think It probably is the point. Can you pls teach me on how to write CONVERT_TZ function? My raw data's timezone is UTC + 8:00(Beijing time), My company timezone in DOMO is UTC - 4:00(New York time). @GrantSmith thank you so much

@david_cunningham pls see attachment. hope it is clear. looking forward to you reply. thank you so much.

@ColemenWilson Hello coach, can you help me on below? thank you in advance. I made a little change on the design because I want the distinct count for 所在库位（the Chinese means each storage location's name) to be shown as pallet quantity. there are 3 types of 所在库位，large size, middle size and small size. for large size, 1…

@david_cunningham I've tried this approach and I am being shocked. It is so great way! VERY FAST! thank you!

@david_cunningham Thank you for the enlightment. Can you show me how to design QUERY() function in Google Sheets alongside ArrayFormula()? This way looks automatic with small manual workload, but I failed to design it.

It really works, thank you!!

@ColemenWilson I created the new beast mode Average storage location quantity=AVG(Storage location quantity) the previous beast mode I've created is Storage location quantity=COUNT(DISTINCT 所在库位) In 'Summary Number' area, when I select 'Use All Values', column 'Average storage location quantity', the result in 'Summary…

thank you. I am asking my DOMO administrator to update my user. @ArborRose 3PL send me daily storage data, in the file, each sheet reflects that day's data, for example, sheet '4.26' reflect 26th April data, sheet '4.25' reflects 25th April data. those sheets are accumulated in one file called 'month to date' storage…

@ColemenWilson thank you, i find the google sheet following your reply. 3PL send me daily storage data, in the file, each sheet reflects that day's data, for example, sheet '4.26' reflect 26th April data, sheet '4.25' reflects 25th April data. those sheets are accumulated in one file called 'month to date' storage report…

thank you, i find the google sheet following your reply. 3PL send me daily storage data, in the file, each sheet reflects that day's data, for example, sheet '4.26' reflect 26th April data, sheet '4.25' reflects 25th April data. those sheets are accumulated in one file called 'month to date' storage report with each day's…

@ArborRose where is the toolkit function for Schema Management? thanks,

Here ‘Details’， I failed to find my google sheet, but I am sure I have it.. I tried select discovery, search or spreadsheet ID, none is okay, do you know what the possible problem is? thanks

It works. thank you. On 'summary number' area, I'd like to show the average of each day's distinct count, how can I do it? Now i can only have the distinct count of the whole month's data as below picture shown, I want the daily average of each day's distinct count.