Comments
-
Have you tried the grouped bar + line chart type? Your data does need to be structured a certain way to get that to work EDIT: I meant grouped, like @Juliann_Potter recommended.
-
I've done this before but by concating fields from Domo into the URL of the system, like companyid.netsuite.com/customer/DOMOFIELD. Those specific systems had the IDs of the things in the URL so it was just a matter of recreating the URL syntax in Domo
-
For previous year to date, I do: "Case when Date >= DATE_SUB(CurrentDate, interval 1 year) and Year(Date) = Year(DATE_SUB(CurrentDate, interval 1 year) ) then Value End" Find the year value of today's date 1 year ago and only selects dates less than or equal to today 1 year ago.
-
I believe it will keep 9/01 open and then also have 9/08 open. I submitted an Ideas Exchange topic about auto-collapsing:
-
For previous year to date, I do: "Case when Date >= DATE_SUB(CurrentDate, interval 1 year) and Year(Date) = Year(DATE_SUB(CurrentDate, interval 1 year) ) then Value End" Find the year value of today's date 1 year ago and only selects dates less than or equal to today 1 year ago.
-
Agreed, I ran into this issue yesterday and was frustrated I couldn't do this. Great request @marcel_luthi!
-
Why are you using the LAST_DAY beast mode here? That will make all of the dates the last day of the month that they're in.
-
It's irritating that NULL values tend to break math
-
Do you need the card to respond to page filters/date range? Because you could sum up the ChildPN's active qty in the dataflow and then join it back on and then filter on that? (Which based on your question, I think you do). Could you remove the line items from this view, filter the ChildPN here and then have a drill that…
-
If I remember correctly you'll need to link pages to cards to datasets, which can cause some cardinality issues, but then you can also credit a card/dataset when a page gets viewed vs. just when a card gets viewed.
-
Agreed with the others, I don't think you need the FIXED portion, as just a count(distinct) should filter it out. I had a client who did something similar and it worked great.
-
Agreed, I've done dynamic column renaming using a Stored Proc in a MySQL dataflow - you can query the system tables to get the schema.
-
What does the card look like? Do you need the partition? If the card is using ChildPN on it you can just do a sum and then then filter on that.
-
Actually, no that's wrong. There's already an IN in pfilters. I'm not sure how contains functions.
-
The documentation is here: If I remember correctly, it functions similar to an "in." So contains ("ItemA", "ItemB", "ItemC") means if it's Item A, B or C it will filter.
-
I know some Bar graphs do, but it's only like "most recent month's value"
-
Are any actions captured in the activity log?
-
In this case I'd join to the date dimension, find all of the days between TimeOffDate and ReturnToWork and split the HoursOff between them. Similar to this:
-
I'm not sure on this - I'd try reaching out to support and see if they can assist.
-
Do you need to enable API/Connector access in Clarizen?
-
What fields do you have? Do you have customer start date and customer end date? You might have to do it in a dataflow, join it to a data dimension and you could calculate for each month whether a customer was active or not.
-
I think only certain types of cards allow non-summary member alerts, but I've always just used summary numbers for alerts so I'm not positive. I usually just create separate cards just for having summary number based alerts
-
What kind of data do you have? Do you have customer acquired/customer lost dates? You can join to a date dimension and calculate per customer per month if a customer is active or not.
-
So you have the right idea with your case statement, but that statement executes on a row by row basis, so it's only comparing the date of the row to the MAX(Date) of each row. Add a MaxDate in the dataflow and then do that comparison there.
-
Are you looking to have two separate values for Maintenance and Disruption and have them both displayed? Pie charts only support 1 value at a time. If you want to combine them, you can do a beast mode that is SUM(IFNULL(Maintenance, 0) + IFNULL(Disruption, 0)) and then add that to the pie chart.
-
If I'm understanding correctly, I'd do a group by tile by Site, find the MAX(Latest Updated) and then do an inner join back on Site and MAX(Latest Updated) = LatestUpdated to only get the most recent rows per site.
-
I've seen this most often if you accidentally aggregate an aggregate, like "SUM(Case when X = Y then SUM(Value))" and then try to filter on that
-
DATEDIFF(DATE, LAG(DATE) -1)
-
use a DateDIFF to calculate the number of days between the dates!
-
I've seen this before, usually rebooting the server fixes it.