-
Case when.. multiple parameters
I would like to make a beastmode for a column that contains integers, as well as null values instead of zero. However, my current formula returns null as zero, but the metric that i use is for purchase price variance, and one of my accounts has duplicate values for invoice price and ppv. For example, it would show $65.00…
-
Story Page: Make note card that stores historical data and filters with page date filter?
I am building a story page for a weekly situation report, that used to be on an excel file. The file stores historical data, but also includes a comments section that can be looked back at. How can i make a note card/document card that my controller can make notes in every week that has a date filter so that historical…
-
Configure two differently labeled date categories to filter together?
On my story page, i have a card that measures the date metric as "closed date", but i use a date filter card that filters the rest of the cards on the page for a weekly report. When i try to filter by this date, the card does not work and gives me false information. I want to make it so that i don't need to add another…