Analytics Questions

I'm trying to create a similar KPI that I have in Tableau but am unfamiliar with DAX in Power BI. I was able to develop a threshold of incidents by
exclude fiscal year : sum([incidents]/[countdistinct FY]) which gave me the average number of incidents per year. I'm trying to do the same within Power BI, however I need to sum(countdistinct(incident#))/ countdistinct (FY). The goal being to be able to see how the current year is doing in terms of incidents based on the average amount of incidents for each FY.

0 Comments

Exploring SharePoint 2016

LVL 19

Explore SharePoint 2016, the web-based, collaborative platform that integrates with Microsoft Office to provide intranets, secure document management, and collaboration so you can develop your online and offline capabilities.

I would like the following SQL statements to display in one view summarising the data instead of duplicating the data across the table.

All the data I need is there I just need to display it with common sense and analytics

SELECT NomAccNo, MAX(NomAccDesc) AS NomAccDesc, SUM(Credit) AS Credit, SUM(Debit) AS Debit, MAX(Type) AS [Type] FROM dbo.SalesAccDet GROUP BY NomAccNo
Select NomAccNo, MAX(NomAccDesc) AS NomAccDesc,SUM(Debit) As Debit, SUM(Credit) As Credit FROM dbo.SLControlAcc GROUP BY NomAccNo
Select NomAccNo, MAX(NomAccDesc) As NomAccDesc, SUM(Credit) As Credit, SUM(Debit) As Debit, MAX(Type) As [Type] FROM dbo.BankControlAcc GROUP BY NomAccNo
Select NomAccNo, MAX(NomAccDesc) As NomAccDesc, SUM(Credit) As Credit, SUM(Debit) As Debit, MAX(Type) As [Type] FROM dbo.PurchaseAccDet GROUP BY NomAccNo
Select NomAccNo, MAX(NomAccDesc) AS NomAccDesc,SUM(Debit) As Debit, SUM(Credit) As Credit FROM dbo.PLControlAcc GROUP BY NomAccNo
Select NomAccNo, MAX(NomAccDesc) As NomAccDesc, SUM(Credit) As Credit, SUM(Debit) As Debit, MAX(Type) As [Type] FROM dbo.NomAccDet GROUP BY NomAccNo
Select NomAccNo, MAX(NomAccDesc) AS NomAccDesc,SUM(Debit) As Debit, SUM(Credit) As Credit FROM dbo.VATControlAcc GROUP BY NomAccNo

5 Comments

I have been asking Google to help me with this for 4 weeks but even though they say my set up is correct, data is not importing and we have spoken for hours at a time yet they say they need more time to fix the problem.

I have First Click attribution e-commerce sales showing up in my Google Analytics account, which is linked to my Google Ads account for automatic import. The conversions I am importing I have specified as First Click attribution conversions.

Despite this, only 4 of the 30 transactions recorded in Analytics have imported and I can't seem to identify a pattern. I thought it was ignoring the First Click setting and just using Last Click, but that didn't seem to add up, then I thought maybe it was only for non-mobiles that it worked but that's not conclusive either.

Any ideas would be hugely appreciated.

Kind regards,
Mike

0 Comments

LVL 1

Question by

fb1990

2019-10-31

Google Cloud Platform and MS Power BI

Hello EE,

Can someone tell me if Microsoft Power BI can be implemented with Google Cloud Platform for visualization?

Thanks

0 Comments

How to pull the reports from Citrix Cloud published XA and XD information, without Citrix analytics tool.
Citrix Environment: Citrix Cloud
Provisioning technology: MCS
HSD/ VDI OS: Windows2016 and Windows 2012R2, Windows 10
Hypervisor: Azure and On-Prem
Problem: How to pull the reports from Citrix Cloud published XA and XD information.
Citrix Analytics is part of workspace premium packages. We don't have a premium package to use the Citrix analytics tool.

5 Comments

Oracle BI Publisher Template : The template is working fine in 11g but failing with OBIEE 12C.
Template file and data is attached.
11G-template-orig.rtf
12c_MGAGMonthlyFinancialPacket_.xml

0 Comments

I have been trying to using "Internal Promotions" within google analytics and it does not seem to be working correctly for some reason and I was curious if anyone had any idea on what to try next. I have it setup so I am firing a custom event that triggers within Tag Manager to track both the "Promotion Views" and the "Promotion Clicks"

Here is the data I am passing in the dataLayer.

Promotion View:

Promotion Click:

From my understanding the promotion should be attributed to the next transaction/purchase that happens. However I never get any transaction associated with the purchase. However if I look at my Product List View the products are still getting the attribution. I didn't think I had to do anything else except fire those when they occur.

If anyone has any ideas on what to try, I am open to suggestions. Thanks.

1 Comment

I want to use awstats with weblogic logs

This is the log

#Fields:        c-ip date time cs-method cs-uri sc-status bytes time-taken
#Software:      WebLogic
#Start-Date:    2019-10-23      00:00:06
192.168.112.140 2019-10-23      00:00:07        POST    /es.finconsum.arq.webservices.natural/services/WSBCPCFINCConsultaScoringProactivo        200     4565    5.366

Open in new window

format extended and extended logging format fields: c-ip date time cs-method cs-uri sc-status bytes time-taken

in /etc/awstats/awstats10.weblogic_ccf_lpfcashwlg0.conf I configure
LogFile="bzip2 -dc /var/log/awstats/caixabank/lpfcashwlg0/*.bz2 |"
LogFormat = %host %time2 %method %cs-uri %code %bytesd %other

Open in new window

And when I execute /var/awstats/wwwroot/cgi-bin/awstats10.pl -config=weblogic_ccf_lpfcashwlg0 -databasebreak=day -update -showcorrupted it resolves all lines as corrupted

Corrupted record line 216523 (record format does not match LogFormat parameter): 192.168.112.140        2019-10-22       23:59:59        POST    /es.finconsum.arq.webservices.natural/services/WSBACCFINCConsultaDatosCliente   200      3991    5.743
Jumped lines in file: 0
Parsed lines in file: 216523
 Found 1 dropped records,
 Found 216522 corrupted records,
 Found 0 old records,
 Found 0 new qualified records.

Open in new window

Can you help me? I don´t find where is the error

If you need any other data please request it

0 Comments

Ok, so I start an ad campaign on Facebook. But several of my fellow employees, some of whom enter orders many times a day, have liked my Facebook page, and an ad may appear on their timeline. Now I don't know if just seeing the ad can skew the results, but I want the people in my office not to be counted when the results come in. There's no IP filter like there is on Google, what can I do? Thanks.

2 Comments

I am struggling with PowerBI and I need to show that data in a certain way.

I have the data set with a Days Completed, and I want to show the number of tickets completed in 0 days, 1 days, and 3 days for the last three months.

The data goes back almost a year and I cannot figure out how to do it
DATA-Annotation-2019-10-11-095147.png
InkedAnnotation-2019-10-11-095147_LI.jpg
TablesAnnotation-2019-10-11-100441.png

0 Comments

We have a client that has migrated to Dynamics 365. We are having issues that sometimes users experience the system to be slow. How can I pull API reports for specific users? I see the general Common Data Service Analytics report and we only did 410 000 API calls and 61 011 Executions over the last 24 hours. Any ideas on how I can troubleshoot this?

1 Comment

I am getting the following error from my Web application. The application compiles without error but when I try an run it locally using F5 I get this error. I have cleaned the solution, re-generated WebForm1.aspx.designer.cs and re-installed all nuget packages but still getting the same error. ComboBox1 belongs to AjaxControlToolbox. I can understand how I get a successful build and then at run time it fails to compile successfully. Any ideas why ?

Server Error in '/' Application.
Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS0103: The name 'ComboBox1' does not exist in the current context

Source Error:

Line 116:
Line 117: restoreSessionParms(); // restore parameters from previous call
Line 118: ComboBox1.Focus();
Line 119:
Line 120: //TEMP CHECKS

Source File: C:\Users\PatClarke-DataManage\source\repos\TiosClient\TiosClient\WebForm1.aspx.cs Line: 118

Compiler Warning Messages:

Show Detailed Compiler Output:

Show Complete Compilation Source:

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4001.0

Webform1.aspx

<%@ Page Language="C#" AutoEventWireup="True" CodeBehind="WebForm1.aspx.cs" Src="WebForm1.aspx.cs" Inherits="TiosClient.WebForm1"

Open in new window

…

2 Comments

Dear Experts
We are using CRM application which uses MYSQL database. we have customized the CRM application for our core process therefore the CRM modules marketing, sales and contacts and opportunities are not made use instead we have completely customized, the solution is deployed on premises.
Challenges: to build/develop certain reports which are very much essential for daily operations and monthly reports and analytics. At present we are taking csv dump from crm and preparing it manually by applying formulas, this is time consuming and resource dependent and as reports are not ready made available therefore end users to depend on the technical resource to export the reports and bring it to the required format and then provided to the end users. We also require analytics from the CRM data.
We are planning to implement SQL Server Reporting Services (SSRS) and integrate with Power BI for analytics the data source will be CRM application either integrated OR excel as input to the SQL Server Reporting Services (SSRS) or Power BI.
Please suggest will this approach work for us.

3 Comments

Hi All,

We are looking for an analytics product to report on our usage of our on-premises Mitel VoIP system and Skype for Business Online. Can anyone recommend a product?
Reporting for Skype for Business Online is the priority, but we will likely need both in the future.
We are a medium sized charity and so our budget is limited.

Cheers, Ian

1 Comment

Hi all,

I have a report that was created a long time ago in Cognos 8, then migrated in 10 and now in C11.
In this report, there was a query with "Override dimension info" = Yes. If I remember correctly, this was necessary in the past due to the fact that the query is based on native SQL and used for a graph.
Now, when validating the report in Cognos Analytics, I get the warning "XQE-WRN-0018 The dimensionInfo in V5 query has been deprecated. The query will be planned regardless of dimensionInfo.", even if the report is running fine.
What should I do there? What is the impact of this warning? Performance?
Thanks
Vinc

0 Comments

This is the error log when I run spotfire automation file in scheduler. Can someone help me resolve it please.

Info;19-06-19 08:47:35.463;3216;Program;Starting application using command line 'O:\Engineering\OA_RTA\RTA Area Projects\dian Hills\Spotfire.Dxp.Automation.ClientJobSender.exe.config"http://SpotfireServer:8080/ O:\Engineering\OA_RTA\RTA Area Projects\dian Hills\SF_export.XML'
Error;19-06-19 08:47:35.463;3216;Console;Unsupported URL scheme 'file' for server url.
Error;19-06-19 08:47:35.479;3216;Console;Incorrect parameters to the application.
Info;19-06-19 08:47:35.479;3216;Console;Usage:
Info;19-06-19 08:47:35.479;3216;Console;Spotfire.Dxp.Automation.ClientJobSender <serverUrl> <jobFilePath> [async]
Info;19-06-19 08:47:35.479;3216;Console;
Info;19-06-19 08:47:35.495;3216;Console;Example:
Info;19-06-19 08:47:35.495;3216;Console;Spotfire.Dxp.Automation.ClientJobSender "http://SpotfireServer:8080/" "C:\Path\jobfile.xml"
Info;19-06-19 08:47:35.495;3216;Console;
Info;19-06-19 08:47:35.495;3216;Console;Asynchronous example, do not wait for the result of the job execution, exits immediately with code 0:
Info;19-06-19 08:47:35.510;3216;Console;Spotfire.Dxp.Automation.ClientJobSender "http://SpotfireServer:8080/" "C:\Path\jobfile.xml" async
Info;19-06-19 08:47:35.510;3216;Console;
Info;19-06-19 08:47:35.510;3216;Console;To encrypt the password in the configuration file run the following command:
Info;19-06-19 …

0 Comments

Hello,

I need to develop python code using cm_client . We have 15 clusters on different cloudera managers . I have to develop one script that collects all information from different cloudera manager . How it is possible ? Please let me know .

At least give me syntax how to connect one cloudera manager one after another .

Thanks
Shaiukh

0 Comments

I want to access my raw data email event opens connected to google analytics

I have embedded the event tag in the email with a cid=customerdatabase_id

Is this possible using Google Analytics API.... if so how?

1 Comment

Hi I am relatively new to SQL, so please forgive the basic nature of the question

I have a table (called Opportunities) with a number of fields including
Country
Sales Stage
Amount

The sales stage contains a value "Stage 1" , "Stage 2", "Stage 3", "Stage 4"

What I want to do is create a new table (Called StageAmounts) with the following fields

Country, "Stage 1", "Stage 2", "Stage 3", "Stage 4"

However not all the country and stage combinations will have an amount, it will not be 0 the data will just not exist in the Opportunities Table

Therefore how can i create the StageAmounts Table, with a fully populated dataset with 0's (or blanks) where there is no corresponding data in the Opportunities table.

Many thanks for any assistance

Steve

4 Comments

How to Generate Services Revenue the Easiest Way

This Tuesday! Learn key insights about modern cyber protection services & gain practical strategies to skyrocket business:

- What it takes to build a cloud service portfolio
- How to determine which services will help your unique business grow
- Various use-cases and examples

Having trouble parsing JSON data in Azure Stream analytics for PowerBI, My device message data is passed to my IOT hub through an MQTT server in JSON format, the message data gets sent in with the following format.

{
  "body": {
    "timestamp": 1551731885318,
    "values": [
      {
        "id": "Channel2.Device1.Rtag1",
        "v": 26738,
        "q": true,
        "t": 1551731884050
      }
    ]
  },
  "applicationProperties": {
    "topic": ""
  }
}

Open in new window

My Azure Stream Analytics query currently just uses a wildcard to scan this message, and routes each message directly to powerBI unchanged.

[{"body":{"timestamp":1551726708054,"values":[{"id":"Channel2.Device1.Rtag1","v":25520,"q":1,"t":1551726704055}]},"applicationProperties":{"topic":""}}]

The problem, is when this gets passed to PowerBI, if I chart Timestamp/Value, then each timestamped datapoint on the chart will be valueless, as the corresponding value is "array".

I need to edit my query to pass the "v":25520, along to power BI rather than the entire array.

I understand the JSON hierarchy, but am new to SQL and am not sure how to pass the different values within my device message as separate properties that can be selected in PowerBI

0 Comments

We have a form on a site that displays a thank you page to the user when the form sends successfully. The thank you page contains Google Analytics and Google Ads tracking code, which logs a conversion when the code in fired by the thank you page. Now the client requires the form post to their third party CRM. How would can we use our thank you page to continue to post to Google Analytics when the form is posting to a url we don't control for processing?

7 Comments

I use 3 to 4 websites to verify IP addresses and I keep receiving comflicting information as to knowing where a specific IP originates when doing security analytics. Is there a trustworthy website for this?

5 Comments

I have an applications portal that generates charts and I am looking for a visualization software that is top notch, integrates well, but won't break the bank...

Power BI
Pentaho
Jaspersoft
Zoho Analytics

Has anyone found a really good write up on comparisons?

5 Comments

I have an interesting request to build or advise on an expert system, now known more commonly as a KBS or Knowledge Based System.

The reason is that this team are encountering many examples of same or similar problems, where they spend a lot of time re-inventing similar solutions. Ideally, they need a database that can intelligently and [semi]automatically connect the dots between hundreds of similar problems and solutions; in other words, an inference engine connected to a database.

Criteria
1. Search results need a trust raking for the likelihood of a correct solution.
2. New information (problems and solutions) must be easy for a technician to enter, and in a structured format.
3. Database must be both machine and human readable.
4. Must be OS agnostic (web based).

So far, I have found a lot of technical and conceptual papers on this subject, but I haven't found a ready to use application. :(
FYI, here is an interesting document from AAAI: https://www.aaai.org/Papers/IAAI/2005/IAAI05-014.pdf

Questions?
1. Can this be accomplished, as an add-on, with the tools we already own?
2. What KBS systems are available that are either open-source, free, or relatively inexpensive?

We currently use Confluence, Confluence Questions, Jira, Bitbucket, Freshworks Freshservice, and Slack. I have reviewed many of the plugins available and none seem to offer KBS-like functionality. :(

Google Search?
Search results seem to be help desk …

3 Comments

Cognos 11.0.12 Multiple Search on Data in a Cube MDX- Are there Wildcards for this?

Are there wildcards to search data in a multidimensional cube? I can easily search for 1 record by entering my item #, but are there wild cards for searching a multidimensional cube?

Wildcards - for example - 1234%, 1435%
Search-are-there-wildcards.docx

0 Comments

Analytics

Related Topics

Analytics

Related Topics