MichelleH Coach

I was able to get the same result as you with my data. Even with the date/time field it still defaulted to the month and day axis. I've attached a sample, so please let me know if you're able to figure anything out. Thanks! 

That was my first thought as well, but when I do that it doesn't come out as clean:

Category Scale (X): Trellis/Tiered Date Settings: Date Settings: And this is how the scale currently looks:

I haven't been able to find a solution to this, so I submitted this to the Ideas Exchange. Hopefully we can get this addressed because this functionality is very necessary for charts like these.

These functions will actually still work even though they aren't auto-suggested. See the attached screenshot of a preview in a MySQL dataflow. The same will also work in Redshift.

I believe I saw something about this in a webinar a couple months ago. I would reach back out to your CSM.

Hi @Neeti thank you for the info. I read through the article you shared, and unfortunately it does not provide any information relevant to the problem. The user follows all the necessary steps needed to export the page content, but it appears that there's something about his specific user account or computer that generates…

Hi @user047493 , I agree with @Cartergan, the background color is a great way to draw attention to the cards you want to emphasize. Another good rule of thumb is to design the layout of the dashboard so that the most imporant visuals are on the top left, since this is how we're accustomed to reading from left to right and…

Hi @Abhigyan, If it's a table card you're building, then I would recommend adding an aggregate column to the card (e.g. a COUNT or SUM). This should condense the duplicates. Then you can hide the aggregate column by going into Chart Properties > General > Hide Columns and typing the corresponding column number (If you want…

@DataMaven I hadn't thought about the Remove Duplicates, but I'll get rid of that and see if that helps!

Hi @Godiepi , Thanks for the suggestion! I created a copy of the original dataflow and updated it using your instructions, then let the two dataflows run concurrently for a couple of days to observe the results. While your method was faster overall, it only reduced the average run time by 1-2 minutes. I agree that using…

Hi Eric, you could create a separate beast mode field for the Operational Places of each Organisation Type. For example: sum(case when `Organisation Type` = 'Private' then `Operational Places` else 0 end) sum(case when `Organisation Type` = 'Not-for-profit' then `Operational Places` else 0 end) sum(case when `Organisation…

One way that I've gotten around this is to enable Page Filters instead of adding a filter card. If you save a filter to a page, it has a search bar functionality.

Are you trying to add a slicer card to a page? If so, the slicer only shows the countries that appear in the dataset used to power it. You can try these options to make sure you're including all the countries you expect to see: * Check that you don't have any filters applied within the slicer card. This could be excluding…

If you're having trouble with the OR, then you can break city MNO and city XYZ into separate lines in the CASE statement. You can do something like this: case when `City` = 'MNO' and `Support` = 'Y' then `Troops` when `City` = 'XYZ' and `Support` = 'Y' then `Troops` else 0 end

I wonder if there are extra spaces in the Customer field that are causing it to take up all the width then? You could try a Beast Mode like this to remove any spaces: TRIM(`Customer`)

Hi @Koen, are you viewing the card from a standard page or a dashboard? Standard pages typically only show 3 columns, but if you convert the page to a dashboard it should work.

Could you please share a screenshot of what you're seeing?

I would suggest making separate beast mode calculations for each category. Cat1: case when `Category` = 'Cat1' then `Value` end Cat2: case when `Category` = 'Cat2' then `Value` end Cat3: case when `Category` = 'Cat3' then abs(`Value`) end I don't believe there is a chart type that allows for both area and line plots in the…

I suspect it is a limitation of the "Other" bar. I've tried formulas similar to what you suggested and it all shows the same result. It seems like the "Other" bar is only intended for summed values. Thank you for your help.

@ST_-Superman-_ Thank you for the quick response. I've attached screenshots from the Analyzer. The only Chart Properties option I've configured is the "Maximum Bars". Also, the Beast Mode calculation for the Y-axis is the following: AVG(DATEDIFF(`Date Col1`,`Date Col2`))

Are you only appending these two datasets, or are you doing more calculations? If you only want to append them, you may want to consider using DataFusion since that's specifically designed for simple joins/appends on very large datasets.

Do the employee name fields match in both datasets? If so, you can accomplish this by adding a drill layer to CardA, which will default to Dataset1. After that you can switch the drill layer to Dataset2 under the "Data" section in the Analyzer. Then you can recreate the configurations of CardB in the drill layer of CardA.…

Has this feature been removed? I don't see it now and it's asking me to choose a single dataset to filter on.

You can accomplish this using the POWER function in beast mode: POWER('Value',.5) This gives you a an output of 'Value'^(1/2), which is the same as a square root.