Average of 2 Formula Indicators
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā09-22-2023 01:43 AM
Hi
I have created 2 different formula indicators now i want to find the average of the both, but i am having issue in finding results it says no data available. Formula is - ([[CSAT]]+[[HR]])/2.
Please help me find the solution. What can be the issue??
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā09-26-2023 03:31 AM
Hi @groverdhairya ,
If both automated indicators is present, but one doesn't have any data in it, then you need to fix that one. What that one gets populated with data, then your formula indicator should work as expected.
if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Best regards
Anders
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā09-26-2023 05:28 AM
Hi @AndersBGS
Shouldn't it take it as 0 and provide the average. is this limitation or something.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā09-26-2023 05:41 AM
Hi @groverdhairya ,
Hope the 'Unit' field of both the automated indicators is #(number). Once u get the output as numbers from the automated indicator, your formula indicator should work as expected.
Please mark my answer helpful & accepted if it helps you resolve your query.
Thanks,
Danish
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā09-26-2023 06:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā09-26-2023 06:12 AM
Can u share the screenshot for those configuration(automated indicator) if possible.
Thanks,
Danish