Comments
-
Okay for your summary number use this: AVG(COUNT(DISTINCT 所在库位) FIXED (BY Date)) That will give you the average unique count over the entire time period by date for the group total.
-
It appears that Atlassian doesn't allow for Confluence pages to be embedded externally, unfortunately.
-
We use MS Forms extensively. The easiest way to pull this data into Domo is to sync the survey results to an excel file in OneDrive and use the OneDrive for Business connector. There is no MS Forms connector. One isn't really necessary since the OneDrive for Business connector is a direct connection to the survey data…
-
@dlc3 Amazing solution! Going to be using this for sure!
-
Figured it out, but you'll have to use the Advanced SQL Editor in dataset views. Once a dataset view is converted to an Advanced SQL dataset view it cannot be reverted back.
-
You could make duplicate views and bring those in as additional datasets to join twice more.
-
Ah I read your question wrong. When I've done this in the past, it has been static. I've done things like this: CASE WHEN `date` >= CURRENT_DATE() - INTERVAL 28 DAY AND `date` <= CURRENT_DATE() THEN `value` ELSE 0 END I can't think of a great way to make it dynamic. Hopefully @GrantSmith @MarkSnodgrass or @MichelleH have…
-
Date - INTERVAL 28 DAY Then, use the new date field above in your visualization, but filter using the original date field.
-
You can't do WHEN Sort: Month Number = 1 THEN NULL You could do WHEN Sort: Month Number = 1 THEN ''
-
It is because those are not Google Sheets, those are Excel files stored in Google Drive. Convert them to a Google Sheet and you will be able to find them using discovery in the Google Sheets connector.
-
Because you want to see the two combinations simultaneously, you'll need to combine the two columns. I did this using CONCAT(). I don't think this is the perfect solution, but it works. If you have many combinations of Cat and Name then this may not be ideal. Create a beastmode: CONCAT('Cat = ',Cat,' & Name = ',Name) Make…
-
You can use the following beastmode to correct the date: date_add(date('1899-12-31'), interval floor(あなたの日付フィールド) day)
-
To refresh your google sheets dataset: 1. Go to the data center: 2. Locate your dataset and click into it. 3. Then click the kebab icon in the top right and click "Run Now" If you data is an ETL output, you'll need to repeat steps 1 & 2 above and then: 4. Click the kebab icon and click "View Dataflow" 5. Click the kebab…
-
You can rename the fields in MagicETL. You just have 1 date from each datasource right? So for example, if in Dataset 1 the date name is Date1 and in Dataset 2 the date name is Date2 you could rename the date field in each to be New Date. Then union the data together and Domo will match up the date columns as a single…
-
Rename the 2 date fields, or create a new date field, in MagicETL to have the exact same name and then append the data from the two sources. Then you'll have a single date field and wont lose data when filtering.
-
If you are an instance admin then you control all grants. Grants are controlled in the Roles section in Admin settings. EDIT: oh I was able to replicate the issue you are having. Yikes that seems like a product enhancement need. I would suggest submitting this in the ideas exchange You can also modify the group using the…
-
If you leave the "Duplicate all cards" box unchecked, then changes to the cards themselves in analyzer will appear in those same cards in the other location. However, design changes to the page/app will not. Dashboard or app level changes will not affect the other content, but card changes in analyzer will.
-
For that you can use a nested beastmode: Create a new beastmode that references your count distinct. AVG(その他の計算フィールド) Then select this new field as your summary number.
-
You would connect the data using the google sheets connector: Ensure that append is the proper update method for your data. If it is, in the dataset settings, you can set your update method to "Append".
-
You'll need to create a beastmode: COUNT(DISTINCT(あなたのフィールド) Then bring this newly created beastmode (calculated field) into your card in the y-axis spot. Here is a video on how to create beastmodes if you never have before:
-
It appears only when you hover next to the name of the furthest right group owner. You'll need the grant "Manage All Groups" to be able to edit closed groups owned by others.
-
The card wouldn't work with no value shown on that level of the sunburst. Logically there needs to be something there if there is an additional level. So for CEO you could have a repeated value of CEO, or N/A which makes sense because Level 2 doesn't apply to the CEO. It's just a limitation of the chart type. You could…
-
It can't handle nulls. For your next level just create a beastmode: IFNULL(`Level2`,'N/A')
-
I would create a bar chart. X-axis would be a beastmode: DAYNAME(date) 3 beastmodes would be 3 bars: 1. MAX(volume) 2. MIN(volume) 3.AVG(volume) I would also sort the bar chart using the following beastmode: CASE WHEN DAYNAME(date) = 'Sunday' THEN 1 WHEN DAYNAME(date) = 'Monday' THEN 2 WHEN DAYNAME(date) = 'Tuesday' THEN 3…
-
Yes, I would create a separate dataset that is for snapshotting purposes.
-
The easiest way to do this is to set the update method of your data to "Append" instead of "Replace". This way, each time the data updates, it is added to the dataset as an append so you maintain a full history. You can set this to run on a schedule (quarterly) but can also manually update the data anytime you please. For…
-
I don't think so, but that would be a question for the Lucid community! If so, it would be by creating an iframe and embedding that in Lucid somehow.
-
You won't want to use count distinct then. Can you share what your visualization looks like? If you have both Customer ID1 and Customer ID2 as fields in the table it will not work as you are expecting.
-
It would also be helpful to see what visualization you are trying to create and your expected view.
-
Beastmodes are case sensitive. I believe you just need to change 'Active' to 'ACTIVE'