Sean_Tully Contributor 
-
Re: Create a Line Chart that shows the different series while also showing the aggregate of the series?
I think @GrantSmith's suggestion is probably the best way to do this. If you only have a few country values in your dataset, though, you could also do this by building beast modes for the metric for …2 -
Re: Using beast mode to compare strings
The upper function just helps standardize the strings so that they'll match even if they have different cases within the data. For "matches field 3" you would just add another line to ident…2 -
Re: Using beast mode to compare strings
I'd probably do something like case when instr(upper(`field2`), upper(`field1`)) > 0 then 'Looks good' else 'Looks bad' end2 -
Re: Dashboard Table using previous day values in calculation
I would probably do this in Magic ETL. You can use a window function tile to lead the next day's tank level, which would allow you to do the math in your screenshot. I think you can also use lead fun…1 -
Re: Filter in magic ETL
I think David's reply is correct if you don't have a rank field yet. If the rank field already exists, you instead would have to group by the id to find the max(rank), and inner join that back to the…3
