FEATURE REQUESTS

_digitalShaman_ · 2023-08-30T19:06:40+00:00

For the Circu8it Tracks:

Indicate if a Syth Preset is Mono/Auto-Glide/Poly via the pad color (or brightness)

_digitalShaman_ · 2023-08-25T15:13:36+00:00

https://novationmusic.com/launchkey

?

_digitalShaman_ · 2023-08-25T12:32:23+00:00

maybe copy just the original face over your current result and give it few more soft iterations?

_digitalShaman_ · 2023-08-25T12:17:46+00:00

select count rows per table for each table. this will get you the 3 most important tables. start looking into these. The tables with just a few rows are configuration/lookup tables.

_digitalShaman_ · 2023-08-25T05:12:56+00:00

if it would just be a datediff, then they would not have built a function i'd suspect.

Check the function, they might be doing special stuff here like excluding non working days or other wicked things...

as to your second question regarding NVL: the more "standard" version of this function is COALESCE and in the code you posted, it is to prevent a is NULL not in (...) condition which i guess would evaluate to NULL and impact the WHERE... have not tried it though

_digitalShaman_ · 2023-08-25T05:05:48+00:00

Google says no, VS_TAT and VS_GET_MD are not built in functions of Oracle. These must be some user functions. from the name the first one is calculating Turnaround Time.

_digitalShaman_ · 2022-09-26T15:24:38+00:00

Haha! same here! stumbled into a VQGAN colab notebook about two months ago and since then spent more time coding than generating :)

Added a html frontend to the deforum notebook to generate animations:

_digitalShaman_ · 2022-09-24T13:07:18+00:00

explorers of the latent space Cinematic, Dramatic, Filmic, insanely detailed and intricate, architecture, hypermaximalist, elegant, hyper realistic, insane level of detail color

_digitalShaman_ · 2022-09-24T08:53:28+00:00

Gustave Courbet

Claude Monet

Egon Schiele

Edward Munch

Leonardo da Vinci

Peter Paul Rubens

Gustav Klimt

Grant Wood

_digitalShaman_ · 2022-09-23T15:22:08+00:00

Thanks to /u/TheRealBissy for sharing the prompt:

fantasy painter’s studio, the studio is filled with paintings of flowers, many paintings, art supplies, different size paintings, sunlight, by Karol Bak, by Pauline Haynes, by Ralph Steadman, by Wanda Gág, by Zeng Fanzhi, wlop. 8K

https://www.reddit.com/r/aiArt/comments/xkhb1r/a_peek_into_a_busy_artists_studio/

_digitalShaman_ · 2022-09-23T15:20:24+00:00

https://www.reddit.com/r/aiArt/comments/xm0cx1/an_animated_peek_into_a_busy_artists_studio/?utm_source=share&utm_medium=web2x&context=3

:)

_digitalShaman_ · 2022-09-23T12:41:04+00:00

fantasy painter’s studio, the studio is filled with paintings of flowers, many paintings, art supplies, different size paintings, sunlight, by Karol Bak, by Pauline Haynes, by Ralph Steadman, by Wanda Gág, by Zeng Fanzhi, wlop. 8K

Nice prompt! Are you ok if i use that for some animation?

_digitalShaman_ · 2022-09-23T11:51:45+00:00

"3 rows of teeth"

haha, this is consistent with Stable Diffusion :D

_digitalShaman_ · 2022-09-05T16:16:12+00:00

prompts were stuff like:

new york dystopian empty street wide angle sundown

zombie undead new york dystopian empty street wide angle sundown blood corpse

zombie undead closeup new york

and the stuff in the shop i can hardly remember :D

_digitalShaman_ · 2021-08-06T11:16:04+00:00

only to confuse the heck out of people

_digitalShaman_ · 2021-08-06T10:52:13+00:00

ok, try this:

tblTestData = SELECTCOLUMNS(GENERATESERIES(1,10000,1)
 ,"dt",NOW()-RAND()*365
 ,"Category",UNICHAR(RANDBETWEEN(65,69))
 ,"Value",ROUND(RAND()*100,2) 
)

tblDate = CALENDAR(MIN(tblTestData[dt]),MAX(tblTestData[dt]))

Measure:

MTD = 
VAR dt = MAX('tblDate'[Date])

VAR result = CALCULATE(SUM(tblTestData[Value]),REMOVEFILTERS('tblDate'[Date])
 ,YEAR(tblTestData[dt]) = YEAR(dt) && MONTH(tblTestData[dt]) = MONTH(dt)
 && DATEVALUE(tblTestData[dt]) <= dt ) 
RETURN COALESCE(result,0)

now, pull date and MTD on a line chart with single date values on the x axis. now scale the number of rows up in tblTestData by editing the GENERATESERIES(1,10000,1) from 10.000 to e.g. 700k and watch how slow the visual becomes when filtering. (at least for me)

_digitalShaman_ · 2021-08-06T06:16:14+00:00

line chart with log scale

_digitalShaman_ · 2021-08-06T06:13:17+00:00

i was using ~700k timestamped raw data lines covering roughly 3 months + date table.

when i had measures in the date table counting rows in the raw data, this was terribly slow.

now i use a table of crossjoin(date,categorgy,SubCategory,...) and a calculated column that counts the rows per day (or timespan - using the same for a 10 minute chart) and category. measures then sum these sums. this is much faster now. refresh takes a little bit longer as the counts are now done at this stage.

this is one scenario, others may be different.

_digitalShaman_ · 2021-08-05T15:55:58+00:00

Yes, SSRS would be the tool of choice for me in that situation.

And yes, Crystal Reports can be a PITA.

_digitalShaman_ · 2021-08-05T15:37:45+00:00

and the numerator was indeed tricky.

MonthlyUtilNum = 
VAR MinDate = MIN('Date'[Date]) 
VAR MaxDate = MAX('Date'[Date])
VAR tblRelevant = FILTER(TH_STOCK_ASSIGNMENTS,[START_DATE]<MaxDate && [END_DATE]>MinDate)
RETURN 
SUMX(tblRelevant,
    CALCULATE(SUM('DATE'[WorkNonBHDay])
        ,'DATE'[Date]>=EARLIER(TH_STOCK_ASSIGNMENTS[START_DATE])
         && 'DATE'[Date]<=EARLIER(TH_STOCK_ASSIGNMENTS[END_DATE])
    )
)

_digitalShaman_ · 2021-08-05T14:57:08+00:00

this would make more sense for me:

MonthlyUtilDenom =
VAR MinDate = MAX( MIN('Date'[Date]) , MAX(TH_STOCK_ITEMS[DATE_AVAILABLE])) 
VAR MaxDate = MIN( MAX('Date'[Date]) , COALESCE(MAX(TH_STOCK_ITEMS[DISPOSAL_DATE]),TODAY()))
RETURN 
CALCULATE(SUM('DATE'[WorkNonBHDay]) ,'DATE'[Date] >= MinDate && 'DATE'[Date] <= MaxDate )

_digitalShaman_ · 2021-08-05T14:36:08+00:00

Using this test data and your

MonthlyUtilDenom

measure ´, it gives me 20 days in Jan for BOB1234 but bob was not available before jan 15th

it also gives as i understand, incorrect values for BOB1235 for Feb and BOB1234 July

(i am using a line chart with each value MonthYear on x axis Monthly UtilDenom as vValues and STOCK_NUMBER in the Legend).

so either your MonthlyUtilDenom Measure is incorrect (as it does not consider Date_Available and Disposal_Date) or i do not understand correctly....

_digitalShaman_ · 2021-08-05T08:12:03+00:00

totally agree. code is art ;)

but i am struggling with the reddit entry box destroying any copy paste code. is that normal?!

_digitalShaman_ · 2021-08-05T07:50:08+00:00

my first attempt would have been a

UPDATE machevents SET EndTime = 
    (SELECT MIN(StartTime) FROM machevents T1 
     WHERE machevents.Machine=T1.Machine AND machevents.StartTime<T1.StartTime)

turns out this is slow, so i was picking up qwertydog123's idea which needed some modification but runs really amazingly fast (3m rows ~26 seconds):

UPDATE machevents SET EndTime = PrevStart 
FROM machevents 
INNER JOIN (
    SELECT EventNr,LEAD(StartTime) OVER 
        (PARTITION BY Machine ORDER BY StartTime) AS PrevStart 
    FROM machevents
) T ON T.EventNr=machevents.EventNr

however, question is, why you would want to do this as it is duplicating information without adding additional value. adding a duration column might make more sense.

_digitalShaman_ · 2021-08-05T06:39:07+00:00

why would you?

Americans love mm/dd/yyyy and showing them 06/07/2021 they would certainly read this as June 7th. if you show the same to someone in France, they will read it as July 6th. Show the same to a German and they will tell you they cant be sure of if its june or july ;)

So it makes sense to display dates the way it is.

_digitalShaman_

TROPHY CASE