Creating Python Visuals
Hi, Hoping someone can help me. I'm trying to create a custom Python visual (ridge plot) using the following fields : (The Compliance (data type: Text) and Assignment Number (data type: Text) fields are from 2 different tables) # The following code to create a dataframe and remove duplicated rows is always executed and acts as a preamble for your script: dataset = pandas.DataFrame(Compliance, Assignment Number) dataset = dataset.drop_duplicates() import seaborn as sns import matplotlib.pyplot as plt import pandas as pd # Paste or type your script code here: ridge_plot = sns.FacetGrid(dataset, row="Compliance", hue="Compliance", aspect=5, height=1.25) # Use map function to make density plot in each element of the grid. ridge_plot.map(sns.kdeplot, "Assignment Number", clip_on=False, shade=True, alpha=0.7, lw=4, bw_method=.2) ridge_plot.map(plt.axhline, y=0, lw=4, clip_on=False) ridge_plot.savefig("Ridge_plot.png") When I try to create the visual, I get the below error: I have two questions: Can I create a dataset, for my Python custom visual, from 2 tables that have a one-many relationship ? Also do you know why I'm getting the above error ? Many thanks Also do you know why I'm getting the above error ?Percentage of Total with Filter
Hi, I'm calculating % of total by calculating a new measure by this formula:- FY21 Q1 ACTUAL = DIVIDE(SUM('Page1'[Q1 FY21]),CALCULATE(SUM('Page1'[Q1 FY21]),ALLSELECTED('Page1'[Domain]))) But when i'm applying filters to the "domain/sub-group" then "FY21 Q1 ACTUAL" values are being changed. My goal is to keep the FY21 Q1 actual value as it is same even after applying "sub-group/domain" level filter in another sheet/table. . Please help me...
