Hi!
I created the following calculated field:
periodOverPeriodDifference(sum({column}),date, DAY, offset)
However, I can only create a Table showing the values. I want a KPI that shows the value corresponding to the current date.
Here is an illustration:
I want to show in a KPI the value circled in red. How can I do that?
you may use conditional formatting

1 Like
Thank you for the answer.
However, I don’t know how I can use conditional formatting to show an entry of the table in a KPI.
Yes. But I want the reader to be able to choose the starting and ending of dates that he wants to see in the KPI.
did you try adding a filter?
1 Like
Yes. The filter does not have the effect that I want.
Here is an example.

The dates in the KPI don’t change.
in this case, do you want to show Jun28 compare with Jun30?
1 Like
In this case, yes. But this was just an example.
My aim is to define parameters for the starting and end dates (for the users to choose the range of dates).
you can create 2 control. in this example, day1, day2. user needs to choose them and it shows the comparison of the sales for this 2 days

You may apply the same concept to compare the sales for a day range.
I have 2 parameters in my example
And added 2 calculated fields


And includes these 2 fields in the KPI
1 Like