-
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…
-
Sharing Filter Views despite dashboard page lock
We have a highly viewed dashboard that we have locked so that people can't change. People want to create filter views and then share them with other people. Unless you are an admin or have the grant of "Manage all cards and pages" (which is a security liability) then they can't share it. Therefore, I propose: The ability…
-
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…
-
Dynamic Variables should dynamically change formatting as well
Our company loves the beta of variables. We are able to create charts now where our users are able to change the dimensions and metrics they want on the fly. Our only problem is that we aren't able to dynamically change the format of that metric. So if our stakeholders select Business Area and they want to see the total…
-
Certification Process Updates
I have a range of feedback to Domo to improve their certification process: Don't attach the Certification blue checkmark to the title of the card. There are times that we don't use the title of the card in our dashboards to make it more aesthetically pleasing. It would be great if we can choose the color of the checkmark…
