I have a custom chart that lists all the counties in our state. When applying the custom chart to data, the legend populates the values. I want the legend to populate the names. Can this be achieved? The first photo shows how the legend is showing counts of the FIPS (counties) values. The second photo shows an example of…
Good day, can I ask for your help. I'm joining two datasets, one from a dataset view and the other one from an email connector. My join keys are two text columns, specifically an email address. There should be a match but I'm not getting anything. I've already tried using the String Operations tile to trim both spaces on…
Hello. May I ask for your help in getting the average days or average hours or average minutes between 2 columns of date + timestamp data? The thing is, the average could be 'days', 'hours' or 'minutes', depending on the values of the 2 data columns, so we want to show the output similar to a timestamp format to be…
Good afternoon! I am having a join issue where only my inner join is working, but I would like to either a left outer join or a full outer join. I am trying to join 417 rows of data to 15 rows of data. Thank you!
I am working with a dataset now that several unique components, including date. Within a given day, there are about 12-15 new records produced based on these dimensions. I tried creating a unique identifier that concatenates these dimensions (including date) with the hopes of creating a unique ID that will distinguish old…
I am trying to figure out a way, in Magic ETL, to take multiple single day events and group them when there is break in consecutive days. Example, if the results show the 1st, 2nd, 3rd, 5th, 6th, 9th, 10th and 11th, I need three results, not 8. I want to see begin and end dates of 1st-3rd, 5th-6th, and 9th-11th. Any…
In my dataset i have a column "A" and there are numbers in that which represent spend. I want to create a new column in which i want sum of all values in A to be available in the new column in all rows. Eg. If sum of all values in column A is 125, and I have 10 rows, then in the new column "B" I want 125 in all 10 rows and…
I'd like to create a faceted chart that shows revenue for a subset of products, comparing multiple months against each other. This would give me a visual representation of changes month over month for my top products, and would promote further investigation if a product's performance one month was significantly different…
I have a dataset currently flowing in from MongoDB which is essentially populated based on custom fields that are optionally set within the source. Each element in the array has the name and value of the custom field (ie. customField<0-N>_fieldName and customField<0-N>_fieldValue). The issue is that it's not always the…
Hello, I need some help. I have made some calculations in beast mode to convert minutes to seconds & the beast mode runs ok. However when I pull in the metrics & respective stages into the card, only the first stage returns the expected values. The formula for all the stages is the same but only changing the stage level.…
It looks like you're new here. Sign in or register to get started.