KPI Counter not displaying total when no filters selected

[scottzambonini]

KPI ticker

Hi there, 

I have a KPI ticker inserted. I cant seem to get the sum total values for goal and spent to date to display as default when dashboard loads, only when I select specific items does it update correctly.
data

[copykai]

Hi Scott,

The KPI Visual is built to show the latest value only and also the Trend.

A small hack is to add a calculated column where all the values are equal to 1.

If you add this to the Trend Axis you will get the Total SUM but this will remove the Trend Line in the visual.

From my experience you cannot have both in the KPI Visual.

Best

Kaj

[scottzambonini]

Sorry to sound daft, can you explain the calculated column?

---

@copykai wrote:

Hi Scott,

The KPI Visual is built to show the latest value only and also the Trend.

A small hack is to add a calculated column where all the values are equal to 1.

If you add this to the Trend Axis you will get the Total SUM but this will remove the Trend Line in the visual.

From my experience you cannot have both in the KPI Visual.

Best

Kaj

---

[copykai · Accepted solution]

Inside the table where the measure uses a column, you can simple add a calculated column with the formula:
IsData = 1

This will add 1 to all the records for that column in that table.

In the visual you replace the Trend Axis with this new column and you will get the SUM because you eliminate the Trend Line.

But as I mentioned this might not be the solution you're looking for if you want a trend line 🙂