Table, compare several month-over-month
This seems to be similar to the thread located here, but a little more extensive as we're looking to create a table that would compare several months as opposed to just two.
https://dojo.domo.com/t5/Card-Building/hello-how-to-compare-month-to-month-with-secondary-axis-in-card/m-p/38214#M5099. And it looks as if a table is/was being planned but don't see that it's launched at this time (https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Building_Each_Chart_Type/Period-over-Period_Charts)
So, wondering if either of the solutions (beast mode or SQL/ETL) in that thread, or something entirely different, can accommodate MORE than 2 dates in a single row of data to compare several months, showing total discrepancies along with the percentage difference from the previous month. The month over month bar chart doesn't seem to be able to visualize what we need, and hoped maybe it can in a table.
We want to show, from left to right, CURRENT MONTH (December) data w/PRIOR MONTH (November) percentage variance, then November compared to October, & October compared to September. The column to the left would be by company/organization along w/current month, # of discrepancies, & the % change over the previous month. Then it would continue, left to right, for the previous 3 months from the current month.
Can this be done?