MichelleH Coach

@jtrollinger In addition to Grant's feedback, you only need one ELSE to designate 'Others'

@PremAnand Are you using a connector with schedule settings? If so, try changing the schedule to Manual.

@jakebutterfield I'm glad it worked!

@jakebutterfield Have you tried using a variable control? You could set it up so users can enter a number of days, then use that variable input in your beast mode calculation.

I agree with @user078903 about the view/edit/delete distinction. For example, it would be very helpful to create a custom role for business users to share content with other users by adding them to a group without the risk of accidentally deleting the group or sharing sensitive content with that group.

@Zel In that case you can keep using a grouped bar chart with Tech Name on the X axis and Normalized Store Chain in the series. If you are still encountering duplicates, then be sure to remove any sort fields in the card.

@Zel How do you currently have your grouped bar chart set up in analyzer and how do you want it to look? If you just want a single bar per tech name, then I'd suggest using a stacked bar chart with Tech Name on the X Axis and removing any sort fields. A grouped bar chart is best for if you wanted to see values for each…

@renee12345 Can you please share some screenshots from your dataflow and where you are seeing the null values?

@nshively Depending on the order of your data it may actually be pulling the next date instead of the previous. Does is return the correct value if you add ASC or DESC after your order by clause?

@nshively Try adding a partition to your window function so that it only looks at the last salary for the same job title: lag((`Annual Base Salary 50th`),1) over (partition by `Job Title` order by `Data Effective Date`)

@PJG Can you please share a screenshot of your Quadrant Lines settings and what your card looks like within analyzer?

@PJG You could request the dashboard scroll functionality in the Ideas Exchange so the product team can see it. However, it also worth considering whether scrolling through 100 rows on a dashboard is going to be impactful to a data consumer

@PJG I don't think this is possible using a Gantt chart. If you want to make such a large Gantt chart more readable, I'd suggest setting up quick filters with certain values pre-selected so that the card defaults to the most relevant view (i.e. Task Status, Current Project Phase, Task Assignees, etc.)

@Dybi It looks like there is a default filter view applied to this dashboard, which is why removing the filter is only temporary. The owner of the dashboard likely has that preset for everyone. Here is some more detail on how filter views work:

@nshively Can you please share some examples of what values are returning vs what is expected?

@jrtomici This is not possible using a pivot table, but you could replicate the same logic by switching to a mega table and creating a separate beast mode for each value column you want to show

@ArborRose Alternatively, you could also change your field from a number to text in your ETL

Completely agree. The button to hide Buzz is also not intuitive and I often have to show users how to collapse that panel

@LenLaCara What values do you want in these columns? If you want to see a sum or count, you can set up a beast mode for each column like the ones below and add each one to the table. As a side note, you only need the LIKE operator when you are matching string patterns and using a % wildcard. If the values you are searching…

@LenLaCara Do you have a screenshot of what the email looks like?

@LenLaCara Is the scheduled report based off of the card or the dashboard? If the amount of data in the card is manageable enough and doesn't require scrolling, I'd suggest scheduling the report based on the dashboard instead since table cards sometimes get cut off on scheduled reports.

@LenLaCara Do you have the "Allow Text to Wrap" box checked in the analyzer of the pivot table?

Hi @Frank_Sodano I just found a way to remove the abbreviation on a Single Value card by changing the "Divide Value By" setting under General to "None". Hope this helps!

@NathanDorsch Unfortunately I'm not able to get on a call. If you post some screenshots of where the errors are occurring we may be able to help identify the issue

@NathanDorsch What issues are you seeing?

@donna_torrice I don't believe this is an option currently, but this would be a good post for the ideas exchange

@NathanDorsch Your first transform with the SELECT statement should be in a Table transform, not SQL. Whenever you need to create a subquery, you need to use a Table transform in order to name the table and reference it in subsequent transforms. SQL transforms are for actions that don't require an output table.

@Jones01 Can you please share how you got it to work so that others can find your post later? You can also mark your own comment as the answer so that your question is marked as answered.

@donna_torrice I second @GrantSmith's comment. If you recently changed your instance timezone that may explain the sudden change in your Workbench datasets

@domoexpert Can you please share some more context on how you are using this beast mode in your card(s)? How do you want the cards to react when the value of "Toggle" is changed?