Messages postés par Madeleine

@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,

Bonjour,

Is it possible calculate the difference between Feb 2023 vs Jun 2022 or between Jan 2022 vs Dec 21, I need to see the calculation between any two months selected

Merci beaucoup

Hello,

How to create a calculated measure that calculates the variation between the 1st and the last value of a selection.
For example, if we select Feb 2022 and Aug 2022 we want to see Aug 2022 vs Feb 2022., or Feb 2023 vs Feb 2022
I need two columns: in first column to see the values for the first selection and in the second column to see the values for the second selection.

I create a calculated measure for Previous Month and one calculated measure for Current Month, I can select any month from the previous years vs Current Month but I can't select two months from the previous year.
I don't know what to use for the second column, instead of Current Month.

I tried all the functions from Digdash

Thank you,

Bonjour,

I need your help regarding the data source: how to overwrite a data source without affecting the flows.

Merci beaucoup pour votre aide.
Bonne Journee

I have done my selections of KPI. I would like to share it with a colleague in order to let him do this selection periodically. It is possible to export a selection or to import one?

Merci beaucoup pour votre aide.

Hi Gregory,

it only works in this format:
<Value(sum)>/<Month-1(NO_AGG)>-1

Thank you,
Madalina

Thank you again for your help.

@gregorybiraud a dit dans How to calculate month over month growth :

(measure - measure (M - 1) ) / measure (M - 1)

Thank you for your support and response but unfortunately is not working

I have created "Month-1"

• associated measure "value"
• aggregation: sum
• dimensions per axis: "dateyearmonth"
• filter: off
• transformer on: shared function - "Month-1"
• exploration: none

and I have created "(measure - measure (M - 1) ) / measure (M - 1)":

(<value(sum)>-<Month-1(NO_AGG)>)/<Month-1(NO_AGG)>

but the result is NAA

Hi,

I need your help to calculate month over month growth

I know the formula- "subtract the first month from the second month and then divide that by the last month's total. Multiply the result by 100" but I don't know how to apply it in Didgash.
Thank you,
Madalina