Daten von gestern anzeigen

[merry2018]

Hallo Zusammen,

ich benötige mal wieder eure Hilfe und zwar möchte ich in einem Diagramm die Daten von gestern anzeigen, ohne das eine Auswahl auf Tagesebene getroffen wurde.

Es wird immer nur die Woche ausgewählt und trotzdem soll heute die jeweilige Schicht von gestern gezeigt werde, wozu es drei (F, S, N) Diagramme gibt, für jede eine.

Überlegt habe ich es zb. folgend:

sum({<Tag={'max(=$(=(Tag)))'}>}if(Schicht='F', Dauer))

Aber sicher bin ich mir nicht, da das eigentlich ja vorschreibt, dass der aktuelle Tag selektiert ist, was aber nicht sein darf, da parallel auch Diagramme sind welche die ganze Woche zeigen oder so.

Danke für eure Hilfe schon mal und Grüße

Merry

[felipedl]

Hi Merry,

If your day field is a number (or dual representation, with number and text) you can do arithmetic operations to add days on it to show the previous day.

sum

(

     {<

          // gets the max day (selected or not) and subtracts one to get the previous day

          tag = {"$(=max(day)-1)"},

          // shift type F

          shift={"F"}

     >}

     duration

)

[merry2018]

The field day i don't have, which you mean there I can taken?

Can I do some with the today()  or the same fild, so i mean Tag?

[felipedl]

Ah, sorry Merry, the browser translated the Tag to day automatically from German to English.

What's the datatype of your Tag field, when you put it on a listbox, does it align to the left (meaning it's interpreted as a text) or to the right (interpreted as a number).

You could use today()-1 for instance, if you have a numeric or dual type of data.

[merry2018]

It is a number, because it align to the right.

Ok, now I think it's working.

Thank you!

[felipedl]

Glad it helped .

Can you mark the anwser that helped you as correct so other in the community might see it as well?

Regards,

Felipe.

[merry2018]

If i use today(), probably i should use the KeyDatum, that they have the same Format (both 'DD.MM.YYYY') and not only one with Day and one with Date?
For that way is that the correct form:
<%_Key_Kalender= {"$(=(today()-1))"}>

or what is wrong, thats not working?

-Merry

[merry2018]

Yes I will do, if I am finshed and have the correct way.

[merry2018 · Accepted solution]

I have solved it now via a flag in the calendar, because I unfortunately did not get the formula and the first did not work completely.

[felipedl]

Good to know Merry post your solution and mark it as correct, might help other on the community.