giu | Cross platform rapid GUI framework for golang | Frontend Framework library

I have a database of 10 years and i would like to select the date that goes from 01-october-2015 to 01-jannuary-2016 and the date from 1-jannuary-2016 to 1-jun-2016 for every years. Here is my code:

I have a pivot table like the one in the image:

The table updates every month. The question is: how can I dynamically get the last value of the table with a function, without VBA? For example, in this case the last value is -32, just above the "Grand Total" value. I'm considering to use the function "GETPIVOTDATA" but I don't know how to change the dynamic reference to the last value inserted. At the moment, the formula looks like this:

I am playing with running spark jobs in my lab and have a three node standalone cluster. When I execute a new job on the master node via CLI spark-submit sparktest.py --master spark://myip:7077 while the job completes as expected it does not show up at all on the cluster GIU. After some investigation, I added the --master to the submit command but to no avail. During job execution as well as after completion when I navigate to http://mymasternodeip:8080/ none of these jobs are recognized in Running Jobs nor Completed Jobs. Any thoughts as to why the jobs dont show up would be appreciated.

In my app.module.ts I added this code:

I need a way to force the compaction of the __consumer_offsets topic. In a test environment I tried to delete the file cleaner-offset-checkpoint and then kafka deleted many segments as you can see below. Is it safe to delete this file in a production environment?

Before removing cleaner-offset-checkpoint:

In this example I have a date field, and I use it for tooltips and legend.

I would like to have it Italian. I know I can add timeFormatLocale config, but how to use it in the editor?

I need help with writing a case statement inside of a where clause.

Let's say we have a bunch of serial numbers stored in a database. They are prefixed with some letters to denote their group.

Here is what I need to accomplish:

Exclude all serial numbers that begin with 'GIU' unless some conditions apply:

• If the serial number starts with GIU and is 15 chars long and the last 4 numbers are less than 5000, then exclude it, otherwise include it.
• If the serial number starts with GIU and is 16 chars long and the last 5 numbers are less than 10000, then exclude it, otherwise include it.

ex. GIU930798246071 should be included because: begins with GIU -> 15 chars long -> 6071 > 5000.

ex2. GIU9307982410621 should be included because it begins with GIU -> 16 chars long -> 10621 > 10000.

ex3. GIU930798243071 should be excluded because 15 chars long -> last 4 digits (3071) < 5000.

If I wanted to run a query to count these results, I tried:

I fetch data from json and try to display one of the arrays in my componenet but I get an error that map is not a function, what do I do wrong? How to get only one array of two? Is it array I have in json or an object?

I'm using Oracle SQL Developer and i have the following select: