DavidChurchman Coach

I also think this would be nice. It could use the same language as the "Any of these are true" option on the filter block in magic ETL. You could present users with groups of filters, and they could switch between "any" and "all". In the meantime, you could achieve something similar with a variable, and link that variable…

Looks like you're missing "END" in the second formula

I don't think you want 'graph by' since it's not really a time series. You're using the year as a categorical variable and applying it as the series value. I would get rid of the 'graph by', and then double check your sorts

What you're describing is an "inner join". You can do it in Magic ETL: https://domohelp.domo.com/hc/en-us/articles/360044876194-Magic-ETL-Tiles-Combine-Data or DataFusion: https://domohelp.domo.com/hc/en-us/articles/360043428293-Combining-DataSets-Using-DataFusion DataFusion is simpler. All it does is join the data. Magic…

There's no " over(partition by)" in BeastMode I'm not a fixed function master, but I'm pretty sure you just need "BY". This user says FIXED BY is the same as ORDER(PARTITION BY) https://dojo.domo.com/main/discussion/55689/fixed-functions-are-difficult-to-understand-and-should-be-rolled-into-window-functions

You could concatenate the months of the two columns, and then use the "contains" filter. For example, the cell value would be "May, June" (concatenated from the two date columns), and the filter would be "Contains May"

I think the math isn't that hard to get week differences, you just need to multiply the years by 52. ( LEFT(YYWW_date_1, 2)*52 + RIGHT(YYWW_date_1, 2)) - ( LEFT(YYWW_date_2, 2)*52 + RIGHT(YYWW_date_2, 2)) For your 2301 - 2244 example, that would be (23*52+1) - (22*52 +44) = (1197) - (1188) = 9 Caveat: I'm pretty sure…

@ST_-Superman-_ Setting 'color rules' doesn't bother me* but being able to format or position the legend of multiple graphs independently would be nice. Like have a legend spanning across multiple cards. * I would like more flexibility, like being able to re-order them, or color one variable based on the values of another…

Linking to sections would be great!

Yes, this would be good. Then you can use the viz as an icon for an overview page

You should be ale to eliminate the null option with a card level filter. For single-selection, I think you want the radio-button, not the slicer. For default filter, I am not certain, but I think if you add what you want the default to be to the default filter view, and then users should be able to use the radio to switch…

If you are wanting to add and subtract columns, it sounds like you do want to join the datasets based on the row numbers of each dataset. This seems more appropriate for ETL than within the card building

I came here with the same question, and there is an option to disable these icons now, in the filter option menu of the wrench menu of the dashboard.