Comments
-
@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.