KPI one week selection by default

[employe4_2]

Hi ,

i'm looking to  create an app where i got a Chart and a kpi, where the KPI indicated wether or not the chart got over a threshold. but i load around 3 years of data , and i only need like a week. Also i'm using seconds 1904's to time measurement..

thx

[Yoshidaqlik · Accepted solution]

Hi,

all well?

Can you give an example with print of the graph you want to arrive?

I do not know if I understand correctly but of all uploaded data just need to display the last 7 days

it would be something like:

Aggr(
	if(
    	dimension_date >= (dayname(max(total dimension_date))-7),
        dimension_date
    )
,dimension_date)

Regards

[employe4_2]

I want to create an indicator to tell the status of a machine. Which is a yes no indicator!   yes if average value of last week is above a certain value ( and not average of all time) . That's it.

Also, i'm working only on sense, i can see there is a realtion between sense and view but still, if you can put in the context of a sense usage..

thx

[employe4_2]

i juste remove the aggr () and put it as an alternative dimension.

Maybe i'll try with some BookMark, with default bookmark applied ( i saw that somwhere, don't remember yet)

But still, i'm trying to use the extension "variable input" or "Field UI" or "SimpleFieldSelection"

and with those, it seems possible but jeez i'm bad