-
How to make FILTER ALLOW clause dynamic?
Hello all, I want to make it so that a user can decide on what columns that a particular chart could be filtered on. For example: SUM(SUM(Website Engagements)) FIXED (FILTER ALLOW (case when Allow Filtering - Website = 'Mobile Device Type' then Mobile Device Type else Mobile Device Type end)) This is a fixed function with…
-
Fixed Function Problem
Hello, I have an issue that I'm working through in which I want to essentially group by two columns and find the average rank in that grouping. I then want to filter this rank to be less than 3 and count the total rows from this. All in a beastmode. The SQL behind this looks like the following: SELECT Count(*) from (SELECT…
-
Fixed Function - More complicated function
Hello, I keep getting an error when I am trying to do this equation: SUM((SUM(Website Engagements) / SUM(Page Views)) fixed (filter none)) It works when I just have: SUM(SUM(`Website Engagements`) fixed (filter none)) But I do need to divide the total sum of website engagements by the total sum of page views with the…
-
Buzz only for Admins
Hello, our company would like for the ability to have buzz turned on only for admins since data privacy at our company won't allow it.
-
Dataflow or View Query to run AFTER user filter pages
Sometimes it can be really difficult to build an end dataset that will be able to calculate the metrics that my users care about on the fly in a beastmode. For example: This contains 3 different fixed functions so that I can show a certain metric dynamically to the user. Because of the high computation (mixed with a big…
-
Granularity Issues in Domo
Hello, I have a dataset that I'm working with that has my data at a granularity that is quite large. I then want to be able to group that by each individual session that happens on our website and sum the total time spent for that session. I then want to take the average across all sessions. But I want to be able to do…
-
Regex Replace Issue
Hello, I'm trying to do a regex replace to grab a combination of letters and digits but throw out the rows where I don't get anything. Here is my formula: case when REGEXP_LIKE(`Asset name`,'^.*([a-z]{4,5}\d{6}).*$')=1 THEN REGEXP_REPLACE(`Asset name`,'^.*stc=?([a-z]{4,5}\d{6}).*$','$1') else NULL end To explain, I'm…
