-
Pass Logged In User to Beast Mode?
Hi all, I am looking for a way to show total sales performance for various items relative to individual users performance for their own sales performance. Please see attached image for a better illustration of what I am trying to accomplish. In this example, I want to pass the logged in user name into a case statement.…
-
Mega Table Rank interactions with PDP
Hi all, I am trying to build out a dashboard that lets vendors compete with each other in a mostly anonymous way. One example would be a section that shows the logged in vendor their 7 Day Sales Rank, compared to their 28 and 91 Day Sales Rank. Key requirements: Vendors should be able to see their rank only; not any of the…
-
Beast Mode Description
Similar to how you can describe individual columns in a dataset (via the dataset schema view), a useful new feature could be the ability to describe beast modes. Currently, our practice has been to add a comment inside of the beast mode expression explaining what it's used for, but this comment cannot be referenced in…
-
Heatmap Tables in AppStudio
The basic Mega Table card has come a long way from when it was first released. One of these improvements has been the ability to color the columns as a heatmap (with lots of other settings within). In the card details page, it is basically a perfect implementation. However, when you put your card into AppStudio, it…
-
Sort or Re-Sort Available Values in Variable List
Variables continue to be a game changer for our company. One particular use case we have implemented is to create a variable with a list of all item attributes. As the list has grown the available attributes are no longer sorted in a logical way (for example, alphabetical A-Z). I think everyone could benefit from the…
-
Allow users to specify the color of Magic ETL tiles
This would be a small change that could help organize extremely busy dataflows. While you can currently change the color of the line
-
Show Configuration AND Notes panels on Magic ETL tile simultaneously
Currently, a user can see either the configuration of an ETL tile OR they can tab over to the notes section. It would be nice to see both views at once when writing notes on the configuration or editing the configuration based on the existing notes.
-
Multi Select Variables?
I am building a dashboard that analyzes what the specific categories of items in any given transaction. For this example, let's assume there are 4 potential categories [Milk, Eggs, Bread, Fruit] on any given order. The end goal is to allow the user to select one or more of these categories in a slicer card (or similar),…
-
Can you use Magic ETL to 'explode' table of transactions to all days?
Table A has transactions that show an item's "Old Status" and "New Status" along with the date of the transaction. For example, row 1 shows that item XYZ changed from "Regular Price" to "Promo Price" on 1/1/2023. Row 2 shows that item XYZ changed from "Promo Price" to "Regular Price" on 1/4/2023. Row 3 shows that item XYZ…
-
Change value formatting based on KPI selected in variable
I have a card that allows the user to select which metric (Sales, Units, Margin %, etc) they want to graph by, using a variable control. Is there a way to force data formatting to be 'currency' when 'sales' is selected for example? Then when a user selects 'units', we'd want the formatting to now be shown as 'number'. With…
