Best Of

Yes you can do it in a beastmode.

LEFT(`FSJ No.`,4)

Then bring that field into your table twice, once without modification and once as a count aggregation.

@laurenmiddleton You can do magic ETL or SQL to split the column into two columns. You can then count the column using distinct first 4 numbers using group by or maybe you can pivot the distinct 4 digits if the data is not too complex to list the all the project codes and count.

You can also create a beast mode calculation LEFT(Key, 4) to create a key column and then perform Magic ETL 'group by' on the 'key ' column and count to reduce the rows.

I don't know about whether it does it "easily".

You would need to create a table in Domo where users can select date comparisons between two periods and see the data along with the percentage change.

Create two Beast Mode fields to capture the start and end dates for both periods.

CASE WHEN `date` BETWEEN '2024-09-01' AND '2024-09-05' THEN 'Period 1'

     WHEN `date` BETWEEN '2024-03-12' AND '2024-03-20' THEN 'Period 2'

ELSE 'Other' END

Create filters for date selection using Domo’s interactive filters for users to select the date ranges. Set up two date range filters, one for each comparison period.

SUM(`GMV`)

Create separate Beast Mode calculations to sum GMV for each selected period.

-- GMV for Period 1

SUM(CASE WHEN `date` BETWEEN '2024-09-01' AND '2024-09-05' THEN `GMV` ELSE 0 END)


-- GMV for Period 2

SUM(CASE WHEN `date` BETWEEN '2024-03-12' AND '2024-03-20' THEN `GMV` ELSE 0 END)

Create a calculation for percentage change..

(SUM(CASE WHEN `date` BETWEEN '2024-09-01' AND '2024-09-05' THEN `GMV` ELSE 0 END) -

 SUM(CASE WHEN `date` BETWEEN '2024-03-12' AND '2024-03-20' THEN `GMV` ELSE 0 END))

 /

 SUM(CASE WHEN `date` BETWEEN '2024-03-12' AND '2024-03-20' THEN `GMV` ELSE 0 END)

 * 100

Then setup the table visualization, probably a pivot table. Add you date range filters to the card.