## How can I improve this line chart with value, norm and prediction?

I’m currently reworking some existing graphs which are shown on a webpage for a B2B tool.
These graphs are showing the current state of what’s happening in the life cycle of an animal, along with the norm and a predicted value.
In this particular graph below we are showing animal weight.

As you can see 3 different values are shown:

• actual weight (full blue line)
• predicted future weight (white dots with blue border, on the far right)
• norm (blue dots)

When the user hovers with the mouse over the graph, the legend shows the specific values, as is shown in the example for 32 weeks.

I would like to focus on the legend. It bothers me that “norm” is shown underneath the actual value, while the predicted future value is shown on the right side of it.

On other places in the website, we show the same graph, but in a smaller view.

Parameter names are translated, and could potentially be very long.

Some graphs are showing data for multiple parameters combined (and could potentially have a value, a norm and a future prediction for each parameter)

Now, as I mentioned, it’s the legend that bothers me. The “norm” is shown underneath the actual value, while the predicted value is shown on the right side of it.

Here are some facts:

• The predicted future value never overlaps with the actual value
• The norm could overlap with both the predicted value and the actual value
• Parameter names could be potentially very long
• Need to be able to show the full legend even in the smaller view

I am wondering what my options are to improve this.
My initial thoughts are to “merge” the columns for predicted value and actual value into 1 column, as shown below. This simplifies the legend.
Since predicted values never overlap with actual values, this seems technically feasible: Just change the icon and the label of that first column.
But is it a good idea ? Are there any better options I’m not considering ?
Or is my solution perhaps worse than what I had before?

Thanks for your comments and insights.

## design – Ways to improve readability of recipe ingredients?

First of all, if you are just looking at a text list of ingredients then I would say that it probably isn’t going to matter too much which option you go for.

Out of the 3 options I would personally prefer the “bold amounts” option. The reason being is that the quantity is the part of the recipe that a person is more likely to need to look at more than once. So the bold part helps to draw attention to that part quicker.

Your examples don’t really highlight this need as you are likely to have the quantities for those ingredients prepared in advance before cooking. However, a liquid measurement (e.g. 200ml vegetable stock) is probably something the reader will want to double-check the quantity of during the cooking phase. So I would say that needs to stand out more.

That leads me to my actually suggestion…

Option 4: Table

Create a simple table. It doesn’t even need to have any styling, so it appears as just text. However, the key part is the spacing between the amount (column A) and the ingredient (column B). Having these as separate columns will make it much easier to scan for the user.

``````1 pound   skinless, boneless chicken breast halves - cubed

1 cup     sliced carrots

1 cup     frozen green peas

½ cup     sliced celery

⅓ cup     butter

⅓ cup     chopped onion
``````

## postgresql – How would I improve my “algorithm” for figuring out my average spending on food per month?

I have a database table keeping track of every grocery delivery. It’s stored as timestamps and sums (EUR).

Currently, I do this:

``````SELECT (SUM("amount in EUR") / 3)
FROM personal."food purchases"
WHERE "purchase time" >= now() - INTERVAL '3 months';
``````

Now, let’s say that the current day is 1st of September 2020. This “algo” will count together all the deliveries from exactly three months back from the current moment, which I guess means from the first day of June, and then simply slash this price into 3 to symbolize “three months”.

Sometimes, depending on the day, this will give a reasonable value. Other times, and I cannot fully describe/understand why, this gives either a too high or too low value. I suspect that the reason for this is that my food purchases/deliveries don’t always happen on the exact same day, and vary quite a bit in price as well. Thus, the resulting sum, even though I do an interval of three months and then slash with three, and thus “should” give the average food cost “recently”, is oftentimes misleading.

I can’t tell for sure, but I think that it sometimes includes one purchase “too many”, and sometimes “one too few”. It might even be worse than that.

Can you help me improve my formula to be more “fair”? I want to know the average amount I pay for food each month, and I’m not convinced that I’m getting that value with my current query.

I think I need to drop the part which goes three months back from the current time, and instead somehow calculates the… last three… months… um… Frankly, I don’t know what I need to do. I just don’t think that the current method is correct.

I’d appreciate if your suggestion/solution stays as close as possible to my original query. I want to understand what is happening. I actually suspect that this is a very common issue and probably built into PG and all other database softwares.

## Improve Prim’s algorithm runtime – Computer Science Stack Exchange

Assume we run Prim’s algorithm when we know all the weights are
integers in the range {1, …W} for W, which is logarithmic in |V|. Can you improve Prim’s running time?

When saying ‘Improving’, it means to at-least:
$$O(|E|)$$

My question is – without using priority queue, is it even possible?
Currently, we learned that Prim’s runtime is $$O(|E|log|E|)$$

And I proved I can get to O(|E|) when weights are from {1,….,W) when W is constant, but when W is logarithmic in |V|, I can’t manage to disprove/prove it.

Thanks

## architecture – How do I improve a data/media storage application?

We have a software product which is used for storing data. We have windows services in our system which makes api calls and the data we get in return is mostly in .csv, .mp3 or .wav format. CSVs are processed and stored into MS SQL and .mp3, .wav are stored into Azure Blob Storage by the windows services. We have a web application as well which basically works as an interface to read/view the data fetched by the windows services, the web application has a lot of complex search logic. We have a multi tenant database design and we are working with huge amounts of data.

When we first get the data from the windows service we store it locally then we have another windows service which we call Sync service, that service takes the locally stored data and put it on Azure.

Some of the data we receive at our windows services is there to stay but some of the data has an expiration time and when that expiry time is reached, that data is to be deleted. For this deletion process we have another windows service which goes out and checks if the data is expired and delete it.

We have relational MSSQL database, our entire application layer is written in C# and we are using SPs and EF to read/write data, we are using Azure for most of our infrastructure and at this point this entire application is costing us around 20 to 25k USD a month for the computing resources and it feels like thats a lot.

By writing this post I am looking for suggestions and expert opinons to see if our process can be improved in anyway, could implementing something like elastic search or maybe some caching mechanism be beneficial in this situation? Some ways we can cut cost? Is a relational database the right choice for this type of application? We need to implement some kind of database mirroring as well so incase the primary database goes down, we have another one ready. Again, I am just looking for input and I understand there is no straigh forward answer to this question. Any suggestions/opinons would be highly appreciated, thanks.

## Do more internal links improve ranking?

Do more internal links improve ranking?

.

## Tools to improve website marketing/monitoring

Hi,
Iwas going through DigitalPoint for a while……but this is my first post.

I got a problem that really matters. i was asked to build a site (and some online tools) where other website owners can promote/market their sites. So i compiled a small list of online tools that i should build and deploy….it looks somewhat like this….

1) Online adbanners.
adding new campaigns and ROI calculations. The clients should have a facility to add new campaigns and check the productivity
2) Email marketing
email newsletters to targetted groups. For e.g., pple interested in ‘print media’.
3) Site monitoring and reporting
Link checkers,siteup checks, SE ranking reports.
4) Site Tracking
visitor tracking, in/exit pages, SE-referer-keywords…etc

This is a crude list actually and our aim is to have an ‘all-tools-here’ image. And they will be more interested in first 2 points mostly. But right now, we cant offer our own adservers and emaillists to the clients as we dont have the publisher base and email databases. What iam thinking is, enable them to use the popular tools instead. Its like this

Our clients(siteowners) -> WE -> Popular service providers -> internetsurfers

I know in any advertisement campaigns, i have to login and manipulate my info. But is that possible to have one general account with them and enable my clients to use it from our interface?

iam not a marketing guy. Iam mainly into coding and design. So please forgive me if my thoughts are not worth giving head.

Please point me New things i can add to my list or other improvements….Your efforts will be highly appreciated. thanx.

## html – What design changes will improve visual appearance of the calculator

This is the HTML code for a very basic calculator. I am at beginner level on bootstrap and definitely beginner level designer. what are some changes i can do to make the visual appearance better. i have used bootstrap and tried to use some features to improve the look with minimum CSS ( i don’t want to use CSS unless the same can be done with bootstrap ) . please use codepen link to see the rendering.

codepen link

HTML

``````<div class="row ml-5">
<div class="form col-4 mt-5">
<div class="form-group">
<lable>First Number</lable>
<input id="firstNum" type="text" class="form-control"/>
</div>
<div class="math-buttons">

<div class="btn btn-primary col-12 mt-2">
+
</div>  <div class="btn btn-primary col-12 mt-2">
-
</div>  <div class="btn btn-primary col-12 mt-2">
x
</div>  <div class="btn btn-primary col-12 mt-2">
/
</div>
</div>

<div class="form-group mt-3">
<lable>Second Number</lable>
<input id="secondNum" type="text" class="form-control"/>
</div>
<div id="btnCalculate" class="btn btn-primary col-12 mt-2">
Calculate
</div>

</div>
<div class="output col-4 my-auto ml-5">
<h4 id="result">
0.00
</h4>
</div>
</div>
``````

CSS

``````.math-buttons>.btn{
display:inline;
margin-left:10px;
}
``````