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: [ill] I want to show in a KPI the valu…

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 [image] You may apply the same concept to compare the sales for a day range. I have 2 parameters in my example [image] [image] And added 2 calculated fiel…

you may use conditional formatting [image]

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.

Yes. The filter does not have the effect that I want. Here is an example. [Screenshot 2023-06-30 at 18.55.40] [Screenshot 2023-06-30 at 18.56.12] The dates in the KPI don’t change.

in this case, do you want to show Jun28 compare with Jun30?

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).

How to show an entry of a table in a KPI?

Q&A

royyung July 3, 2023, 5:19pm 10

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

Topic		Replies	Views
Change colour of KPI (count of cases) compared to previous week/month Q&A parameters , formatting , quick-sight , Business-Intelligence-Engineer	5	367	April 2, 2024
Create a KPI visual that compares to the previous period Q&A period-over-period , feature-request , quick-sight , Business-Intelligence-Engineer , kpi	5	968	October 14, 2024
KPI Card - MTD Q&A quick-sight , Business-Intelligence-Engineer , kpi	3	61	March 28, 2025
KPI Error- The secondary value(comparison metric) stops displaying when I apply a date filter Q&A developer , quick-sight , dashboard-embed	13	83	May 6, 2025
Conditional Formatting for value over time Q&A formatting , quick-sight , calculations , pivot-table , Business-Intelligence-Engineer , tables	3	98	February 7, 2025

How to show an entry of a table in a KPI?

Related topics