slicer | A rudimentary STL slicer | 3D Printing library

here is an MRE (showing two attempts, with debug left in to be helpful) to try and get 2d subscripting working with AT-POS across a DataFrame that has columns of Series...

...

I am using SQL server v12.0.2000.8 and trying to emit a delete statement in SQL from an sqlalchemy (v1.4.5) msserver+pyodbc connection. I have tried a number of things, inspired by sqlalchemy docs here and here and stackoverflow post. Still no success. My next step will be using sqlalchemy table methods, but I would like to understand what I am doing wrong as I have done inserts in a similar way to approach A below and they worked. Replacing the values directly in the string works, but obviously a no no.

• A

...

I work for a retailer and would like to create a map in Power BI for all of our stores and their 3 closest competitors, like the example below (Ideal Output). The blue dot is our store and the red dots are our competitors. Ideally, the map would change automatically when a different store is selected in a drop-down slicer. Please see the example data below (My Data).

Thanks,

Mark

Ideal Output:

My Data

Table 1: All of our stores. Very basic. Every store has its own unique number, along with basic store details including geocodes.

Table 2: All competitors. Every competitor has a unique number along with basic information including geocodes.

Table 3: Our stores and their 3 closest competitors.

...

I currently have a table in Power BI named Fruit.

Here is sample data from Fruit:

Issue id Label Label 1 Label 2 Label 3 Label 4 Created Resolved Time Difference (MINS) 1000 Apples Grapes Bananas Oranges Strawberries 14/03/2021 11:38:23 11/02/2022 525632 1001 Oranges Pears Apples Bananas Strawberries 13/03/2021 12:34:34 18/03/2022 11:38:23 524324 1002 Pears Dragon Fruit Apples Strawberries Dragon Fruit 04/03/2021 18:31:11 12/03/2022 11:38:23 525345 1003 Bananas Oranges Apples Grapes Pears 11/03/2021 19:34:57 11/03/2022 11:38:23 528264 1004 Grapes Apples Bananas Pears Strawberries 12/03/2021 12:32:52 15/03/2022 11:38:23 521927

I have created a table to join the label values into one: AllLabel = SUMMARIZE(UNION(VALUES(Fruit[Label 1]), VALUES(Fruit[Label 2]), VALUES(Fruit[Label 3]), VALUES(Fruit[Label 4])),Fruit[Label 1])

I also have created a measure count the labels and filter them uniquely: Apples Oranges Pears Bananas Strawberries Dragon Fruit Grapes:

...

My intention is to explore some data visually using a shiny app and then to pass the resulting plot to a Markdown document. My question is similar to these two I found on stackoverflow.

How to pass reactive data as a R markdown parameter?

How to pass table and plot in Shiny app as parameters to R Markdown?

Unfortunately I am not able to figure out how to use the answers provided to solve my problem. I assume I do not understand the functionality of reactive values enough.

In the MWE I use an input slider in order to create some random numbers that should be displayed in the shiny app. Once the plot has been created in the shiny app I need it to be embedded into the Markdown document. Passing the plot as a parameter to the Markdown does not create an error, however the parameter can not be accessed (seems not to exist) in the Markdown document. But if I cancel out the code in the shiny app to display the plot in the app directly, the plot can be passed to the Markdown document as a parameter and be displayed there.

I understand that I could recreate the plot in the Markdown document, as explained in How to pass a plot (renderPlot) from shiny app as parameter to R Markdown?. Still I would like to understand if there is a solution to pass the plot without recreating it.

In order to do so I must understand why displaying the plot in the shiny app prevents it to be passed to the Markdown document. What is it that I do not understand? Please help! Thank you!

MWE: server.R

...

I came across this issue in TypeScript types. I'm using a conditional type based on a different property in the same interface to determine the type of one property. Here, the property slicer in FruitBasket is either AppleSlicer or BananaSlicer depending on the type.

If you look at the function test, it receives a instance of FruitBasket, which can be either Apple or Banana. So, I narrow down the type by checking that the type is equal to one of them, but it still complains that basket.slicer is not deterministic. But, it should have all information it needs to determine that it's an AppleSlicer.How can I fix this?

I'm using TypeScript 4.5.4.

...

Using selenium vba I am trying to get the 3rd instance of the classname of searchInput and sendkeys to it. I was able to get it with using xpath,

...

In PowerBI, I want to compare the value growth of categories (lets take A and B) over time from any starting year. To compare this easily, I am using a line graph with the time on the x-axis and category as a legend. I would like both categories to start at 100% and show the growth relative to that starting point. I then want to be able to use a continuous date slicer to vary the start and end-points of my line graph.

I've created a dummy data to illustrate this

...

I have a table where I want to update the values of "Percent Values" Measure at each filter (a user can select either one, or multiple values from a slicer/s). In visualization all the markers for a Year, Month need to add to 1.0 With or Without Slicer selections.

With the help of @Phil Leh (Issues with implementing grouped percentage with ALLEXCEPT in PowerBI) measure works on Year, Month and the measure gives correct values:

However I am not sure what I can do to have % values update with multiple selections. For example, here the percent values didn't calculate to 1.0 for Race and Year, Month at each Year, Month:

I made change to existing DAX (that gives correct values based on Year, Month) so that it can capture Race as well. But the results are wrong.

...