Best Of
Re: Replicate Spreadsheet P&L in Domo
If you add a row number column in your ETL you can use it to place a blank row between two other rows. For example, if I want a blank between Revenue and Wages I could assign a row number between them
And then I can hide column 1 in the chart properties:
This would create an empty row:
You can also play around with column widths in the properties but I don't believe you can selectively make certain columns wider or narrower
Re: Is it possible to use PDP to send a card only to people that are part of the card dataset?
Hello @Chris_Phelan,
I believe this is possible if you create an ETL that filters (reduces) your dataset the same way you filter your card and then use it for the PDP.
Re: How to get Prior Year Values on the same table row
Alternatively you can restructure your data so that for each date you have the values for the current date and last year to allow for easier filtering. I've done a write up on how to do this here:
Re: How to get Prior Year Values on the same table row
You can use a beastmode:
LAG(SUM(Value),12) OVER(ORDER BYMonthly Payment Date)
Re: How to show a grouped Column with a CASE logic
Can you give this a try?
SUM(
CASE
WHEN amCollectorPrice > 1 AND nmOrganizer IN ( 'Live Nation 2 s.r.l.' , 'Live Nation 3 s.r.l.' , 'Live Nation 6 s.r.l.' , 'Live Nation Italia s.r.l' ,'Comcerto Srl' )
THEN qtTicket
END
)*2.54
Re: Shopify Products and Product Variants report moving from REST API to GraphQL API
@german_rodriguez - I saw your earlier post where you having trouble. Did you get this working or do you still need help?
Tasleema
Re: Date Range Variables
Currently, variables don't support date ranges. What you'd need is two variables for each date range - a start date and an end date and then compare those in your beast modes.