Best Of

Hi @user030119

The error is occurring because there's an aggregate function (i.e. SUM) on top of an aggregate function (i.e. AVG), which isn't possible to process in a beast mode.

What could work is to set up AVG(`Probability of Accident in Decimals`) as a separate calculation before Analyzer (for example, as a calculated field in the ETL) and then write your formula using the newly created measure.

There's also the consideration of whether summing up averages is going to give you the right numbers to solve your business problem/situation.

Hi @ramoshe, you'll need to use the 'Group By' tile to get your average (or any aggregation) field. Have a look at this article [https://domohelp.domo.com/hc/en-us/articles/360044876094-Magic-ETL-v2-Tiles-Aggregate-Beta-] to better understand how to configure 'Group By' before adding it in your ETL.

Hi @mahee84, in order to get that graph view, follow these steps:

• Select 'Line + grouped bar' in Chart Types
• Drag in your 'Cumulative Backlog' field in the X axis and then either Daily date fields in 1st Series spot and then the other Daily date field in 2nd Series column
• At the moment, it'll show as one bar and one graph so then you'll go into Chart Properties -> General -> Series on Left Scale and type in '2'
• Once applied, it'll show as 2 lines which then means you should add in your 'Ticket No' field to the 3rd Series column, resulting in a bar with two lines
• Afterwards, it's tidying up the y-axes in Chart Properties -> Value Scale, and other elements to match your Excel report.

Yes there is, in your chart, go to Chart Properties -> Data Label Settings -> Click the plus sign on Text to reveal a list -> Click on %_PERCENT_OF_TOTAL

Hi everyone!

I have some data that I want to display in a table. If I select the mega table the table is scrollable both in the edit card view and in the dashboard page but if I select the HTML Table (which looks much nicer) the table is only scrollable in the edit view mode. 

Is it a known bug and I'll need to stick to mega table or is the something I can do?

Thanks in advance,

Andres

@azyda when view the dashboard, if you click on the card title of one of the cards that is not displaying correctly so that you can view it individually in full screen mode, do the colors work? If so, it seems like there is some sort of bug and you might need to reach out to support, support@domo.com .