Best Of
Re: Drill Path from same Dataset returns zero value
I think I understand what's going on now. The activity log doesn't tell you which card is part of which page.
Are you wanting to count a page view as a card view? Card Views are only counted when a user views the detail view of a card and not when it's displayed on a page.
If you're wanting to count just the card detail views in your drill path you'd need to combine the activity log and the cards + pages dataset together based on the card ID and the object ID and making sure to filter for only CARD types. Then you'd need to rename the Page Name field to the same name as the Activity log field for the page (Object_Name). This would then allow you to filter in the drill path on the same name and pull all card view activities to calculate.
Re: Datediff per month
Hi @user046467
You'll want to use PERIOD_DIFF instead of DATEDIFF:
PERIOD_DIFF
Returns the number of months between months in two date columns. For this to work, the date values must be months in the format YYYYMM.
PERIOD_DIFF('Month 1', 'Month 2')
Re: Drill Down From Summary To Detail Records
You can use them on Domo pages and dashboards. It'd take you to a separate card and not drill directly in place / filter your dataset on that dashboard.
Re: Drill Down From Summary To Detail Records
Using Pfilters to Apply Filters from URL Query Parameters to Embedded Dashboards
This knowledge base article outlines the process and the format of the pfilter get parameter in your URL.
Re: Pacing Card?
@MarkSnodgrass that is awesome! thank you. I built it out and it's basically says the same story. It's not what I had built in the past, but it will definitely work. Great explanation. That was easy to follow.
Re: Pacing Card?
One way that I handle this is to use the period over period card and set the date range to This Month and graph by Month and compare to 1 Month Ago. Then, to keep the previous month to only showing its total to the same amount as where the current month is at (i.e. compare through the 17th for each month) I create a beast mode like this:
(CASE WHEN DAYOFMONTH(`date`) <= DAYOFMONTH(CURRENT_DATE()) THEN 'Include' ELSE 'Exclude' END)
I then put this beast mode in the filter and filter to include. This should show you how your are pacing in the month.
Re: Subtracting Dates Based on Other columns
Hi @user027926, you'll need a combination of window and date diff functions in order to calculate the difference between the two dates. You will need to ask your Customer Success Manager to "enable window functions in beast modes" in order to make use of this.
A bit of food for thought also, doing something like (CASE when 'Order' = 2 then 'Date Ordered' END) - (CASE when 'Order' = 1 then 'Date Ordered' END) won't work as beast modes are calculated on a row basis. With this beast, either there will be values from Order 1 or 2 but won't have both captured. As a result, you'll have a value and NULL per row and also subtracting null from anything will give null, resulting in a blank output.
amehdad
Re: Domo - delete data
I would add that after writing it to another dataset, you can request for those rows to be deleted via Domo Support.
amehdad
Re: Some content is too tall to export
Hi @DP_DynamicData, you can email the page. The stories/dashboards turn out quite nicely when in the email format. You would email to yourself first and then, after some optional editting and messaging, you can send through to external users.
To address the message you get, you can add border elements to sub-divide your dashboard. This would make it easier to know which heights of tables etc need to be reduced.
amehdad
Re: Turnover calculation query
Hi @Abhijith, as you already have the total 'Employed' and total 'Terminated' from the initial ETL, there's no need for another ETL.
It appears you are after rolling aggregates, so I suggest you look into these great write-ups, as a start, from @GrantSmith:
https://dojo.domo.com/discussion/52681/domo-ideas-conference-beast-modes-running-totals
https://dojo.domo.com/discussion/52679/domo-ideas-conference-beast-modes-rolling-averages
amehdad


