Best Of
Re: Rank and Window? Lag?
The Lag function should be used to add a column to hold the prior quarter expenses. In your first screenshot, name your new column "Previous Quarter Expenses" (or something similar), change the function drop-down to "Lag", run the function on your current quarter expense column, with an offset of 1.
Once you've created this column, then I would add your variance calculation as a beast mode in your card like this:
(sum(`Current Quarter Expenses`) - sum(`Previous Quarter Expenses`))/sum(`Previous Quarter Expenses`)
Re: Card Filter Issue
This is caused because your dataset is too large. An option is to put your field in your Optional Group By to consolidate the duplicates and set it to be a MIN or MAX aggregation.
Re: What are the best options for concerns about co-mingled data
Hi nwentzel,
I consulted with a company that provided BI as a service and hosted data of many companies in a single instance. They utilized PDP, strict sharing processes using group sharing only (Ex. Group Name = 'Walmart'), publication groups, Domo everywhere, sandbox/publish and more.
It may be helpful if I had a bit more context on what their main concerns are and how you are currently handling their data.
Re: What are the best options for concerns about co-mingled data
PDP is typically an option to help keep data separated and filtered so other users can't see data within the same dataset.
Another alternative is to use child instances to separate all data between users and have users login directly to a child / publish instance.
Re: How to add gross profit row into profit and loss pivot table
We created something similar for our P&L where we needed to show net income or ebitda… we did this by creating a beastmode field to calc the two based on subtracting or adding revenues vs expenses and created a filter to toggle the grand total between the two.
jguzman
Re: To be able to filter in the Webform while in edit mode.
The ability to sort while editing a webform would also be beneficial!
akeating
Re: Can there be a filter in the Webform while in edit mode.
Currently, filtering in webform edit mode is not supported. You can create a new idea in the ideas exchange if one does not already exist.
brycec
Re: WEEKOFYEAR() should be removed from the approved function list or it's behavior should be changed
I agree with you that it doesn't appear to operating the same as the indicated definition in the formula editor. I would suggest sending it in as a bug to support@domo.com and see if they will fix it. In the meantime, I would use WEEK() as you definitely have more control with the extra parameter options.
Copying Value from a Table Card
How do I allow values from cells in a Table card to be copied? At the moment there no option to highlight the text and if you right click on the cell it only shows options to save image.