Preserve the dynamic page date filter while calculating the aggregate results of diff dates fields.

pimogo · May 2023

So my question is essentially this: I have two totals i wish to use for a calculation. The problem is that each total is arrived at using different date fields. If I didn't want to retain the functionality of the date page filter, I could do that in beast mode, but i'd like to exhaust the possibility of retaining that functionality first.

Example:

SUM(total1) filtering on Date Field 1

Divided by

Sum(total2) filtering on Date Field 2

I could get around this problem if i could reference the totals from two different cards in say, another card or text object; however, I don't think that is possible.

any thoughts?? thanks!!

GrantSmith · May 2023

You could possibly use a FIXED function and the FILTER ALLOW clause to only allow filtering on a specific date field when calculating your totals.

Here's a link to documentation on FIXED function: https://domo-support.domo.com/s/article/4408174643607?language=en_US

GrantSmith · May 2023

You could possibly use a FIXED function and the FILTER ALLOW clause to only allow filtering on a specific date field when calculating your totals.

Here's a link to documentation on FIXED function: https://domo-support.domo.com/s/article/4408174643607?language=en_US

pimogo · May 2023

Thanks GrantSmith - I'll look into those options.

Beast Mode

Beast Mode

Preserve the dynamic page date filter while calculating the aggregate results of diff dates fields.

Best Answer

Answers

Welcome!

Welcome!

Quick Links

Categories