121 questions
1
vote
0
answers
17
views
How to Create a Month Over Month KPI that Adapts to User's Date Filter in Amazon QuickSight?
I'm trying to create a KPI that shows Month Over Month (MoM) performance and adapts to the month my user is filtering in QS. My approach is to apply the date filter to everything except this KPI.
Here ...
0
votes
1
answer
45
views
Fill Smileys in Power BI with Colors by conditional formating
I am using the conditional formatting in Power BI based on other measure like below :
My goal is to fill the smileys with colors, but filling it with colors doesn't work.
The smileys I use have the ...
0
votes
0
answers
62
views
Recurrence in DAX with SUMMARIZE AND FILTER
I have a problem in DAX when displaying a metric in an area chart. The goal is to represent unique users who have performed a number of actions equal to or greater than [n_veces] during the last [...
0
votes
0
answers
18
views
Power BI Visual to show category performance wrt different KPIs
I have several KPIs in my report. Is there a visual to show , how different categories are performing wrt those KPIs?
PFB sample data and the visual I would like to create in Power BI desktop.
I want ...
- 43
0
votes
0
answers
15
views
How do I restart the timer when switching a case status back to In Progress after receiving the required information from the customer
A case is created with the status In Progress which starts the timer. Additional information is required from the customer and the status is set to Awaiting Info From Customer. This cancels the timer. ...
- 11
1
vote
1
answer
46
views
Power BI Bullet Type Visual
I am creating a Power BI visual similar to the one below with the sum of Actuals, Budget, and Forecast for each Site with a chart next to each.
Visual
Next to each, the chart would indicate the ...
- 13
0
votes
0
answers
105
views
Discrepancy between Day 1 retention rates in Firebase and Google Analytics 4 (GA4)
I recently conducted an A/B experiment using Firebase to analyze the Day 1 retention rates for version 1.2 of my app. After analyzing the results, Firebase reported a Day 1 retention rate of 28% for ...
- 11
0
votes
1
answer
38
views
Create an aging KPI where the target/status changes based on a category in SSAS Tabular
I am trying to create a single KPI for support ticket age, but the status needs to take into consideration the "Status Category". I am struggling to figure out how I would set a single KPI ...
- 313
-2
votes
1
answer
61
views
Calculate the hub time for a ticket for each team
I need to find the total time a ticket spent in each team domain.
The time start for one team from the arrival of the ticket until it leaves their domain to another group.
If the ticket comes back ...
- 65
0
votes
0
answers
49
views
NetSuite Transaction Saved Search by Period - KPI Scorecard
I am trying to create a transaction saved search to apply to a custom KPI Scorecard.
The transaction saved search requires the 'Available Filters' Period filter since the custom KPI Scorecard has the '...
- 1
0
votes
2
answers
70
views
JMeter Performance Metrices for Load Test
What are the Performance Metrices or KPI indicators such as Response Rate, Throughput, Hits per second etc that need to be considered when doing a Load test for a commercial Web application using ...
0
votes
0
answers
28
views
Lines are displaying while rendering tile based kpi(mbtiles) on map
I have mvt layer which has icon layer on it,I'm using deck gl for data visualisation on map, on mbtiles loading I see dashed lines at the junction of each tile on the icon layer, please suggest me a ...
0
votes
1
answer
271
views
How to use formula in netsuite saved search
I want to create Custom KPI saved search for Dashboard view.
Custom field 'KPI Account Group' created to classify accounts into groups for KPI formulas
Custom List: KPI Account Group
Values: Expenses, ...
- 13
0
votes
1
answer
39
views
How to render a new chart each time a new record is added to the table in Oracle Apex
I'm developing a system using Oracle Apex. I have a table called PM_KPI, this table contains information about KPIs, each record of the table represents a new KPI. What I want to do is that, for each ...
0
votes
1
answer
547
views
Change direction of trend arrow in Quicksight KPI chart
I am frequently using the KPI chart in Quicksight and particularly focusing on the displaying the trend arrow comparing the current with the status before. However, the trend arrow should not go up ...
- 498
0
votes
0
answers
207
views
KPI Showing the total % instead of the last % - PowerBI
I have a set of KPI cards I am creating that I want to show the total percentage instead of the last %. I have tried using the stand alone Microsoft KPI card and I have also tried the KPI Indicator ...
- 17
0
votes
0
answers
175
views
KPIs not up to date - Power Bi Reporting Server
I have an on-premises Power Bi Report Server. I have created several datasets, and schedule of refreshing datasets with new data every 5 minutes which is attached to datasets. I can see the datasets ...
0
votes
1
answer
137
views
Can I add kpi with maximum values without contraining CPLEX model?
I am using cplex for an optimization model, to optimize diet compositions. Now I would like to add an extra variable/KPI, which is the sum of other KPIs in the model. However, this sum is a score with ...
0
votes
2
answers
2k
views
SWITCH TRUE WITH OR in power bi dax
I have 15 columns in a power bi table. I would like to create new measure that will return the column names if the percentage value of any columns is less than 60%.
Example table:
ID
total
col2
col3
...
- 185
0
votes
1
answer
493
views
Enable custom time calculation of SLA KPIs
I wanted to enable custom time calculation for SLA KPIs which is provided in the following link:
Enable Custom time calculation of SLA KPIs
However, could you please help me with plugin. I do not ...
- 5
0
votes
0
answers
20
views
Selected data not visually being displayed in Qlikview?
Before importing this single sheet into Qlikview, I had 2 data sets, one from 2016 Olypmics and the other from 2020 in two different Excel files, I combined the sets of data into one so I could ...
- 29
0
votes
0
answers
304
views
Trying to compare a value between two data sets in Tableau but its not displaying correct details
I'm relatively new to Tableau and I have 2 data sets, one from 2016 olympics and one from 2020 olympics.
I want to compare the results from 2016s "Total" amount of medals for each country ...
- 29
0
votes
1
answer
59
views
Tableau not displaying the correct figures when trying to compare and visualize data
I've joined 2 data sets together, one of 2016 olympics and 2020 results and I want to create visualizations and compare the two "total" amount of medal values for each country.
When adding ...
- 29
0
votes
0
answers
14
views
Unable to run my KPI query in Tableau without syntax error
In tableau i'm trying to create a KPI based on the "Number of disciplines entered by continents", so i'll have for example a pie chart of continents with a figure in each saying how many ...
- 29
1
vote
1
answer
75
views
Calculation contains errors for KPI in Tableau
I'm trying to create an API which will tell me the sum of metals awarded across the top 10 countries in my data of the olympics so I can create a visualization of it.
When creating the API i'm ...
- 29
1
vote
1
answer
684
views
Time as an independant dimension outside the dataset in Quicksight
I am using the KPI visual in quicksight to show the change in a calculated field from one month to the next.
My data is transactional data. Each record in the db includes a "transaction date"...
- 61
1
vote
0
answers
307
views
TIBCO SPOTFIRE KPI
i have a kpi depending on a property setting (check-box). Then in the check-box list i have two different value: a, b (corresponding to the values in column propertycolumn).
Depending on this value i ...
- 11
0
votes
1
answer
4k
views
How to calculate average percentage in PowerBI?
Hi everyone,
I'm still new to PowerBI, right now I have a set of data in PowerBI as shown in the screenshot above. I have a Measure to calculate the % of OK:
total_student = COUNT(StudentAns[Name])
...
- 1,105
0
votes
1
answer
691
views
How can I visualize a revolving multi-year KPI with unique monthly targets in Power BI?
I need help developing an approach for a line chart that visualizes actual sales against a monthly KPI sales goal over 24 months.
We have an annual sales goal, tracked until completion for two years ...
- 3
0
votes
1
answer
165
views
How to access and read data from a play console KPI from a backend server?
I need to read the data from one of my Android App's Play Console KPIs (engagement, total number of downloads etc.) from our backend server.
Is there any method to do so? I was looking for an API but ...
- 1
2
votes
1
answer
837
views
AWS Quicksight calculated field average
Hi I am having trouble with this calculated field. I am trying to get the sum of money_val for each customerkey. Then I want to have a KPI visual to show the average money_val. I found that PRE_AGG ...
- 137
0
votes
1
answer
403
views
Create a KPI with a timestamp and a groupby in pyspark
I have a dataframe containing logs just like this example :
+------------+--------------------------+--------------------+-------------------+
|Source |Error | @...
0
votes
1
answer
238
views
I need to create a KPI in NetSuite. "Items Received Per Week KPI"
I need to create a KPI in NetSuite. "Items Received Per Week KPI", any help? I need this graph and it is not providing a metric to create a graph.
0
votes
1
answer
868
views
Power BI - dynamic "Goals"label in a KPI visual
Is it possible to make the "Goals" label dynamic? Instead of showing a static text like "Previous month" (or whatever), I would like it to show the name of the previous month. ...
- 5,145
1
vote
1
answer
6k
views
How to Configure Callbacks to Cards in Plotly Dash App
I'm working on creating a Python-based COVID19 dashboard with Plotly Dash. I want to have some cards near the top of the page displaying population/case/death KPIs that update based on the selection ...
- 911
0
votes
0
answers
902
views
SQL / Banking / Transactions: Customers with more than one month's income
Hi I have a table "transactions" with few bank transactions from different customers. In that table I also have the date for every transaction as well as their monthly average salary. ...
- 309
-1
votes
1
answer
858
views
Ranking the Resulting Values of Measures in Power BI
Please help.
I am trying to create a dashboard (one-page) that shows KPIs of multiple groups. There are 10 groups and each group is represented with a box and the box is showing the group's %...
- 1
0
votes
1
answer
96
views
Clustered Bar Chart with Two Colors
I want to create the below chart :
Expectation : I want to show the two colors like in above image. one for Actual Percentage and second for total ( like 100%).
My chart look like below :
How can I ...
- 95
1
vote
1
answer
63
views
Power BI - Extract / Moving value to a separate column
I have a column that includes 2 different values for more than 100k customers
The values are: "Consumer" , "SMB"
How can I move "SMB" values to a separate column ? I want ...
- 33
0
votes
1
answer
315
views
Odoo version 13: Email digests & KPI's
I am trying to create a new KPI in the Digests model to show the number of new customers created per week. (Unfortunately, this functionality is not well documented).
As documented, I have created two ...
- 11
0
votes
2
answers
1k
views
I am working on Bootstrap spinners , i am stuck with load spinner whenever we click a button
<div class="container">
<h1 id="Tickets"><span class="spinner-grow text-muted"></span></h1>
</div>
Here i am showing a normal ...
- 93
0
votes
1
answer
97
views
Is there a metric monitoring platform that allows caching on metric side and timestamp at beginning of ROI
Here is my issue, I am looking for a monitoring platform that allows fetching metric from remote server and then digest the metric to create KPIs.
The remote servers are connected to the network ...
0
votes
0
answers
35
views
How I share my Dashboard with Other on Free version of Power BI
I have a dashboard and i want to share with others. So I go to
File => Publish to Web
But i gives me an error "Contact Your admin" . So i go to "Admin Portal" and trying to enable the option "
"...
- 95
0
votes
1
answer
2k
views
How to make a score from multiples KPIs
I am wondering if is it possible to create a global score using multiple KPIs with different scales.
Example:
I would like to join all this KPIs in one score that could tell me what version is ...
- 3,626
0
votes
0
answers
51
views
Power BI Matrix Visualisation compare columns
I am trying to take the following data set (example data source)
|PAF TYPE |dbvalue |volume |date_run |
|---------------------+----------------------+------------+--...
- 1
1
vote
0
answers
181
views
Where to store and how to calculate user metrics
I'm developing a backend REST app using AWS API Gateway that is connected to AWS Lambdas and stores transactional data in AWS RDS MySQL DB. I need to calculate a certain set of business metrics like ...
- 31
1
vote
0
answers
103
views
Making a function that calculate a staggered function in power bi
I come to you with the following challenge. I need to do a KPI on Power BI related to maintenance sector -calculate the Availability of certain machine -. The formula to calculate is the following one:...
1
vote
1
answer
145
views
Excel: check hours in sequential order, same column, when criteria is true
I have a DB which contains shipping orders for different clients, one shipment can have more than one dispatch with different estimated arrival times, the logic is: dispatches on each route must ...
- 13
0
votes
0
answers
285
views
Is there a METABASE-like data visualization tool with time-series feature?
We use Metabase to monitor our KPIs, such as total current active items.
It's a great tool, but when we needed to look at timely trends such as total current active items change by day.
Metabase can't ...
- 1,299
0
votes
1
answer
32
views
Store machine status on Graphite time-series to later extract KPIs
having a machine which sends (not regularly) its status values 0, 1, 2, we're storing it in Graphite. Now the status means:
0 - stopped
1 - working
2 - stopped by anomaly
The requested KPIs to ...
