Best Of

Re: Data Snapshot

@damen Yes, you can use a recursive dataflow to create your master "snapshot" data. The way you would do this is to add a column to your input data with the current date, then append to the existing output dataset. Here is a KB article about how to set up a recursive dataflow: https://domo-support.domo.com/s/article/360057087393?language=en_US

As for your question about duplicate entries, you can create a second dataflow that runs the snapshot data through a Group By tile to show the original value. Do not do this in the original recursive dataflow since you will lose all the detail data.

MichelleH

1

Re: Data Snapshot

Use the "Dataset copy" connector, take a copy of the original dataset and append it to your snapshot dataset on a quarterly basis. From there you can make an ETL that marks the most recent version of the data as the most recent and use the snapshot date to view history of the date.

trafalger

2

Re: How do I create a card to display the data in this way?

Hi Alex, no problem! I had to get a bit creative with your request, but you are able to achieve this in Domo. One of our table card options is a pivot table. These are great for a lot of things, but most relevant is visualizing data in a more readable format. That being said, they’re typically used in combination with wanting to aggregate some values. To work around this, I got creative with our FIXED BY functions. Here is the sample dataset I was working with:

Screenshot 2023-05-22 at 11.56.50 AM.png

And here is the pivot table view I was able to create:

Screenshot 2023-05-22 at 11.56.12 AM.png

To account for not having any columns we wanted included in our “Values” section (i.e. where you would normally place the cols you wanted aggregated), I created a beast mode that took the max value of your last column (which here I had named “Kind”) and used FIXED BY over all of the columns in your dataset (including “Kind” itself).