I want to see (a KPI) value from last week, without to select last week, staying in selection from this week.
What function or if condition can I put?
I have in my sheet: years, months and dates from months.
Solved! Go to Solution.
Write Logic in script for year and week day
year(Datefield) as Year,
Week(Datefield) as wkday
After Front end write this one:-
Year and wkday fields take as filter.
I have in my .xls: week (Date) and values (H) from every week.
I have dimension: week(date)
I want to select this week and to show in a KPI the value from last week.
Sorry, I don't know how to atash the app.