jrtomici Member

@Manasi_Panov exactly what I was looking for, thank you!

Hi @DavidChurchman - bumping this to ask a similar question. Now I have this table I'd like to replicate: Notice how the impressions to date are unique for the segment names and weeks. Here is what my table in Domo looks like: (Ignore the extra rows of data.) See how the impressions to date don't "reset" for the second…

Since there's no preexisting issue with this, I'm going to go back and work on it more. If the problem persists I will provide screenshots. Thank you both!

@ggenovese it's occurring when I save and run the dataflow. I created a copy of the dataflow and a new output dataset for testing purposes, specifically because of the preview limit.

@DavidChurchman perfect, thank you!

We use programmatic filtering for permissioning the data to certain user groups, but users should be able to apply their own filters for custom exporting. There's no reason why exporting a card would show all the data. @MattTheGuru

Are you sure it's an embedded App and not just a normal embedded dashboard? This export button for embedded Apps was only recently added at our team's request.

@Jones01 are you sure you're specifically using the export shortcut button on an embedded Domo app? I've tested multiple times and the exported card is not filtered. Maybe you could demonstrate with screenshots?

@DavidChurchman yes, that is correct, my apologies. Formula seems to work with the test dataset but not the actual so I will need to do some digging. Thank you!

@DavidChurchman sorry, I did add some rows just to test your formula since it wasn't working on my actual dataset. I now realize that it's working as intended!! Sorry. I still don't know why it won't work with my dataset but I will look into it.

@DavidChurchman I think this is the right track, but it's not perfect. The second to last row (A, 3, M) should be 0.33 since it's one row with that Network/Hour/Date combo and 3 avails.

This feature really needs to be added. Almost no point in migrating our dashboards to apps if users can't export content

Just updating everyone, this feature is now available in beta through Apps.

This is exactly what I needed, I always forget about this tile. Thank you!

@BraydenJ I don't quite remember how I solved for this, but I believe I ended up opting to do the calculation as a beast mode instead of using ETL. Good luck

Thank you—I was on the right track doing this, but how would I also include rows that are not in both datasets? @MarkSnodgrass

@ColemenWilson Ugh I apologize — what makes this complicated is that the Name field is not unique. So there is no unique identifier for each row across both sources.

Thank you — just needed to edit the card interaction to drill down instead of filter.

Any other ideas?

I suppose I could join the 4 datasets together each with an associated constant and then filter each card by the correct constant.

Not really, since the different data sets are created in a dataflow with various different joins and aggregations.

Incredibly helpful, thank you.

What would the join key be for the second join tile?

Hi, just bumping this as a new error has come up. Now I'm getting an error for this formula tile that says "failed to convert value 'NaN' from type 'Floating Decimal' to type 'Fixed Decimal'" It's my understanding that this is “not a number” but how would I go about debugging this?

@MichelleH @RobSomers extremely helpful, thank you for telling me about this feature!!

Interesting, reading about it now. Thank you @RobSomers Is there a way to toggle the variable within the dashboard without going into analyzer? The dashboard is meant to be a user interface used by sales teams without any need (or want) for them to open the cards in analyzer.

@GrantSmith figured it out, I sorted the table by Total and aggregated through there, thank you

Hi @GrantSmith thanks for the quick response. Unfortunately the table remains as is even when aggregating the total by sum. I have a pie chart that sums up everything correctly (i.e. Connected TV has 49,585), am I missing something? Appreciate the help.

Great, thank you!

Thank you everyone for your responses, especially @MarkSnodgrass that is a very clever implementation that I may find use for in the future. I don't think these solutions can apply but thank you.