Lu_zhang Member

https://community-forums.domo.com/main/discussion/comment/97074#Comment_97074 yes, thank you. I am requesting access to my company DOMO admin. hope I will get access. thank you.

https://community-forums.domo.com/main/discussion/comment/97055#Comment_97055 @ArborRose thank you, and could you pls show me where is the function by detailed?

https://community-forums.domo.com/main/discussion/comment/96746#Comment_96746 so great!!! I need time to digesting all of these above. thank you very much. you are such a great man! @Jonathan53891

https://community-forums.domo.com/main/discussion/comment/96626#Comment_96626 @Jonathan53891 the dynamic one. Can you pls help? thank you!

https://community-forums.domo.com/main/discussion/comment/96397#Comment_96397 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.

https://community-forums.domo.com/main/discussion/comment/96352#Comment_96352 @ColemenWilson can you help look why it doesn't work for me? thank you so much

https://community-forums.domo.com/main/discussion/comment/96264#Comment_96264 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…

@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?

https://community-forums.domo.com/main/discussion/comment/96219#Comment_96219 thank you @MichelleH

https://community-forums.domo.com/main/discussion/comment/96228#Comment_96228 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 '…

https://community-forums.domo.com/main/discussion/comment/96232#Comment_96232 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

https://community-forums.domo.com/main/discussion/comment/96159#Comment_96159 thank you very much

https://community-forums.domo.com/main/discussion/comment/96143#Comment_96143 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

https://community-forums.domo.com/main/discussion/comment/95687#Comment_95687 @david_cunningham pls see attachment. hope it is clear. looking forward to you reply. thank you so much. https://us.v-cdn.net/6032830/uploads/GMTF21MTDCQ7/mock-up-20240509-for-domo-summary-number-issue.xlsx

https://community-forums.domo.com/main/discussion/comment/95357#Comment_95357 @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…

https://community-forums.domo.com/main/discussion/comment/95588#Comment_95588 @david_cunningham I've tried this approach and I am being shocked. It is so great way! VERY FAST! thank you!

https://community-forums.domo.com/main/discussion/comment/95414#Comment_95414 @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.

https://community-forums.domo.com/main/discussion/comment/95357#Comment_95357 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…

https://community-forums.domo.com/main/discussion/comment/95330#Comment_95330 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.…

@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…

https://community-forums.domo.com/main/discussion/comment/95277#Comment_95277 @ArborRose where is the toolkit function for Schema Management? thanks,

https://community-forums.domo.com/main/discussion/comment/95216#Comment_95216 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

https://community-forums.domo.com/main/discussion/comment/95214#Comment_95214 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…