Hi. I'm the admin for the page. If I set the filters, not everyone see them. 

Hello, I had a similar question. Can I delete records from my input dataset, and then use the same dataset (from which I have deleted records) as output. In other words, can I change my input dataset through mysql commands (or even ETL)?

Thanks guys. Have put in a suggestion in the ideas exchange. You guy can vote for it. https://dojo.domo.com/t5/Ideas-Exchange/Insert-vertical-lines-between-cards-while-designing-dashboard/idi-p/45006

There's a pivot table option (beta versio). That will solve this problem. Use the pivot table card. Chart Type > Tables and Textboxes > Pivot Table

That was because I wanted to be able to see all the datapoints, not just top 5. But also have the capability to see top 5, bottom 5. But your idea is also workable. Just a question: from the dashboard, can the user switch between seeing only top 5 and all the data points?

For everyon's knowledge, you can do this by going into the calendar type card, going to Presets View in Chart Properties and selecting "Show Presets Only". This will do the job. Cheers

Hello, In the solution that you give, my initial dataset will still have all the rows. It is only in the next step that I filter, but the initial dataset remains huge. I want to reduce the size of the initial dataset because our organization now has tens of dataflows running (soon to go into hundreds), and we've seen that…

Hello. I was watching a video on Youtube, in which a guy creates a "last 3 months" filter. Although I could not completely understand what he did, do you think using this feature (highlighted in the video) I can make my filter? https://www.youtube.com/watch?v=qc5JqGWtlu8&feature=youtu.be Hamza

Thank you for the help. Although it doesnt tell how many rows were updated in the latest update. I does tell the total number of rows. I can subtract to find out the net change i.e the updated rows

I'm sorry I couldn't get what's mentioned in the thread you posted. So how do we use MYSQL exactly? Here are the steps in my dataflow: Step 1: Amazon S3 connector imports data using the append method. Data goes into a dataset. It has now hundreds of thousands of rows. Step 2: I perform SQL transforms on that dataset and…

Hello, I think the app you're referring to is Domostats (I wrote in my original post that I used it). There's a "Datasets" option, but no "Datasets Schema" option. In the "Datasets" option, I cannot see the number of rows updated. There's also a "Dataset History" option which also does not tell the amount of rows updated.…

As an update to my original question, I tried to connect a dataset with only one row to my widget (created through Design App Studio). It still shows a value of zero, even when the value of the column is not zero (its 20). 

thankyou @ST_-Superman-_ . I also grouped the table through a SQL transformation, but there is still the same issue with the BEAST mode (even with only one student per row). Let me know if you propose anything else. Appreciate your support

This is the best solution. Could you please tell how to limit the row to only one? (I only want to show the top student's picture). 

Also @guitarhero23 even if I change my WHEN condition to return texts (with the ELSE), still gives me the else text. 

I'm trying to put a picture in a table card, of the student who scores the highest marks. My code looks like this: CASE WHEN ( CASE WHEN `Marks` = MAX(`Marks`) THEN `Student_Name` ELSE 0 END) = 'John' THEN CONCAT('<div style="text-align:center"><img alt="DOWN" height="200" src="https://student.jpg">','</div>') ELSE 0 END…

So lets say I have two columns: Student: Marks John : 98 Mary : 70 John : 90 Mary : 60 I want to find out the name of student who has the highest total marks (in this case, it is John). If I have the name of John, I can put it in a card (which is what I want). a) Could anybody tell be any beast mode calculation using which…

I used to work on PowerBI before. The function for this task used to be MAXX. It calculates the maximum of one column based on another. Also wondering in there's a function like this in the Beast Mode. 

Thank you for the reply. I will try this out and see if it works. 

I get it. Thanks. On my first question, I will be recieving one new file everyday in my S3 bucket. I have two options: .1. Append new data with old before it comes to S3, so then I can bring all of that to Domo .2. Bring all files (old and new) to Domo (with a similar naming convention so that Domo can pick up all of them)…

That sounds reasonable. Also if could ask, I cannot post questions in Dojo. There's no search bar which asys "ask a question" in Dojo for me. Even though I can reply to other threads. If you could please tell me what I can do to start asking questions in Dojo. 

Hello. I am facing the same challenge as you were. Could you tell how you were able to solve the issue?

That worked out! Thank you very much. 

Hello. If we didn't specify the visitor_called, but wanted to count all unique visitor_ids for each visitor_called, any idea how we could do that in Beast Mode? Will be of great help. I'm going through a similar issue.

One of Domo's strength is data integration from different platforms (google analytics, MOAT, Emails), and that too in an automated way. When you integrate all of this data, you might want to see it together by making pivots. Other BI platforms can do that easily, and display it in the form of tables in pivots. There is…

Agreed. Whats the purpose of Domo if there is a limit on the entries shown. I am getting the same message. I don't want to download this into an Excel file. Has Domo found a way to solve this issue?

Just wanted to confirm if this issue has been solved yet? I would also like page level summary, however I can't see it in the connector option. 

Hello. I am stuck on the exact same thing. I want to be able to see values in progress bar greater than 100% (if achieved > goal). Just wanted to ask if this issue was ever solved?