String-like KPI?

Q&A
, ,
1

Hello,

I have a dataset with a column called units_online. This is a precalculated data that display string like 5/5 (5 out of 5 online).

I would like to display this in a KPI-like object in my dashboard, but I can’t seem to think of a way as I only require to display this dimension ONLY without any measure.

What are the options or workaround to do this?

Thanks.

2

Have you considered using the Insights visual?

3

Do you mean units_online column may have multiple values, like 5/5, 5/6,3/7 …
and you want to show a comparable measure for this field?

if this is the use case, i can think of fetching numerator and denominator from the text field separately and then create a ratio. this measure can help you create the kpi like comparison. However since you want to hold on to the dimension of 5/5, you can add this as a tooltip to your visual.

If this is not the use case, please add sample data, so that we can understand your use case better.

4

Hello,

The sample data looks like

Id, units_status
1, 4/4
2, 5/8
3, 8/8

What I want is for an object to show the units_status when user filter by id (Id is a parameter in my dashboard).

I can’t get it to work on insight visual, does it not require dimension and measure?

5

Hi @dixerio,
As KPI’s only allow you to run a ‘count’ or ‘count distinct’ calculation on string fields, you would need to utilize an insight to accomplish this has Giri mentioned.
Where in the insight process did you run into complications? You can follow the steps on the attached article to walk through the creation.

Let us know what part you get caught up on and then we can try to assist further.

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

6

Hi @dixerio,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!