pauljames Contributor

Sometimes I feel like the Domo community are all about to ask the same question at the exact same time. lol Thanks for the answer guys!

@n____l____ hey there! look into period over period charts. You can compare quarters as well.

@Alex_K Hey there! Have you tried this?

@Airwon , hey there! Are you talking about a link url that when clicked opens a new browser? IFNULL(CONCAT('<a href="', `LINK FIELD`, '" target="_blank" >Link</a>'), 'No Link Available')

@phesson , hey there! have you tried aggregating on multiple columns in the magicetl? You could create a new column for the other dataset and name source then ensure the other dataset has the column as same source name. Then aggregate on all of the necessary dimensions and the new source column. Do you have a pic of…

@Sonia_4268 , hey there! That looks great! Just remember tho if you were to change that date then your connector would be corrupted and you would have to overwrite and/or establish a new connector. Be mindful that you could even create a nice historical dataset if you use magicetl and combine old GA to new GA4 :)

@robdmitchell , here you go!

@eddiesmall, then autographs are gonna cost ya.

Hi @kav_100 , look into the data operations tile in magicETL. You can create a month of date and year of date columns. Then combine them, then group on this.

@Pellogat , it sounds like you want the users to have the ability to create a custom table. Essentially the ability to create a new table card but without the ability to edit cards on the dash. You need to install this from this appstore. Apply it to your dash. :)

@HLUNKAD , upload an excel file. :)

Hi @Sbhatia! is it just the multi gauge card thats not working? See article here for other PoP types. PoP card types here. multi gauge article here.

@eddiesmall, I'm looking forward to meeting the Domo legends!

@Hydrow_Eric , oh yes… I remember. :( But its been great ever since!

@Hydrow_Eric @JuanRoaRojas @Mattwjones @GrantSmith I have many Shopify connectors and have recently had issues as well. They seem to be working fine now though. You all are connected through the custom app connector correct? We had to move all our shopify connectors to this type. If not, this could be your issue to start.

@TC1199A , are you applying the recursive key/identifier to this 2020 data? You might need to append before the key so it can be saved.

Hi @A_Benincasa! I've used this below. CASE WHEN WEEK(`Date`) = WEEK(CURRENT_DATE()) AND YEAR(`Date`) = YEAR(CURRENT_DATE()) THEN 0 ELSE 1 END Set this as a filter and have it = 1. This will allow any date that does not fall on the same Week # and Year as the current date to be included in your data.

Hi @TC1199A! Any specific reason why you want to delete the 2020 input dataset after inclusion?

Hi @Kutsch! Let's see here. These snapshots should help you out. As a precaution, group your data by date, then have an aggregated column of terminations summed. Then go into a card and select period over period multi value chart. See below. To ensure filters aren't applied , edit dash > click on card edit content arrow >…

@fadhlirrahman , For #2, I would investigate the rank & window tile. You must classify the 1,2,3,4,etc. order ranking for each customer ID. From there you can take the difference of days using date operations between the orders to then avg. I hesitate explicitly laying the answer out through snapshots as this is for…

@ChintanParekh have you thought about using the data science magicetl tile - 'Forecasting'?

@bmartin , I'm not sure you can adjust color of a summary number. I suggest creating a period over period multi-value card.

@ScottLeeds Try this. This formula works for me. You can adjust size.

@GrantSmith , wouldn't my ifnull suggestion taken care of that though?

Group by tile in etl, group by start date, end date, and Geo. Then below you can sum the other data points like impressions booked, impressions delivered, other. You could apply a flight id as well to filter by. To do this use rank and window tile.

@KarenG are you asking for filters or do you need to group your data by using the group by tile in etl?

@GrantSmith @MarkSnodgrass @ColemenWilson @MichelleH

@lawiti , oh. is the data showing as 'null' instead of 0? Change this in view or in beastmode.

@lawiti , try switching to grouped bar chart or nested bar to see total month too.

@lawiti , can you send pic of chart? It will help me see what needs to be done.