Best Of

Re: Email Connector - csv headers import, but not data

@dgsinclair It most likely is the CSV file you're using. I'd suggest reverting your dataset back to the last successful execution from January 5 and starting your changes again from scratch.

On a side note, did you edit the csv file in a text editor, like your screenshot, or did you use Excel? If you did it in a text editor, it's possible that you may have accidentally mis-aligned your columns while manually editing and Domo is unable to read it properly.

MichelleH

1

Re: Calculations using analyser or beast mode

Can you provide a little more commentary about what exactly you are looking to solve for here? It looks to me like you've already figured out the solution.

If you're looking to calculate numbers based on different filter criteria I'd recommend using a CASE statement on a beast mode or in magic ETL to solve.

Pretend I'm running a fruit stand -- I have 3 apples (that are red), 2 peaches (that are pink), and 5 blueberries (which are blue). I want to lump anything that is red or pink into a 'red' bucket.

I can write a beastmode called 'red fruits':

CASE WHEN fruit color IN ('Red', 'Pink') Then SUM(Quantity) End

This would add apples and peaches together.

G_Grey

1

Re: Data format from Jupyter to Dataset

it's unclear what your output from (presumably) magic etl scripting tiles looks like. can you send intermediate screenshots?

jaeW_at_Onyx

2

Re: Weighted Averages of Summary Data

I think it would be something along the lines of...

sum(`N` * `X-Y Average`) / sum(`N`)

ST_Superman

1

Re: Query to create a condition on a database

Hi @luizalauretti

you can easily created a beastmode case statement as

CASE 
    WHEN `PPG` = 'MPA 90GRS' THEN 90
    WHEN `PPG` = 'CTA 90GRS' THEN 90
END

Adding as many conditions as you want individually or this is another option

CASE
    WHEN `PPG` IN ('MPA 90GRS', 'CTA 90GRS') THEN 90
    WHEN `PPG` = 'CLUMINOUS 70GRS' THEN 70
END

now if , PPG contains a lot distinct values , you could ETL a table with those values and join it to your data.

anyways, there is a lot different ways to do that. hope this helps

Godiepi

1

Re: Getting an SPC card to track data by the Day

@slewis1 Does it still show the axis at an hourly level if you change the filter to "Previous Year"? It's most likely due to the fact that we are only 3 days into 2023, so it's trying to fill the gaps.

MichelleH

1

Re: Zendesk 1000 row limit

@Tsharma8724 It looks like it is a limitation of Zendesk API on results per query. https://developer.zendesk.com/api-reference/ticketing/ticket-management/search/

A connector enhancement request from your accounts team would be required for Domo Engineering to build it out.

You would need to adjust your query and run it on append daily so it is under the max.

TDanis

1

Re: Python Tile Typecasting while Reading Data

Have you tried converting your series directly to a category after you import it?

raw['column'] = raw['column'].astype('category')

GrantSmith

1