user04285

Hi @Valiant , thanks for replying. The datasource is this Excel file. So basically what we are trying to do is to replicate the data from Excel to Domo. In this case, the data file will be the second tabel on the right and another mapping table that lists: City, category, sub-category, product code (that we can map…

Thanks for the suggestion @dthierjung! It really does the trick. 

Hi @Valiant, thanks a lot for your help. I still need to figure something else, but I think your solution provided some directions. Thanks again!

And also, I tried recreating it but only get the columns stacked, not aligning properly like yours

Hi @Valiant! Thanks so much for your reply! Your chart actually looks close enough to what I need, but can you clarify this: "...The way to do this is to set your Date as your X-axis and then break it into 4 measures using BeastModes." Can you please let me know how to do this? Since I am not at all familiar with this yet.…

Thanks for the reply, @Godiepi. But how do you translate the Fixed function from Tableau in the Domo code? Thanks again!

Hi @Chips, thanks for replying! So here's my ETL flow, and last time I tried it worked, but the output row number amounts up to 4.4 million rows! I have no idea why since the dataset I have with most rows only have 395k rows. I ETL I wonder what causes this to happen? And about your suggestion: "..Make sure there are no…

Just to make myself clearer, I joined the three datasets using Employee Name column.