Kunal Member

@MarkSnodgrass In this solution, left joining the distinct date dataset with the main dataset won't date every day for each product. Do you have any other way to do it?

Hi Rupinder, you will have to use DOMO's new Variables feature to get this done. You will have to link each column with each variable basically. Follow this video and you pretty much have to replicate how they created BM Dimension

That's what my data looks like and I'm plotting Account Balance vs Batch Date

@MichelleH actually that's one of the suggestions I got from Rob and tried it to see if it works. But currently, I'm not sorting anything on the card and I'm still having this issue

Hi @MichelleH , so I'm dealing with cumulative data where I need to sum up each row and for that, I need to use the rank & window. That's where I'm sorting it by dates and aggregating the amount column by sum

@RobSomers I tried to sort it by Batch Date on my card but the repetition of weeks is still pertaining. I see this issue when I'm trying to view it per month too

Thanks, Superman ! :D This was helpful

Here you go !

Thanks for your response, Rob. I'm actually kinda sorting it because I'm using the rank and window function to get the cumulative values (by sorting on dates). And then plotting the cumulative values against the dates. So I don't think I can remove the sorting.

Hi @MichelleH , I'm trying to write a generic logic that would just let me remove all the columns with no values and something which I can use on other datasets too. I'm trying to avoid using the Select tile because I have 100+ columns and I'm trying to find a way to not do it manually

Only if you can find a way to link those two tables which I believe you don't have right now. There are two ways to do it Create a new table with all the courses and their IDs. And then link this table to your certificate table (This will only work if the Course ID is derivative from the Course Name) Create a new column…