Best Of
Re: Export Dashboard to Excel
I would suggest looking at the Domo Excel plug-in, which is available under Admin - More - Tool Downloads.
You should be able to do it with that. Here's the link to the KB Article.
https://domohelp.domo.com/hc/en-us/articles/360043437933-Using-the-Domo-Excel-Plugin
Re: Alert message for card is not supporting the card filter
@Salmas how is your alert setup? Maybe you want to use a scheduled report instead of an alert.
Ashleigh
Re: Alert message for card is not supporting the card filter
If that does not work you may need to default the card to only show the 2 day lag and then setup the alert.
Ashleigh
Re: How populate a new column with data based on data in other rows
I would create an ETL that splits your data into two using two filter tiles. One filter where userid is null, which is your pre-authenticated data, the other where userid is not null is your authenticated data. You can add a constant tile to create a column called authtentication status. You can then use a join tile to join them back together and join on session id. You would then have your user id next to your pre-authenticated data when it matched on session id.
Re: How to Create Monthly Averages for Headcount?
@nshively Understood. I'm sure @GrantSmith will come up with a very elaborate beast mode for you.
You can whatever you are potentially slicing by into your group by and rank and window tile and then save the final formula tile work that calculates the average headcount for your beast mode. I have done this multiple times and it allows me to maintain the card flexibility while avoiding complex beast modes that are hard to troubleshoot.
Re: Align headers to bottom
Hi @User_32265, the only changes you can make around header positioning for this chart option are:
- Header Alignment 'Centre'
- Header Row Font Size to something smaller to reduce the empty spaces below your current headers
Alternatively, you can switch your chart to 'HTML Table' as the headers for this particular table type are evenly distributed.
amehdad
Re: how can i filter colunms?
Hi @user007345
You'll want to reformat your data to be in the format of:
Date | Product | Count
Put the Date field on your x-axis, product as your series and Count as your y-axis.
You should be able to use the Unpivot or Dynamic Unpivot on a new magic etl dataflow to restructure your data.
https://domohelp.domo.com/hc/en-us/articles/360044951294-New-Magic-ETL-Tiles-Pivot
Re: Create a histogram
hi, would you please share the beast calculation, I am trying to design something like this.
