Ashleigh Coach

@D-Rab the DomoStats dataset People should only include the users in your instance. If you filter out social user that would be all of your active licenses. The dataset does not keep people in there who are not in the instance anymore. You could join this dataset with the one feeding the cards and only include matches so…

Hi @user05583 what kind of Dataflow is it? Can you provide a screenshot of the Dataflow?

I was able to find some info using the event metrics. 

I already have GA connected using the connector. I have not set up anything yet for quizzes within GA itself. The issue is there is no metric saying "quiz data" or along those lines. I have some dimensions and some metrics for reading page timing, user ID, landing page, etc. I wanted to see if anyone already had a custom…

@StarbucksLover you should be able to do it by using an ETL and setting the column type, there is an option for Date and a method for extracting time. This knowledge base article it kind of similar https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Adding_and_Subtracting_Hours_in_ETL 

The preview option only gives you a select number of rows. IF the preview does not give you enough data to look at when doing comparisons then I suggest putting what I call "probes" in your flow. Basically just add output datasets anywhere you want to check a step and just delete it once you checked it. 

There are dashboards already created for this called Domo Stats. If you look them up in the app store there should be several different ones based on data, people, and projects and tasks. You can also connect to the datasets from the data connector Domo Governance which gives you stats on everything you could possibly need…

I personally never use the equals but always contains and does not contains. Have you tried going to the dataset and copying the text and then pasting that in the filter field? Sometimes there are whitespaces there and just typing them in does not catch them. Also, make sure your column is actually a text field by setting…

@karthik Page filters are unique to each user and can not be shared. Same with a page layout, so if you ever re-order a bunch of subpages that will not effect how other users see it. I would reccommend adding filter cards for people to use because they are easier then adding a page filter. 

@nitot you could use RegEx to replace any text that contains letters from the alphabet with some sort of flag and then you could filter out the flag. If you have any cases that contain both letters and numbers then that solution may not work. 

There is also a description field for columns in the schema section of a dataset. I usually put a little description for the dataset describing what it is and briefly how it was made. It is also nice to have a dataset lineage library using the Domo Governance Datasets. We have a table with all of our dataflows along with…

Which date field are you using in the drop down menu, not the x axis. I provided a photo of what I mean. Also are you sorting the data by anything? If so try removing all of those and see if it fixes anything. 

@user11559 you might want to submit a ticket about it. It does'nt sound like its supposed to be happening. 

@user10780 sorry about that, I did not mean my picture was a solution but rather I was just mentioning you could use RegEx to solve your problem and that was an example of another thing I did. Glad it worked out!

@rdraughn do you hvae multiple date columns in your data? What date range field is selected in the drop box for time range?

@user10780 you can do regex in ETL by using the Replace Text option. Here is an example of one I did. Just make sure the second box has the checkbox Use RegEx checked. 

Are the cards all using the same dataset or different ones? Does your data have any null values?

Okay, try adding the event name or type in the series column. This will basically allow the graph to count the number of events that appear multiple times so the y axis should have the 15. It would show the number of times something occurred which I know you do not want but it would only show if you hover over it. This is…

So just one bar with a count of multiple entries? How are you looking to see the data? I can see this becoming just one very long bar if you have alot of data with multiple entries. 

Also to answer this question: I have a hypothesis: I noticed that there are 130 options in Filter A at the dashboard level, but 140 at my card level. When you are doing page/dashboard level filters, are the only options that appear options that are present in every single dataset on the page? The page filters used to be…

So these same filters are applied directly in analyzer and then you are just applying the same filters at a page level and it filters the data down more even though the same filters were already applied?

I was able to make this beast mode which counts the counts basically. Only thing is you can not filter out the single ones because when you try to filter it they all add up. I am working on that now. case when COUNT(`Event`) > 1 then COUNT(`Event`) else 0 end

hmm filtering those out would be the hard part. At least with the bar graph you could sort it to where single ones would only be at the bottom. 

Try downloading it and then looking, that is usally what I have to do. 

In the photo I provided I added the date filter for 1/1/2019-1/5/2019 so it would exclude the last 3 from my orginal dataset. So the photo showed 2 events happened twice and 1 event happend once. 

@user16839 how are you determining the date range? Are you just filtering the data or are you showing each date range in the card? I am not 100% sure on what you are asking for without being able to see the data so I made some , does it have the right concept?. Here is some photos of what I made, is this something you are…

@user16839 Correct, the calculation would only be a onetime calculation in the ETL, you would have to manually apply the date filter in the beginning. I understand why a beast mode might be more useful. How are you presenting the data? Is it a table or some other chart? You could use the beast mode you have that counts…

@user16839 Does this need to be done in a beastmode? It might be easier to use an ETL. You could use grouping and count the number of times something occurs. You could also use a different card type that would show how many occurances there was in the date range. 

@Nick_ Does your instance have cusotm roles? Some of the custom roles or even some of the Domo roles would overide PDPs if they have accesss to view all data. Also, this may seem trivial but did you hit the enable PDP policy at the top? Could you provide a photo of the actual policy ?

@user11559 Could you provide a photo of what you mean? Also, are you using the standard page filters or the filter cards?