I want a card with a single line of text. Not a table. This is to act like a caption textbox. To indicate last run. The text is to indicate most recent date within the dataset. Assume there's a column called [date].
Here's the tricky part. This date must be based on the data itself. We have many offices. When filtered to an office, this card needs to show the most recent for the filtered office. When no office is selected, I want it to show the most recent date for the dataset.
In SQL, it would be something like if count(*)=1 then XXX else ZZZ. But I don't know a Domo equivalent to COUNT(*) in a calculated field.