@gregorybiraud

Merci beaucoup!

Bonjour,

I need your support regarding the following subject.
I need to display "Date debut" as Year ( 2020 / 2024 ).
I need to display the year instead of dd/mm/yyyy.

I have created a new column with the following:
var dateDebut = values[27]; // Assuming values[27] contains a date string

// Check if dateDebut is a valid date string

if (typeof dateDebut === 'string' && !isNaN(Date.parse(dateDebut))) {
var dateObject = new Date(dateDebut); // Convert to Date object
var year = dateObject.getFullYear(); // Extract the year

if (!isNaN(year)) { // Ensure the year is a valid number
    return new Date(year, 0).getTime() / 1000; // January is 0
} else {
    console.error("Invalid year extracted from date");
}

} else {
console.error("Invalid date string");
}

but without any success.

please advice,

Merci

@gregorybiraud

Hi,

you are right, sorry my mistake.

Merci.

Hi,

I would like to create a calculated measure with the following criteria:

Aggregation: Dcount
Dimension: ID

Condition: (v)

if(v > 0) {
return true;
} else {
return false;
}

The issue is that in the filed "Measure" only the measures from the data source are visible.

Please advice.

@gregorybiraud

Hi Gregory,

please see the calculated measure and some screenshots.

Bonne journee,
Madalina

Hi Gregory,

I created a calculated measure

Nb jours disponibles

var x = <Capacité(max)>;
var y = <Prévu annuel(max)>;

if ( ( x-y ) < 0 ) {
return 0;
} else {
return (x-y);
}

the result is 0 , please see screenshot "Nb jours disponibles 1"

when I insert Personne and Site, and add an Overall with aggregation sum the result is ok

If I remove Site and Personne the result is 0

Merci beaucoup pour votre aide,
madalina

Hi,

I need your help.

I would like to create a calculated measure depending on two dimensions: site and ID

This works in a table by adding the Site and the ID dimensions but when I remove the two dimensions the value of the calculated measure is changing.
I would like to use this calculated measure inside a flow type text.

Thank you in advance

Bonjour,

J'ai besoin de votre aide pour creer une mesure calculee pour afficher les sum de le max valeur.

j'ai cree un mesure calculee : "Max" mais je ne peux pas creer un mesure calculee to sum all of all max values

J'ai besoin de voir le total dans un "Text" flow

Merci in advance pour votre aide.

Merci beaucoup pour votre aide, mais the result is not ok, returns -1, no change

Hello,

I created a calculated measure to see:
var x = selected month
var y = month -1

if x >= y return 1
if x < y return -1

but the issue is that I don't know how to get the result 0 if x == NaN or 0 or
y == NaN or 0 or
x == value and y == NaN

please see column Matrix 1.3

var x = <Selected Month(NO_AGG)>;
var y = <Month-1(NO_AGG)>;

if(x < y ) {
return -1; //
} else if (x => y && x,y!=0 ) {
return 1; // ok
} else {
return 0 // code that will execute if all above conditions are false

}

Thank you for your help,